Data Engineer - Microsoft Fabric Lakehouse Architect

The Hunton Group

Houston (TX)

On-site

USD 140,000 - 195,000

Full time

3 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

The Hunton Group is seeking a hands-on Data Engineer to design, build, and maintain a scalable Microsoft Fabric Lakehouse and Warehouse that centralizes enterprise analytics for Power BI users.

You will lead data modeling, ingestion, and delta-loading strategies across Dynamics GP/WennSoft, Salesforce, SQL Server, Excel/CSV, and APIs to deliver trusted data structures and governance for self-service analytics and AI initiatives.

Qualifications

  • 15+ years of experience designing star schema and dimensional data warehouses.
  • Deep SQL/T-SQL expertise with enterprise data warehouse optimization.
  • Hands-on Fabric experience for Lakehouse/Warehouse architectures.
  • Experience integrating WennSoft, Dynamics GP, Salesforce, SQL Server and APIs.
  • Proven data modeling, data quality, lineage, and metadata practices.

Responsibilities

  • Design, build, and maintain Microsoft Fabric Lakehouse and Warehouse.
  • Develop Bronze/Silver/Gold data layers and scalable data models for Power BI.
  • Implement CDC and delta-loading strategies to optimize freshness.
  • Ingest data via Fabric Pipelines, Dataflow Gen2, notebooks, and SQL.
  • Ensure data governance, lineage, and monitoring across Fabric.

Skills

SQL/T-SQL
Dimensional modeling
Star schema
Data warehousing
ETL/ELT
Fabric platform
Power BI integration
Git control
OneLake

Tools

SQL Server
SSIS
Data Factory
Dataflow Gen2
Delta tables
OneLake
Azure Data Factory
Power BI

Job description

The Hunton Group is seeking a hands-on Data Engineer to design, build, and maintain a scalable Microsoft Fabric Lakehouse and Warehouse that centralizes enterprise analytics for Power BI users.

You will lead data modeling, ingestion, and delta-loading strategies across Dynamics GP/WennSoft, Salesforce, SQL Server, Excel/CSV, and APIs to deliver trusted data structures and governance for self-service analytics and AI initiatives.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

The Hunton Group • Houston (TX)

On-site
USD 140,000 - 195,000
Data Engineer: Microsoft Fabric & AI | Power BI & Lakehouse
Data Engineer: Microsoft Fabric & AI | Power BI & Lakehouse

Artic Consulting, Inc. • Redmond (WA)

On-site
USD 115,000 - 120,000
Medical Insurance
Dental Insurance
Vision Insurance
+4
Data Engineer: Microsoft Fabric & Lakehouse Builders
Data Engineer: Microsoft Fabric & Lakehouse Builders

Journeyteam • Draper (UT)

On-site
USD 100,000 - 120,000
Healthcare and dental coverage
401(k) with employer match
Flexible time off
+3
Data Engineer - Microsoft Fabric: Lakehouse & Pipelines
Data Engineer - Microsoft Fabric: Lakehouse & Pipelines

NextPhase.ai • San Mateo (CA)

On-site
USD 120,000 - 180,000
Data Engineer I: Microsoft Fabric Lakehouse (Hybrid)
Data Engineer I: Microsoft Fabric Lakehouse (Hybrid)

Experis-US • Raleigh (NC)

Hybrid
USD 48,000 - 55,000
Medical Plan and Drug Coverage
Dental Plan
Vision Plan
+4
Senior Data Engineer: Microsoft Fabric Lakehouse
Senior Data Engineer: Microsoft Fabric Lakehouse

Quantum Technologies. LLC • Hartford (CT)

On-site
USD 82,000 - 117,000
Senior Data Engineer - Azure & Fabric Lakehouse Architect
Senior Data Engineer - Azure & Fabric Lakehouse Architect

Concurrency • United States

Remote
USD 90,000 - 150,000
Flexible work schedules
Competitive compensation
Comprehensive benefits
+2
Senior Fabric Data Architect — Lakehouse & Governance
Senior Fabric Data Architect — Lakehouse & Governance

Hermanson Company • United States

Remote
USD 120,000 - 180,000
Senior Fabric Data Architect for Enterprise Lakehouse
Senior Fabric Data Architect for Enterprise Lakehouse

Hermanson Company • Kent (WA)

On-site
USD 165,000 - 195,000
Competitive pay with bonus
Medical, prescription, dental & vision
401(k) with discretionary match
+1
Data Engineer: Fabric Lakehouse & Real-Time Analytics
Data Engineer: Fabric Lakehouse & Real-Time Analytics

ExlService Holdings, Inc. • United States

Hybrid
USD 94,000 - 145,000