Lead Data Architect

Overview

Remote
$77 - $88
Contract - W2

Skills

Enterprise Data Architecture
Data Engineering
Leadership
Data Warehouse Solutions
Microsoft Fabric
Azure Synapse Analytics
Azure Data Factory
Azure SQL
OneLake
Azure Services
Dataflows Gen2
Notebooks
Spark
Data Modeling
Conceptual Data Modeling
Logical Data Modeling
Physical Data Modeling
ELT Design
BI Integration
Tableau
Power BI
Infrastructure as Code
Bicep
ARM Templates
Communication Skills
Stakeholder Management
Documentation Skills
Data Governance
Data Security
Security Best Practices

Job Details

  • We are seeking a highly experienced Lead Data Architect to lead the design, development, and delivery of a modern, cloud-native data infrastructure solution for an education customer! Dahl Consulting is currently partnering with a leading software company. We work one-on-one with great candidates to help connect them with employment opportunities. We are hiring a Lead Data Architect for a contract role. Interested? Get more details below!
    • Contract Duration: 8 months
    • Worksite Location: Remote
    • Compensation: $77.00-$88.00 per hour
    What you ll do as the Lead Data Architect:
    • Lead discovery and design of Microsoft Fabric data warehouse architecture
    • Conduct stakeholder interviews to capture data requirements and reporting needs
    • Analyze current-state data sources including SQL Server, Google BigQuery, and dbt-based pipelines
    • Design conceptual and logical data models, data ingestion strategies, and integration flows
    • Architect and guide implementation of ELT pipelines using Azure Data Factory, Fabric Data Pipelines, and Notebooks
    • Migrate data from legacy systems to Microsoft Fabric and OneLake
    • Enable BI tool integrations (Tableau, Power BI) with curated datasets
    • Provide architectural oversight and support throughout implementation, knowledge transfer, and operational handoff
    • Deliver high-quality technical documentation and training for internal teams
    What you need to be a Lead Data Architect:
    • 10+ years of experience in enterprise data architecture and engineering.
    • Proven leadership in designing and delivering large-scale data warehouse solutions.
    • Hands-on expertise with Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, Azure SQL, OneLake, and related Azure services, Dataflows Gen2, Notebooks, and Spark
    • Strong data modeling (conceptual, logical, physical) and ELT design experience
    • Experience with BI integration (e.g., Tableau, Power BI)
    • Familiarity with infrastructure-as-code (e.g., Bicep, ARM templates)
    • Excellent communication, stakeholder management, and documentation skills
    • Strong understanding of data governance and security best practices


    As an equal opportunity employer, Dahl Consulting welcomes candidates of all backgrounds and experiences to apply. If this position sounds like the right opportunity for you, we encourage you to take the next step and connect with us. We look forward to meeting you!

    Dahl Consulting is proud to offer a comprehensive benefits package to eligible employees that will allow you to choose the best coverage to meet your family s needs. For details, please review the DAHL Benefits Summary:
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.