Back to jobs

Data Engineer

Pay
Pay not listedSimilar roles state $127K–$189K
Work setting
Remote — work setting source
Work setup in the employer’s posting: Fully Remote
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full Time
From the employer’s posting

What you’ll work on

Full posting
  • Build and maintain Fabric Lakehouse and Warehouse with Star Schema models

  • Build ingestion and transformation pipelines using Data Factory and Dataflow Gen2

  • Integrate data from Dynamics GP/WennSoft, Salesforce, SQL Server, files and APIs

  • Design Bronze, Silver and Gold data layers

  • Implement data quality and reconciliation controls

From the employer’s posting
Design, build, and maintain Microsoft Fabric Lakehouse and Warehouse that serve as the centralized foundation for enterprise reporting and analytics.
Build and maintain data ingestion and transformation processes using Fabric Data Factory Pipelines, Dataflow Gen2, notebooks, SQL, and other Fabric-native capabilities.
Integrate data from multiple enterprise sources, including Microsoft Dynamics GP/WennSoft, Salesforce.com, SQL Server, Excel and CSV files, APIs, and other operational systems.
Design appropriate Bronze, Silver, and Gold data layers to separate raw source data, standardized and cleansed data, and business-ready analytical data.
Implement comprehensive data quality and reconciliation controls, including completeness, accuracy, duplicate detection, referential integrity, source-to-target balancing, and load validation.

What you’ll bring

All qualifications

Core experience

  • 15+ years of experience designing and building Star Schema and dimensional data warehouse solutions, including fact and dimension table design.
  • Deep SQL and T-SQL expertise, with extensive experience designing, developing, and optimizing enterprise data warehouse solutions.
  • Hands-on experience with Microsoft Fabric, SQL Server, or comparable modern cloud data platforms, with the ability to transition traditional data warehouse architectures into Fabric.
  • Experience designing and building Microsoft Fabric Lakehouse and Warehouse architectures, including OneLake-based data storage and analytical data structures.
  • Proven experience integrating data from enterprise systems including WennSoft/Dynamics GP, Salesforce.com, SQL Server, Excel and CSV files, APIs, and other operational data sources.
  • Strong understanding of dimensional modeling, surrogate keys, Slowly Changing Dimensions (Type 1 and Type 2), incremental loading, data quality, reconciliation, and metadata management.

Preferred experience

  • Experience with Microsoft Fabric OneLake, Lakehouses, Warehouses, Delta tables, Data Factory Pipelines, Dataflow Gen2, Mirroring, and Shortcuts.
  • Familiarity with Power BI semantic models and Direct Lake, with an understanding of how Fabric data architecture and Star Schema design affect Power BI performance.
  • Familiarity with Git/source control and deployment practices for Microsoft Fabric development.
  • Experience establishing enterprise data quality, governance, lineage, auditing, and monitoring standards.
Qualification wording
15+ years of experience designing and building Star Schema and dimensional data warehouse solutions, including fact and dimension table design.
Deep SQL and T-SQL expertise, with extensive experience designing, developing, and optimizing enterprise data warehouse solutions.
Hands-on experience with Microsoft Fabric, SQL Server, or comparable modern cloud data platforms, with the ability to transition traditional data warehouse architectures into Fabric.
Experience designing and building Microsoft Fabric Lakehouse and Warehouse architectures, including OneLake-based data storage and analytical data structures.
Proven experience integrating data from enterprise systems including WennSoft/Dynamics GP, Salesforce.com, SQL Server, Excel and CSV files, APIs, and other operational data sources.
Strong understanding of dimensional modeling, surrogate keys, Slowly Changing Dimensions (Type 1 and Type 2), incremental loading, data quality, reconciliation, and metadata management.
Experience with Microsoft Fabric OneLake, Lakehouses, Warehouses, Delta tables, Data Factory Pipelines, Dataflow Gen2, Mirroring, and Shortcuts.
Familiarity with Power BI semantic models and Direct Lake, with an understanding of how Fabric data architecture and Star Schema design affect Power BI performance.
Familiarity with Git/source control and deployment practices for Microsoft Fabric development.
Experience establishing enterprise data quality, governance, lineage, auditing, and monitoring standards.
Apply at Hunton Group

Posting record

Report an error

Actively hiringFirst seen by us 2 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 19, 20262 days ago
Recorded sightings
4
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$127K–$189K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 2

Early. Similar jobs usually come down between day 6 and day 56.

From 14,766 similar postings that came down. Coming down is not always a hire.

Hunton Group is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • T-SQL
  • Azure
  • Delta Lake
  • Excel
  • Power BI
  • SQL Server
  • SSIS
