À propos du poste
Mission Overview
Keystone Solutions is seeking a Data Engineer specializing in Microsoft Fabric for a consultancy mission at a client site. The client is modernizing their data platform by migrating to Microsoft Azure and adopting powerful tools such as Microsoft Fabric (ETL) and Power BI. As a consultant, you will play a crucial role in this transformation.
Responsibilities
- Design and implement BI-oriented data models following the Kimball/snowflake methodology based on business needs and technical requirements.
- Develop fact tables, dimensions, and aggregates in the Data Warehouse while respecting priorities and timelines.
- Develop ETL flows in Microsoft Fabric (Dataflows Gen2, Notebooks PySpark, Pipelines) on Azure Cloud.
- Ensure the quality, reliability, monitoring, and performance of processes and flows.
- Manage monitoring, traceability, alerts of flows, and rejections.
- Automate deployments with CI/CD (Azure DevOps or GitHub).
- Work closely with the ICT team to ensure system and solution coherence.
- Connect to various sources (Oracle, SQL Server, XML, Flat files, etc.), understand their structure, and optimize extractions.
- Adhere to defined technical standards: naming, security, governance, monitoring, CI/CD.
- Follow internal guidelines and procedures at both technical and organizational levels.
- Document processes and flows.
Technical Skills
- Microsoft Fabric: Lakehouse, Dataflows Gen2, Pipelines, Warehouse
- Azure: Azure Data Lake, Azure Synapse (a plus)
- Source databases: excellent mastery of Oracle and SQL Server (connection, extraction, query optimization)
- SQL: advanced level
- PySpark: distributed processing for large volumes of data
- Data warehouse concepts
- Semantic models in Power BI
- DAX
- Kimball modeling: Star Schema & Snowflake, Slowly Changing Dimensions (SCD)
- ETL/ELT: best practices for sequencing and monitoring
- CI/CD: Azure DevOps or GitHub Actions
- Data security and governance on Azure
- Knowledge of Sparx Enterprise Architect for documentation and modeling is a plus
- Knowledge of Informatica Powercenter (or willingness to learn) is a plus
Profile
- Bachelor's degree in Computer Science or equivalent experience
- Minimum of 8 years of experience in Data Engineering, including at least 3 years in Fabric on Azure Cloud
- Proven mastery of the Kimball methodology for BI
- Confirmed experience with Oracle and SQL Server databases
- Confirmed experience with semantic models in Power BI
- Ability to optimize performance and document processes
- Ability to work in a team while respecting governance and internal procedures
- Fluent in French/Dutch with a good passive knowledge of the other language (mandatory)
Why Join Keystone Solutions
- Consultancy Nature: Engage in on-site work and embrace your consultant identity.
- Dynamic Projects: Tackle diverse challenges across various client environments.
- Turbo-Charged Learning: Experience professional development and broad learning opportunities.
- Skyrocketing Ambition: Commit to your career growth within our framework.
- Values: As a
Duration: 04/01/2027 - 30/06/2027 6 months • (full time)
Skills required
- data engineeringConfirmé
- Fabric op Azure CloudJunior
Language requirements
- NéerlandaisLangue maternelle
- AnglaisConnaissance active
- FrançaisLangue maternelle