Data Architect / Sr. Data Engineer

Data Architect/Senior Data Engineer Data Architect/Senior Data Engineer Project Overview

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