Where the posting names them
Description Hunton Group is seeking to fill a hands-on Data Engineer to design, build, and maintain our enterprise data platform using Microsoft Fabric. This role will lead the development of a scalable Lakehouse and Warehouse architecture that integrates data from Microsoft Dynamics GP/WennSoft, Salesforce.com, Excel and CSV files, SQL Server, APIs, and other enterprise data sources. The Data Engineer will work closely with Power BI Analysts and Business Analysts to transform business requirements into reliable, governed, and high-performing data structures that support enterprise reporting, self-service analytics, and future AI and advanced analytics initiatives.
- Develop scalable data architecture using Microsoft Fabric, OneLake, Lakehouse, Warehouse, and Delta tables, selecting the appropriate technology and storage pattern for each workload. - Build and maintain data ingestion and transformation processes using Fabric Data Factory Pipelines, Dataflow Gen2, notebooks, SQL, and other Fabric-native capabilities. - Integrate data from multiple enterprise sources, including Microsoft Dynamics GP/WennSoft, Salesforce.com, SQL Server, Excel and CSV files, APIs, and other operational systems.
- Build and maintain data ingestion and transformation processes using Fabric Data Factory Pipelines, Dataflow Gen2, notebooks, SQL, and other Fabric-native capabilities. - Integrate data from multiple enterprise sources, including Microsoft Dynamics GP/WennSoft, Salesforce.com, SQL Server, Excel and CSV files, APIs, and other operational systems. - Design appropriate Bronze, Silver, and Gold data layers to separate raw source data, standardized and cleansed data, and business-ready analytical data.
- Design and implement incremental and delta-loading strategies, including CDC, and other techniques to improve data freshness while minimizing unnecessary processing. - Evaluate and implement appropriate Fabric ingestion patterns, including Pipelines, Mirroring, Shortcuts, Dataflow Gen2, notebooks, and SQL-based transformations. - Leverage Microsoft OneLake to centralize enterprise analytical data and reduce unnecessary movement and duplication of data.
- Ensure Fabric solutions align with organizational data governance, security, naming, workspace, development, deployment, and master data management standards. - Optimize Lakehouse, Warehouse, and SQL workloads for performance, scalability, efficient data processing, and large data volumes. - Collaborate closely with Power BI Analysts to ensure Fabric data structures effectively support Power BI semantic models, Direct Lake, Import, and DirectQuery, selecting the appropriate architecture based on performance and reporting requirements.
- 15+ years of experience designing and building Star Schema and dimensional data warehouse solutions, including fact and dimension table design. - Deep SQL and T-SQL expertise, with extensive experience designing, developing, and optimizing enterprise data warehouse solutions. - Hands-on experience with Microsoft Fabric, SQL Server, or comparable modern cloud data platforms, with the ability to transition traditional data warehouse architectures into Fabric.
- Deep SQL and T-SQL expertise, with extensive experience designing, developing, and optimizing enterprise data warehouse solutions. - Hands-on experience with Microsoft Fabric, SQL Server, or comparable modern cloud data platforms, with the ability to transition traditional data warehouse architectures into Fabric. - Experience designing and building Microsoft Fabric Lakehouse and Warehouse architectures, including OneLake-based data storage and analytical data structures.
- Experience designing and building Microsoft Fabric Lakehouse and Warehouse architectures, including OneLake-based data storage and analytical data structures. - Strong ETL/ELT experience using Microsoft Fabric Data Factory Pipelines, Azure Data Factory, SSIS, Dataflow Gen2, SQL, or similar data integration technologies. - Proven experience integrating data from enterprise systems including WennSoft/Dynamics GP, Salesforce.com, SQL Server, Excel and CSV files, APIs, and other operational data sources.
- Strong ETL/ELT experience using Microsoft Fabric Data Factory Pipelines, Azure Data Factory, SSIS, Dataflow Gen2, SQL, or similar data integration technologies. - Proven experience integrating data from enterprise systems including WennSoft/Dynamics GP, Salesforce.com, SQL Server, Excel and CSV files, APIs, and other operational data sources. - Strong understanding of dimensional modeling, surrogate keys, Slowly Changing Dimensions (Type 1 and Type 2), incremental loading, data quality, reconciliation, and metadata management.
- Design and implement Star Schema data models, including fact and dimension tables, optimized for Power BI, analytics, and self-service BI. - Develop scalable data architecture using Microsoft Fabric, OneLake, Lakehouse, Warehouse, and Delta tables, selecting the appropriate technology and storage pattern for each workload. - Build and maintain data ingestion and transformation processes using Fabric Data Factory Pipelines, Dataflow Gen2, notebooks, SQL, and other Fabric-native capabilities.
Preferred Qualifications - Experience with Microsoft Fabric OneLake, Lakehouses, Warehouses, Delta tables, Data Factory Pipelines, Dataflow Gen2, Mirroring, and Shortcuts. - Familiarity with Power BI semantic models and Direct Lake, with an understanding of how Fabric data architecture and Star Schema design affect Power BI performance.
Hunton Group is seeking to fill a hands-on Data Engineer to design, build, and maintain our enterprise data platform using Microsoft Fabric. This role will lead the development of a scalable Lakehouse and Warehouse architecture that integrates data from Microsoft Dynamics GP/WennSoft, Salesforce.com, Excel and CSV files, SQL Server, APIs, and other enterprise data sources. The Data Engineer will work closely with Power BI Analysts and Business Analysts to transform business requirements into reliable, governed, and high-performing data structures that support enterprise reporting, self-service analytics, and future AI and advanced analytics initiatives. Key Responsibilities
- Design, build, and maintain Microsoft Fabric Lakehouse and Warehouse that serve as the centralized foundation for enterprise reporting and analytics. - Design and implement Star Schema data models, including fact and dimension tables, optimized for Power BI, analytics, and self-service BI. - Develop scalable data architecture using Microsoft Fabric, OneLake, Lakehouse, Warehouse, and Delta tables, selecting the appropriate technology and storage pattern for each workload.
- Optimize Lakehouse, Warehouse, and SQL workloads for performance, scalability, efficient data processing, and large data volumes. - Collaborate closely with Power BI Analysts to ensure Fabric data structures effectively support Power BI semantic models, Direct Lake, Import, and DirectQuery, selecting the appropriate architecture based on performance and reporting requirements. - Support the development of centralized, reusable semantic models that provide consistent dimensions, measures, KPIs, and business logic across Power BI reports.
- Collaborate closely with Power BI Analysts to ensure Fabric data structures effectively support Power BI semantic models, Direct Lake, Import, and DirectQuery, selecting the appropriate architecture based on performance and reporting requirements. - Support the development of centralized, reusable semantic models that provide consistent dimensions, measures, KPIs, and business logic across Power BI reports. - Implement Git/source control and deployment practices for Microsoft Fabric artifacts to support controlled development, testing, documentation, and production releases.
- Design and implement operational processes for pipeline monitoring, logging, error handling, retries, notifications, reconciliation, and troubleshooting. - Document end-to-end data lineage and dependencies, from source systems through Fabric Lakehous and Warehous to Power BI semantic models and reporting. - Build the Microsoft Fabric platform with future capabilities in mind, including AI, machine learning, Copilot, real-time analytics, and other advanced analytics use cases.
- Experience documenting source-to-target mappings, data lineage, transformations, data dependencies, and business rules. - Experience collaborating closely with Power BI Analysts and Business Analysts to translate reporting and analytical requirements into reliable, reusable data structures. Preferred Qualifications
- Experience with Microsoft Fabric OneLake, Lakehouses, Warehouses, Delta tables, Data Factory Pipelines, Dataflow Gen2, Mirroring, and Shortcuts. - Familiarity with Power BI semantic models and Direct Lake, with an understanding of how Fabric data architecture and Star Schema design affect Power BI performance. - Familiarity with Git/source control and deployment practices for Microsoft Fabric development.

