← Back to jobsJob ID col-cmwp8lver0874d8havtzbpeyw

HRSPosted 2 days ago

Data EngineerNew

Full-time
Remote
15+ years
Competitive
Posted 2 days ago

Hunton Group is hiring a Data Engineer to design, build, and maintain its enterprise data platform using Microsoft Fabric. The role develops scalable Lakehouse and Warehouse architecture, integrates enterprise data sources, and supports governed reporting, self-service analytics, and future AI and advanced analytics initiatives.

Posted
2 days ago
Source
paycomonline.net
Sector
Information Technology & AI

Opens the employer's application page in a new tab

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

  • 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

  • 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
  • Power BI Semantic Models

Required skills

Azure Data FactoryData Governance and LineageData Quality and ReconciliationData WarehousingDataflow Gen2ETL/ELT and Data IntegrationGit and Source ControlMicrosoft FabricOneLakeSQL ServerSQL and T-SQLSSIS

Full job description

Hunton Group is hiring a Data Engineer to design, build, and maintain its enterprise data platform using Microsoft Fabric. The role develops scalable Lakehouse and Warehouse architecture, integrates enterprise data sources, and supports governed reporting, self-service analytics, and future AI and advanced analytics initiatives.

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

Preferred

  • 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
  • Microsoft Fabric OneLake
  • Lakehouses
  • Warehouses
  • Delta Tables
  • Data Factory Pipelines
  • Mirroring
  • Shortcuts
  • Power BI Semantic Models
  • Direct Lake
  • Fabric Data Architecture
  • Power BI Performance
  • Git
  • Source Control
  • Deployment Practices
  • Enterprise Data Quality
  • Data Governance
  • Data Auditing
  • Data Monitoring
  • Documentation
  • Problem-Solving
  • Communication
  • Cross-Functional Teamwork

Benefits

  • Fully remote work arrangement

Company

  • Power, HVAC, and air equipment rentals for emergencies
  • Houston, Texas, US
  • http://www.hrsrental.com/
  • 11-50 employees

Qualifications

  • 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
  • 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
  • 15+ years of experience designing and building Star Schema and dimensional data warehouse solutions, including fact and dimension table design.

Required skills

  • Azure Data Factory, Data Governance and Lineage, Data Quality and Reconciliation, Data Warehousing, Dataflow Gen2, ETL/ELT and Data Integration, Git and Source Control, Microsoft Fabric, Microsoft Fabric Lakehouse and Warehouse Architecture, OneLake, Power BI Semantic Models and Direct Lake, SQL Server, SQL and T-SQL, SSIS, Star Schema and Dimensional Modeling

Experience

  • 15+ years

Job details

Employment type

Full-time

Seniority level

15+ years

Date posted

Nov 19, 2026

Work mode

Remote

Job source

paycomonline.net

Company

HRS

Information Technology & AI

Power, HVAC, and air equipment rentals for emergencies

  • Houston, Texas, US
  • Information Technology & AI
  • 11-50 employees
  • hrsrental.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleAzure Data FactoryData Warehousing

just now

1d ago

New

Data Engineer

Full-timeOn-siteUnited StatesCompetitive

KGS Technology Group, Inc is seeking a Junior Data Engineer to develop, maintain, and optimize data pipelines and support data integration. The role involves working with datasets, databases, and data warehouses to build reliable, scalable data solutions.

Why similarSame roleData WarehousingSQL Server

EXL

1d ago

New

Senior Data Engineer

Full-timeRemoteUnited StatesCompetitive

EXL is seeking a seasoned Data Engineer to join their Sports Analytics & Engineering Practice. This role is pivotal in shaping and implementing a cloud-native data ecosystem, where you will architect and build scalable data infrastructure that transforms raw…

Why similarSame roleData warehousing

Get new Data Engineer jobs by email

Create job alert

Data Engineer

HRS · Competitive

Apply on company site