Microsoft Fabric Senior Data Engineer

Role purpose
Design, build, deploy, and support enterprise data solutions on Microsoft Fabric, owning delivery from source integration through to reliable, business-ready datasets.

Required experience and qualifications

• 5+ years of data engineering experience, including at least 1-2 year of hands-on Microsoft Fabric implementation.
• Proven delivery of at least one end-to-end Fabric solution running in production, including deployment and post-go-live support.
• Active Microsoft Certified: Fabric Data Engineer Associate (DP-700) certification, supported by a verifiable credential link.
• Relevant degree or equivalent professional experience.

Mandatory technical requirements

• Architecture: OneLake, Lakehouse, Warehouse, Delta tables, and Bronze/Silver/Gold architecture, with the ability to explain design choices and tradeoffs.
• Data integration: Fabric Data Factory pipelines, Dataflows Gen2, notebooks, and integration with databases, APIs, files, and enterprise applications.
• Programming: Strong SQL/T-SQL and Python/PySpark for transformations, troubleshooting, and reusable processing logic.
• Loading patterns: Full and incremental loads, change-data capture where supported, upserts, deduplication, schema changes, and late-arriving data.
• Modeling and quality: Dimensional modeling, fact/dimension tables, slowly changing dimensions, validation rules, and source-to-target reconciliation.
• Orchestration: Parameterized pipelines, dependencies, scheduling, logging, alerts, retries, and safe reruns without duplicating data.
• Security and governance: Workspace and item permissions, data-level access controls, secure connections, sensitivity labels, and lineage.
• Deployment: Git integration, deployment pipelines, and controlled promotion across development, test, and production.
• Performance and operations: Spark/SQL tuning, Delta table optimization, production troubleshooting, and capacity consumption analysis using Fabric Capacity Metrics.
• Analytics integration: Curated datasets for Power BI and an understanding of semantic models, Direct Lake, and refresh dependencies.

Business and delivery requirements

• Proven experience across at least two business domains, preferably three, such as Procurement, HR, Finance, Sales, or Inventory, supported by real delivered projects.
• Ability to explain each domain’s business processes, key KPIs, source data, reporting requirements, and their personal contribution to implementation.
• Translate business requirements into documented data mappings, transformation rules, and acceptance criteria.
• Understand data grain, business keys, historical reporting, and reconciliation requirements.
• Communicate clearly with business stakeholders, architects, analysts, and source-system teams.
• Own estimates, delivery commitments, testing, UAT support, documentation, and operational handover.
• Explain technical decisions in terms of business value, cost, performance, and reliability.

Preferred qualifications

• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600).
• Experience integrating Dynamics 365/Dataverse, SAP ECC, S4HANA , or other ERP/CRM platforms.
• KQL, Eventstreams, Eventhouse, and real-time processing experience.
• Azure Data Factory, Azure Databricks, ADLS Gen2, and Microsoft Purview experience.
• Client-facing consulting experience.