Your next step

Complete your application on www.paycomonline.net. The employer’s form will show what is required.

Applying through Paycom

  • The application asks you to sign in or create a Paycom account with the employer.

Already applied? Track this application

Job description

View original posting ↗

Description

Hunton Group is seeking to fill a hands-on Data Engineer to design, build, and maintain our enterprise data platform using Microsoft Fabric. This role will lead the development of a scalable Lakehouse and Warehouse architecture that integrates data from Microsoft Dynamics GP/WennSoft, Salesforce.com, Excel and CSV files, SQL Server, APIs, and other enterprise data sources.

The Data Engineer will work closely with Power BI Analysts and Business Analysts to transform business requirements into reliable, governed, and high-performing data structures that support enterprise reporting, self-service analytics, and future AI and advanced analytics initiatives.

Key Responsibilities

  • Design, build, and maintain Microsoft Fabric Lakehouse and Warehouse that serve as the centralized foundation for enterprise reporting and analytics.

  • Design and implement Star Schema data models, including fact and dimension tables, optimized for Power BI, analytics, and self-service BI.

  • Develop scalable data architecture using Microsoft Fabric, OneLake, Lakehouse, Warehouse, and Delta tables, selecting the appropriate technology and storage pattern for each workload.

  • Build and maintain data ingestion and transformation processes using Fabric Data Factory Pipelines, Dataflow Gen2, notebooks, SQL, and other Fabric-native capabilities.

  • Integrate data from multiple enterprise sources, including Microsoft Dynamics GP/WennSoft, Salesforce.com, SQL Server, Excel and CSV files, APIs, and other operational systems.

  • Design appropriate Bronze, Silver, and Gold data layers to separate raw source data, standardized and cleansed data, and business-ready analytical data.

  • Develop robust transformation processes for data cleansing, validation, standardization, and deduplication

  • Standardize business logic, KPIs, key metrics, and data definitions across source systems to establish a consistent and trusted enterprise data foundation.

  • Design and implement incremental and delta-loading strategies, including CDC, and other techniques to improve data freshness while minimizing unnecessary processing.

  • Evaluate and implement appropriate Fabric ingestion patterns, including Pipelines, Mirroring, Shortcuts, Dataflow Gen2, notebooks, and SQL-based transformations.

  • Leverage Microsoft OneLake to centralize enterprise analytical data and reduce unnecessary movement and duplication of data.

  • Implement comprehensive data quality and reconciliation controls, including completeness, accuracy, duplicate detection, referential integrity, source-to-target balancing, and load validation.

  • Implement processes for data lineage, metadata management, auditability, and monitoring across the Fabric environment.

  • Maintain technical documentation including data dictionaries, source-to-target mappings, data flows, transformation logic, dependencies, business rules, and architecture documentation.

  • Ensure Fabric solutions align with organizational data governance, security, naming, workspace, development, deployment, and master data management standards.

  • Optimize Lakehouse, Warehouse, and SQL workloads for performance, scalability, efficient data processing, and large data volumes.

  • Collaborate closely with Power BI Analysts to ensure Fabric data structures effectively support Power BI semantic models, Direct Lake, Import, and DirectQuery, selecting the appropriate architecture based on performance and reporting requirements.

  • Support the development of centralized, reusable semantic models that provide consistent dimensions, measures, KPIs, and business logic across Power BI reports.

  • Implement Git/source control and deployment practices for Microsoft Fabric artifacts to support controlled development, testing, documentation, and production releases.

  • Design and implement operational processes for pipeline monitoring, logging, error handling, retries, notifications, reconciliation, and troubleshooting.

  • Document end-to-end data lineage and dependencies, from source systems through Fabric Lakehous and Warehous to Power BI semantic models and reporting.

  • Build the Microsoft Fabric platform with future capabilities in mind, including AI, machine learning, Copilot, real-time analytics, and other advanced analytics use cases.

