Data Architect

Overview

On Site
Accepts corp to corp applications
Contract - 12 month(s)

Skills

Azure
ETL
Data Architect
Dynamics 365
Databricks

Job Details

Hi,

Our client is looking for an Data Architect with a Contract project in Multi Location (All over US) below is the detailed requirement.

Position: Data Architect

Location: Multi Location (All over US)

Job Mode: Contract

Job Description:

  • Data Migration Strategy & Execution
  • Define and lead the end-to-end data migration strategy from legacy systems (e.g., AX 2009) to Dynamics 365 CE & F&O.
  • Design and implement data extraction, transformation, and loading (ETL/ELT) pipelines using Azure Data Factory and Informatica.
  • Ensure data quality, consistency, and completeness across all migrated datasets.
  • Data Modeling & Architecture
  • Design and implement enterprise data models aligned with the Databricks Medallion architecture:
    • Bronze Layer: Raw ingestion from APIs, flat files, and FTP/SFTP sources
    • Silver Layer: Cleaned and structured data
    • Gold Layer: Curated, business-ready data for consumption and reporting
    • Define data lineage, metadata, and governance standards using Unity Catalog and Azure Purview.
    • Integration & Real-Time Enablement
  • Support real-time and batch data ingestion from diverse sources including:
    • Shelter LOB systems, PetProPortal, SFCC, Vetco, Dropbox, and FTP endpoints
    • Azure Event Hub, Logic Apps, and Function Apps
    • Enable data synchronization with Dynamics 365 and downstream systems via APIs and Dataverse.
    • Collaboration & Governance
    • Collaborate with enterprise architects, data engineers, and business analysts to align data models with business needs.
    • Establish data validation, reconciliation, and exception handling frameworks.
    • Participate in data governance forums and ensure compliance with security and privacy standards.
  • Required Skills & Experience:
    • 10+ years of experience in data architecture, data migration, and enterprise data modeling.
    • Strong expertise in:Azure Data Factory, Databricks, Delta Lake, Informatica ETL, Event Hub, Logic Apps
    • Data modeling tools and techniques (e.g., star/snowflake schemas, dimensional modeling)
    • Experience with Dynamics 365 CE & F&O data structures and legacy system migrations (e.g., AX 2009).
    • Familiarity with Medallion architecture and modern data lakehouse patterns.
  • Preferred Qualifications:
    • Microsoft Certified: Azure Data Engineer Associate or equivalent
    • Experience with Unity Catalog, Azure Purview, and data governance frameworks
    • Familiarity with CI/CD pipelines for data workflows using Azure DevOps
  • Expected Outcomes:
    • Successful migration of legacy data into Dynamics 365 CE & F&O
    • Scalable and governed data foundation using Databricks Medallion architecture
    • High-quality, business-aligned data models supporting analytics and operations
    • Real-time and batch data flows integrated across enterprise systems
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.