Data Architect / Sr. Data Engineer

Resolution Technologies, Inc.; Atlanta (GA); On-site; USD 96,000 - 165,000; Full time

Job summary

Resolution Technologies, Inc. is leading a 16-week project to consolidate onto Microsoft Dynamics 365 F&SCM, building the data foundation on Microsoft Fabric. You will own the Fabric environment setup,Medallion architecture (Bronze/Silver/Gold), and integrate D365 data via Fabric Link/Dataverse.

The role requires hands-on Medallion design on Fabric, including Lakehouses, OneLake, and Fabric Data Factory pipelines, plus experience with Snowflake and Dynamics 365 data models to enable analytics.

Qualifications

• Experience designing Medallion architectures on Microsoft Fabric (Bronze/Silver/Gold).
• Hands-on with Microsoft Fabric components: Lakehouses, OneLake, Fabric Data Factory pipelines.
• Knowledge of D365 Finance & SCM data models and Dataverse/Fabric Link integration.
• Strong data modeling for Silver/Gold layers, including Type 2 Slowly Changing Dimensions.
• Experience building and validating end-to-end ETL pipelines.

Responsibilities

• Own Fabric environment setup and Medallion architecture build (Bronze/Silver/Gold) and integrate D365 data via Fabric Link/Dataverse.
• Review existing Snowflake environment and design ingestion/ transformation pipelines for consolidation.
• Design and build Medallion architectures on Microsoft Fabric including Lakehouses, OneLake, and Fabric Data Factory pipelines.
• Ensure Medallion architecture supports reporting/analytics requirements.
• Apply knowledge of D365 data models and Dataverse/Fabric Link integration in the target architecture.
• Model Silver/Gold layers with source-to-target mapping and SCD handling.
• Develop and validate ETL pipelines across sources and targets.
• Evaluate legacy/3rd-party data platforms (Snowflake) for integration into the new target architecture.
• Unify data from multiple sources into a single dataset and implement CI/CD patterns (Development LCS).

Skills

Medallion architecture

Microsoft Fabric

Lakehouses

Fabric Link/Dataverse

ETL pipelines

Data modeling

Type 2 SCD

CI/CD patterns

Tools

Snowflake

Dataverse

Fabric Data Factory

OneLake

Job description

• 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.
• Duration: 16 weeks
• 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.
• 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