Join our team as a Data Warehouse System Analyst and be a key player in managing and leveraging our company's data assets to drive business growth and success.
Position: Data Warehouse System Analyst
Overview: As a Data Warehouse System Analyst, you will be responsible for the overall design, development, and maintenance of our company's data warehouse system. You will work closely with cross-functional teams to identify business needs and translate them into technical solutions that support our company's data management and reporting processes. This role requires a strong understanding of data warehousing concepts, database design, and data integration techniques.
Key Responsibilities:
- Collaborate with business stakeholders to understand their data needs and requirements
- Design and maintain data warehouse architecture, including data models and ETL processes
- Develop and maintain data dictionaries, data flow diagrams, and other technical documentation
- Monitor data warehouse performance and troubleshoot any issues that arise
- Perform data analysis to identify data quality issues and develop solutions to address them
- Develop and implement data security and access controls to ensure data privacy and integrity
- Conduct regular data warehouse audits to ensure data accuracy and consistency
- Identify opportunities for data warehouse optimization and make recommendations for improvement
- Stay updated with industry trends and best practices in data warehousing and make recommendations for adoption
- Train end-users on data warehouse tools and processes to ensure proper utilization and understanding of data
Qualifications:
- Bachelor's degree in Computer Science, Information Systems, or a related field
- Minimum of 3 years of experience in data warehousing, database design, and ETL processes
- Strong knowledge of SQL and experience with database management systems (e.g. Oracle, SQL Server)
- Experience with data visualization tools (e.g. Tableau, Power BI) is a plus
- Experience with cloud-based data warehousing solutions (e.g. AWS Redshift, Google BigQuery) is a plus
- Excellent analytical and problem-solving skills
- Strong communication and interpersonal skills to effectively collaborate with cross-functional teams
- Ability to work independently and manage multiple projects simultaneously
- Knowledge of data privacy and security regulations (e.g. GDPR, CCPA) is a plus
Apply now and be part of a dynamic and innovative organization!.