Data Warehouse & BI Engineer

Description

Summary: Ivy Partners is seeking a Data Warehouse & BI Engineer to design, develop, and maintain data solutions, ETL pipelines, and reporting dashboards. Highlights: 1. Design and maintain data models, data warehouse, and data marts architecture. 2. Develop and optimize ETL pipelines using SSIS and modern orchestration. 3. Implement dashboards and reporting in Power BI / Microsoft Fabric. **Our Mission** Ivy Partners is a Swiss consulting firm dedicated to helping businesses navigate strategic, technological, and organizational challenges. We are committed to providing our employees with a career that supports both their personal and professional growth. We assist in skill development and offer genuine career advancement opportunities. **As a Data Warehouse \& BI Engineer at Ivy Partners, you will:** * Design and maintain data models and the architecture of the data warehouse and data marts. * Develop and optimize ETL pipelines (using SSIS and modern orchestration). * Transform business requirements into scalable data solutions. * Implement dashboards and reporting in Power BI / Microsoft Fabric. * Ensure data quality, consistency, and integrity. * Support ad\-hoc analysis for stakeholders. **About You** **You are our ideal candidate if you:** * Have up to 2 years of experience in BI, data warehousing, and ETL. * Hold a degree in Computer Science, BI, or a related field. * Possess hands\-on experience with SQL, including performance tuning. * Have knowledge of SSIS and SSAS. * Experience with Power BI in creating reports and dashboards. * Understand data governance, data quality, and data security. * Are collaborative and problem\-solving oriented. * Appreciated: Experience with Data Vault, cloud technologies (Azure/Snowflake/BigQuery), Python/R, exposure to data science pipelines. **Why Join Ivy Partners?** * **Care** \| We care about our employees by creating a supportive environment where everyone is valued and empowered with training and growth prospects. * **Trust** \| We believe in building strong and long\-lasting relationships with our clients. Working with us is about establishing a partnership based on trust, professionalism, and transparency at all times. * **Innovation** \| We empower effective digital transformation through a unique blend of innovative technology and creative thinking. * **Responsibility** \| Community is at the heart of everything we do, and we take that responsibility seriously by working hard to create a positive impact.