Data Engineer

Posted 18 Hours Ago
Hiring Remotely in 77042, Houston, TX, USA
In-Office or Remote
Expert/Leader
Hardware • Industrial • Automation
The Role
Designs, builds, and maintains an enterprise Microsoft Fabric data platform, including Lakehouse and Warehouse architectures, OneLake storage, dimensional models, ingestion pipelines, transformations, and data quality controls. Integrates enterprise data sources, establishes governed Bronze, Silver, and Gold layers, optimizes workloads, documents lineage and business rules, and supports Power BI semantic models. The role also implements monitoring, deployment, source control, and scalable data practices for future AI, machine learning, and advanced analytics initiatives.
Summary Generated by Built In

a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } 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

a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; }

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.

Skills Required

  • 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.
  • 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.
  • Experience integrating data from WennSoft/Dynamics GP, Salesforce.com, SQL Server, Excel, 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 with Power BI Analysts and Business Analysts to translate reporting and analytical requirements into reliable, reusable data structures.
  • 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, including the impact of Fabric data architecture and Star Schema design on 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.
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Houston, TX
140 Employees
Year Founded: 1981

What We Do

HTI Ltd, operating as HuntonTrane within the Hunton Group, is a commercial and industrial HVAC solutions provider. It supplies Trane HVAC equipment and ancillary products, delivers building-systems automation and integration, and provides HVAC equipment service. Its offerings support contractors, engineers, building owners, and major construction or renovation projects, with a focus on improving indoor environments, energy efficiency, and building performance.

Similar Jobs

Toast Logo Toast

Data Engineer

Cloud • Fintech • Food • Information Technology • Software • Hospitality
Remote
US
5000 Employees
106K-170K Annually

Applied Systems Logo Applied Systems

Data Engineer

Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Remote or Hybrid
United States
3116 Employees
160K-260K Annually

The Aerospace Corporation Logo The Aerospace Corporation

Senior Supplier Quality Engineer - Data Analytics

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Remote or Hybrid
2 Locations
4600 Employees
97K-146K Annually

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Analytics Engineer

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
6 Locations
40000 Employees
94K-176K Annually

Similar Companies Hiring

Amalgamated Sugar Thumbnail
Food • Greentech • Agriculture • Industrial • Manufacturing
Boise, Idaho
768 Employees
Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
70 Employees
Unusual Machines, Inc. Thumbnail
Hardware • Robotics
Orlando, FL
300 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account