SENIOR BI DATA ENGINEER – SQL SERVER / SSIS / AZURE

Project overview

Mission Context

As part of strengthening its Business Intelligence team, our client is looking for a Senior BI Data Engineer to be involved in the design, development, and maintenance of its Data & BI environment.

You will join an existing BI team and act as a technical referent for complex Data Engineering, data integration, and data modeling issues.

The objective is to ensure the reliability, performance, and scalability of the Data platform, while technically supporting ETL and BI developers in their work.

Responsibilities

Essential Technical Skills

Skills that are an asset

• Design, develop, and maintain ETL/ELT pipelines.
• Integrate data from internal and external sources.
• Design, evolve, and optimize Data Warehouses and Data Marts.
• Implement dimensional data models according to Kimball best practices.
• Develop and optimize Data solutions in On-premise and Cloud environments.
• Ensure the performance, stability, and scalability of processes and Data platforms.
• Address complex technical issues related to SQL Server, SSIS, data flows, and modeling.
• Support ETL/BI developers in resolving technical problems and optimizing their developments.
• Contribute to the definition and application of technical standards and best practices.
• Ensure technical documentation of implemented solutions.
• Proven experience in Business Intelligence, Data Engineering, or Data Warehousing.
• Excellent command of Microsoft SQL Server and T-SQL.
• Solid experience in developing and optimizing ETL/ELT processes.
• Mastery of SSIS (SQL Server Integration Services).
• Experience in designing and optimizing Data Warehouses and Data Lakes.
• Mastery of dimensional modeling: Kimball, star and snowflake schemas.
• Experience in data integration and data quality management.
• Good knowledge of modern Data architectures and hybrid On-premise / Cloud environments.
• Experience with Microsoft Azure Data services and/or Microsoft Fabric.
• Azure Data Factory.
• Power BI.
• Spark.
• Python.
• Git.
• Azure DevOps.
• Data Vault.

Project details

• Start: flexible
• Remote: hybrid
• Location: Brussels, Belgium, BE
• Languages: French