BI Data Engineer – SQL Server & Azure

Responsibilities

• Design and maintain complex ETL and ELT processes to integrate data from various internal and external sources.
• Develop and optimize data warehouses and datamarts using dimensional modeling techniques such as Kimball.
• Implement data solutions across both on-premises and cloud environments to support platform modernization.
• Monitor and ensure the performance, stability, and scalability of the business intelligence platform.
• Provide technical support and expertise to other developers regarding complex data integration and performance issues.
• Draft and maintain technical documentation to ensure the continuity and quality of the data architecture.

Requirements

• You bring 5+ years of experience in Business Intelligence, data engineering, or data warehousing.
• You possess advanced proficiency in Microsoft SQL Server, T-SQL, and SSIS.
• You have extensive knowledge of Kimball methodology and dimensional modeling including star and snowflake schemas.
• You have experience implementing data solutions with Microsoft Azure Data Services and Microsoft Fabric.
• You possess a strong background in developing ETL and ELT processes.
• You have familiarity with Data Lake solutions and modern data architectures.
• You possess a Bachelor or Master degree in Computer Science or equivalent through experience.
• You're proactive, solution-oriented, and have strong analytical skills.
• You are a native speaker of Dutch or French with a good understanding of the second language.

Nice to Haves

• Experience with Azure Data Factory and Power BI.
• Knowledge of Spark and Python.
• Proficiency with Git and Azure DevOps.
• Understanding of Data Vault modeling.