Data Architect: Medallion Lakehouse on Microsoft Fabric

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

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.