Senior Data Engineer / Data Architect – Microsoft Fabric
Our client is seeking two experienced Senior Data Engineers / Data Architects for a consulting engagement supporting an enterprise Microsoft Dynamics 365 Finance & Supply Chain Management (D365 F&SCM) implementation. Our client is building a new data foundation using Microsoft Fabric , and needs hands-on engineers who can design the architecture, build the data pipelines, and integrate information from multiple business systems. This role is ideal for someone who has personally implemented Microsoft Fabric solutions and understands how to structure enterprise data for reporting and analytics.
What You Will Do
Design and configure a Microsoft Fabric environment using OneLake, Lakehouses, and Fabric Data Factory. Build a Medallion architecture with Bronze, Silver, and initial Gold data layers. Develop data ingestion and transformation pipelines integrating Dynamics 365 F&SCM through Dataverse and Fabric Link. Design data models and source-to-target mappings, including Type 2 Slowly Changing Dimensions (SCD Type 2). Consolidate data from multiple source systems into unified datasets supporting enterprise reporting and analytics. Evaluate an existing Snowflake environment and identify integration requirements. Develop, test, and validate ETL/ELT pipelines to ensure data quality and reliability. Implement CI/CD processes supporting data platform development and deployment. What We Are Looking For Hands-on experience implementing Microsoft Fabric data solutions, including Lakehouses, OneLake, and Fabric Data Factory pipelines. Demonstrated experience designing and building Medallion architectures (Bronze, Silver, Gold). Experience integrating Dynamics 365 F&SCM data through Dataverse or Fabric Link. Strong SQL, data modeling, source-to-target mapping, and ETL/ELT development experience. Experience designing dimensional models and implementing SCD Type 2. Experience integrating multiple data sources into a centralized analytics environment. Experience implementing CI/CD and development lifecycle practices. Ability to own both technical architecture decisions and hands-on engineering delivery. Preferred Experience Snowflake data platform experience. ERP data integration and modernization projects. Enterprise reporting and analytics data architecture.