Data Warehouse Analyst (m/f/d) 80-100%
We are seeking a skilled and detail-oriented Data Warehouse Analyst to join our client ´s team. As a Data Warehouse Analyst, you will play a crucial role in ensuring the accuracy, availability, and usability of data within the data warehouse. Your expertise in data analysis, reporting, and data quality assurance will contribute to the successful delivery of business insights and support data-driven decision making. If you have a strong analytical mindset, a passion for data integrity, and the ability to derive actionable insights from complex datasets, we invite you to apply for this exciting opportunity.
Responsibilities:
- Analyze and interpret data requirements from business stakeholders to support data warehouse design and development
- Collaborate with the Data Warehouse Engineer and business users to define data extraction, transformation, and loading (ETL) requirements
- Design and implement data quality checks, data cleansing processes, and data validation procedures to ensure the accuracy and integrity of data
- Develop and maintain data models, metadata repositories, and data dictionaries for the data warehouse
- Design and create meaningful and insightful reports, dashboards, and visualizations using BI tools to communicate data insights to stakeholders
- Conduct data profiling and analysis to identify data anomalies, trends, and patterns, and provide recommendations for data improvement
- Collaborate with cross-functional teams, including business analysts, database administrators, and data engineers, to support data integration and data governance initiatives
- Monitor data warehouse performance, identify areas of improvement, and propose optimization strategies
- Stay up-to-date with industry best practices, emerging technologies, and trends in data warehousing and analytics
Qualifications:
- Bachelor's degree in Computer Science, Information Systems, Statistics, or a related field. Advanced degree is a plus
- Proven experience as a Data Warehouse Analyst or in a similar analytical role
- Strong analytical and problem-solving skills with the ability to work with complex datasets and derive actionable insights
- Proficiency in SQL and experience with data visualization tools
- Understanding of data warehousing concepts, data modeling, and ETL processes
- Familiarity with data quality management principles, practices, and tools
- Experience with data profiling and data analysis techniques
- Strong attention to detail and ability to perform data validation and quality assurance activities
- Excellent communication and presentation skills to effectively convey complex data insights to stakeholders
- Knowledge of business domains such as sales, finance, or operations is advantageous
- Familiarity with programming languages such as Python or R is a plus
- German B2 / English B2 level
Roman Bättig, Talent Manager
+41 76 415 82 22
rb@cybergap.io