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.