Data Architect / Sr. Data Engineer

Data Architect/Senior Data Engineer
Data Architect/Senior Data Engineer Project Overview
Client: The client is consolidating onto Microsoft Dynamics 365 Finance & Supply Chain Management (D365 F&SCM), and our Data & AI team is building the data foundation on Microsoft Fabric to support that rollout.
Start date: Mid-November 2026
Duration: 16 weeks
Data Architect/Senior Data Engineer Responsibilities:
Will own the Fabric environment setup and the Medallion architecture build (Bronze, Silver, and initial Gold layers), integrate D365 data via Fabric Link/Dataverse, review an existing Snowflake environment at one of the client's business units, and build the data ingestion and transformation pipelines.
Data Architect/Senior Data Engineer Skills needed:
Hands-on experience designing and building Medallion (Bronze/Silver/Gold) architectures on Microsoft Fabric, including Lakehouses, OneLake, and Fabric Data Factory pipelines
Thorough understanding of how the Medallion architecture supports reporting and analytics purposes
Experience with Dynamics 365 Finance & Supply Chain Management data models and Dataverse/Fabric Link integration
Strong data modeling skills (source-to-target mapping) for Silver and Gold layer design, including handling of Type 2 Slowly Changing Dimensions
Proficiency in building and validating ETL pipelines
Experience assessing legacy or third-party data platforms (Snowflake a plus) and integrating them into a new target architecture
Experience unifying data from across multiple source systems into a single dataset
Hands-on experience designing and building CI/CD (Development LCS) patterns