Hyertek28.02.26
AI SCORE 8.5

Data Architect - Microsoft Solutions

$130K–$150K/year

About the Role

HyerTek is seeking a Data Architect remote to lead the design, governance, and evolution of data architectures across various sectors. As a Data Architect remote, you will collaborate with our solutions team and client stakeholders to assess existing data environments and define target-state architectures.

What You'll Do

  • Design and maintain enterprise data models across Dynamics 365 / Dataverse, Azure SQL, and Microsoft Fabric.
  • Define target-state data architectures for client engagements, mapping from legacy source systems to production environments.
  • Establish data governance frameworks, including ownership, quality rules, lineage documentation, and lifecycle management.
  • Architect ETL/ELT patterns and integration strategies using Azure Data Factory and Fabric pipelines.
  • Design the semantic and reporting layer in Power BI, including dimensional models and dashboard frameworks.
  • Evaluate and rationalize client data landscapes, identifying redundancy and integration risks.
  • Set standards for data migration into Dataverse and D365, ensuring referential integrity and validation criteria.
  • Connect data architecture across Power Platform apps for end-to-end traceability.
  • Produce and maintain architecture artifacts such as data flow diagrams and integration specifications.

Requirements

  • Eligibility for an Active Secret clearance; U.S. citizenship required.
  • 5+ years of experience with the Microsoft data stack, demonstrating architecture or lead-level responsibility.
  • Deep experience with Dataverse / D365 data modeling and governance.
  • Strong Power BI architecture skills, including star/snowflake modeling and DAX optimization.
  • Experience designing data integration and migration architectures.
  • Working knowledge of Microsoft Fabric for lakehouse architecture and data integration.
  • Solid SQL skills and familiarity with scripting in Python or PowerShell.
  • Prior work in DoD or federal IT environments is a plus.

What We Offer

  • Competitive salary range of $130,000 – $150,000 annually.
  • Opportunity to work in a fast-paced, innovative environment.
  • Comprehensive benefits package including health and wellness programs.
  • Remote work flexibility.
  • Professional development opportunities.
Why This Job8.5 of 10

This Data Architect remote position at HyerTek offers a competitive salary and the chance to lead innovative data architecture projects in a dynamic environment.

Salary Range
Required
0/1
Optional
0/1
Bonus
0/1

Who Will Succeed Here

Expert in Dataverse and Azure SQL with a strong understanding of data governance principles, capable of designing scalable data architectures that align with business goals.

Self-motivated and disciplined remote worker who thrives in a results-oriented environment, effectively managing time and priorities while collaborating across different time zones.

Proficient in ETL processes and data transformation using Python and PowerShell, with a mindset focused on optimizing data pipelines and ensuring data integrity.

Learning Resources

Microsoft Dataverse Documentationguide

Career Path

Data Architect - Microsoft Solutions(Now)Lead Data Architect(1-2 years)Director of Data Architecture(3-5 years)

Market Overview

Market Size 2024
$7.5B
Annual Growth
22.5%
AI Adoption
65%
Investment
+150%
Labour Demand
+30%
Avg Salary
$130K

Skills & Requirements

Required
DataverseAzure SQLPower BI
Growing in Demand
Azure Data FactoryMachine LearningData Governance
Declining
SQL Server Reporting Services (SSRS)Traditional ETL Tools

Domain Trends

Increased Cloud Migration
Organizations are migrating to cloud-based solutions, with 75% of enterprises planning to adopt Dataverse by 2025.
Integration of AI in Data Solutions
AI tools are increasingly integrated into data architecture, with a projected 40% of data professionals using AI-driven analytics by 2024.
Focus on Data Privacy and Compliance
With regulations like GDPR and CCPA, 60% of companies are prioritizing data governance frameworks in their data architecture strategies.

Industry News

Loading latest industry news...

Finding relevant articles from the last 6 months

All job postings are automatically gathered by algorithms. We do not review or verify listings, be careful when applying and do not sign-in with iCloud or Google services.