Qualifications

Required Skills & Experience

  • 15+ years of experience designing and building Star Schema and dimensional data warehouse solutions, including fact and dimension table design.
  • Deep SQL and T-SQL expertise, with extensive experience designing, developing, and optimizing enterprise data warehouse solutions.
  • Hands-on experience with Microsoft Fabric, SQL Server, or comparable modern cloud data platforms, with the ability to transition traditional data warehouse architectures into Fabric.
  • Experience designing and building Microsoft Fabric Lakehouse and Warehouse architectures, including OneLake-based data storage and analytical data structures.
  • Strong ETL/ELT experience using Microsoft Fabric Data Factory Pipelines, Azure Data Factory, SSIS, Dataflow Gen2, SQL, or similar data integration technologies.
  • Proven experience integrating data from enterprise systems including WennSoft/Dynamics GP, Salesforce.com, SQL Server, Excel and CSV files, APIs, and other operational data sources.
  • Strong understanding of dimensional modeling, surrogate keys, Slowly Changing Dimensions (Type 1 and Type 2), incremental loading, data quality, reconciliation, and metadata management.
  • Experience implementing scalable Bronze, Silver, and Gold data architecture patterns within modern data platforms.
  • Experience documenting source-to-target mappings, data lineage, transformations, data dependencies, and business rules.
  • Experience collaborating closely with Power BI Analysts and Business Analysts to translate reporting and analytical requirements into reliable, reusable data structures.

Preferred Qualifications

  • Experience with Microsoft Fabric OneLake, Lakehouses, Warehouses, Delta tables, Data Factory Pipelines, Dataflow Gen2, Mirroring, and Shortcuts.
  • Familiarity with Power BI semantic models and Direct Lake, with an understanding of how Fabric data architecture and Star Schema design affect Power BI performance.
  • Familiarity with Git/source control and deployment practices for Microsoft Fabric development.
  • Experience establishing enterprise data quality, governance, lineage, auditing, and monitoring standards.
  • Strong documentation, problem-solving, communication, and cross-functional teamwork skills.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Westpark - Houston, TX 77042

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.