Need Sr. Data Migration Architect with Dynamics 365 Migration & Azure Data Platform Exp -100% Remote

Need Sr. Data Migration Architect with Dynamics 365 Migration & Azure Data Platform Exp -100% Remote

Posted 1 week ago by 1752667828

Apply
Negotiable
Outside
Remote
USA
Apply
Application Programming Interface (API) Azure Databricks Azure Data Factory Azure DevOps Bank Reconciliations Continuous Integration and Continuous Delivery Data Architecture Databricks Data Cleansing Data Governance Data Ingestion Data Migration Datamodel Data Modeling Data Privacy Laws Data Quality Data Structures Data Validation DevOps Dimensional Modeling Extract Transform Load (ETL) Informatica Mapping Software Metadata Microsoft 365 Microsoft Azure Microsoft Dynamics Microsoft Dynamics 365 Raw Data Reconciliation Verification And Validation

Summary: The role of Senior Data Migration Architect involves leading the data migration, modeling, and integration strategy for a large-scale transformation to Microsoft Dynamics 365 CE & F&O. The position requires extensive experience with Azure Data Services and a proven track record in delivering high-quality data solutions. The architect will be responsible for defining data migration strategies, developing enterprise data models, and ensuring data governance throughout the migration lifecycle. This is a fully remote position aimed at candidates with significant expertise in data architecture and integration.

Key Responsibilities:

  • Define and own the full data migration strategy from legacy platforms (e.g., AX 2009) to Dynamics 365 CE & F&O.
  • Design and implement robust ETL/ELT pipelines using Azure Data Factory and Informatica to support data movement, transformation, and validation.
  • Ensure high levels of data quality, integrity, consistency, and completeness throughout the migration lifecycle.
  • Establish data cleansing, mapping, and reconciliation frameworks to ensure smooth cutover.
  • Develop scalable, business-aligned enterprise data models based on Databricks Medallion architecture.
  • Define and maintain data lineage, metadata standards, and governance using Unity Catalog and Azure Purview.
  • Optimize data architecture for performance, reusability, and ease of integration with reporting tools.
  • Enable real-time and batch data ingestion from diverse systems.
  • Integrate enterprise data flows via Azure Event Hub, Logic Apps, and Azure Function Apps.
  • Synchronize Dynamics 365 data with downstream applications through APIs, Dataverse, and messaging queues.
  • Partner with enterprise architects, data engineers, BI teams, and business analysts to align data architecture with evolving business needs.
  • Implement end-to-end data validation, reconciliation, and exception-handling frameworks.
  • Ensure data privacy and security compliance in accordance with internal and regulatory policies.
  • Actively contribute to enterprise data governance boards, frameworks, and documentation efforts.

Key Skills:

  • 10+ years of experience in data architecture, enterprise data modeling, and data platform modernization.
  • Proven experience with Azure Data Factory, Databricks, Delta Lake, Informatica ETL, Azure Event Hub, Logic Apps, Star/Snowflake schema, and dimensional modeling techniques.
  • Deep familiarity with Dynamics 365 CE & F&O data structures and legacy systems (e.g., AX 2009).
  • Hands-on experience designing solutions aligned with Medallion architecture and data lakehouse principles.
  • Microsoft Certified: Azure Data Engineer Associate or similar Azure certifications.
  • Experience with Unity Catalog, Azure Purview, data privacy and security frameworks.
  • Familiarity with CI/CD and DevOps practices for data pipelines using Azure DevOps.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Position: Sr. Data Migration Architect -100% Remote

Duration: 6+ months

Location: 100% Remote

We are seeking an experienced and results-driven Senior Data Architect to lead the end-to-end data migration, modeling, and integration strategy as part of a large-scale transformation from legacy systems (e.g., AX 2009) to Microsoft Dynamics 365 CE & F&O. The ideal candidate will have deep expertise in Azure Data Services, Databricks Medallion Architecture, and enterprise data governance, along with a proven track record of delivering scalable, high-quality data solutions in complex enterprise environments.

Key Responsibilities:

Data Migration Strategy & Execution

  • Define and own the full data migration strategy from legacy platforms (e.g., AX 2009) to Dynamics 365 CE & F&O.
  • Design and implement robust ETL/ELT pipelines using Azure Data Factory and Informatica to support data movement, transformation, and validation.
  • Ensure high levels of data quality, integrity, consistency, and completeness throughout the migration lifecycle.
  • Establish data cleansing, mapping, and reconciliation frameworks to ensure smooth cutover.

Enterprise Data Modeling & Architecture

  • Develop scalable, business-aligned enterprise data models based on Databricks Medallion architecture:
  • Bronze Layer: Raw data ingestion from APIs, flat files, FTP/SFTP.
  • Silver Layer: Cleansed, normalized, and structured data.
  • Gold Layer: Curated, analytics-ready data for business consumption.
  • Define and maintain data lineage, metadata standards, and governance using Unity Catalog and Azure Purview.
  • Optimize data architecture for performance, reusability, and ease of integration with reporting tools.

    • Integration & Real-Time Data Enablement

    • Enable real-time and batch data ingestion from diverse systems such as Shelter LOB, PetProPortal, SFCC, Vetco, Dropbox, and FTP endpoints.
    • Integrate enterprise data flows via Azure Event Hub, Logic Apps, and Azure Function Apps.
    • Synchronize Dynamics 365 data with downstream applications through APIs, Dataverse, and messaging queues.

    Collaboration & Data Governance

    • Partner with enterprise architects, data engineers, BI teams, and business analysts to align data architecture with evolving business needs.
    • Implement end-to-end data validation, reconciliation, and exception-handling frameworks.
    • Ensure data privacy and security compliance in accordance with internal and regulatory policies.
    • Actively contribute to enterprise data governance boards, frameworks, and documentation efforts.

    Required Skills & Experience:

    • 10+ years of experience in data architecture, enterprise data modeling, and data platform modernization.
    • Proven experience with:
    • Azure Data Factory, Databricks, Delta Lake
    • Informatica ETL, Azure Event Hub, Logic Apps
    • Star/Snowflake schema and dimensional modeling techniques
  • Deep familiarity with Dynamics 365 CE & F&O data structures and legacy systems (e.g., AX 2009).
  • Hands-on experience designing solutions aligned with Medallion architecture and data lakehouse principles.

    • Preferred Qualifications:

    • Microsoft Certified: Azure Data Engineer Associate or similar Azure certifications.
    • Experience with Unity Catalog, Azure Purview, data privacy and security frameworks.
    • Familiarity with CI/CD and DevOps practices for data pipelines using Azure DevOps.

    Best Regards,

    Chetna

    -D

    -Fax

    Truth Lies in Heart

    Apply
    Similar Jobs
    Loading data...