Data Engineer Microsoft Fabric

Keystone Solutions
Belgium
2 days ago
Apply on www.keystone-solutions.be
Prepare application

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours
Languages
Dutch, French

Tech stack

Microsoft Azure Big Data Databases Continuous Integration Information Engineering Extract Transform Load (ETL) Data Security Data Warehousing Distributed Computing Environment Github Microsoft SQL Server Oracle (Applications)
+13 more
Query Optimization Power BI Azure Data Lake SQL Databases Extensible Markup Language (XML) Informatica Powercenter Snowflake Microsoft Fabric Pyspark Information Technology Deployment Automation Star Schema Azure Synapse Analytics

Job description

  • 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., As a consultant at Keystone Solutions, you will engage in dynamic projects that offer a variety of challenges across different client environments. Our commitment to turbo-charged learning ensures that you will have ample opportunities for professional development and broad learning experiences. We value ambition and are dedicated to supporting your career growth within our framework. Being a β€˜K-Stone’ means bringing our core values to every engagement.

Requirements

  • 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, * 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), * data engineeringConfirmΓ©
  • Fabric op Azure CloudJunior

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.keystone-solutions.be
Prepare application

Good distractions

Loading talks and stories from around this role…