HyerTek · 5 hours ago
Data Engineer
United States
Full-time
Remote
Mid Level
$125K/yr - $140K/yr
4+ years expHyerTek is seeking a Data Engineer to build ETL pipelines, dataflows, and analytics foundations for federal government clients. The role encompasses the full data lifecycle, from source extraction to developing analytics-ready datasets, primarily using Microsoft technologies like Azure Data Factory and Power BI.
GovernmentInformation TechnologyManagement ConsultingProfessional ServicesPublic Safety
No H1B
Security Clearance RequiredU.S. Citizen Only
Responsibilities
Build and maintain ETL pipelines using Azure Data Factory
Develop Power Platform Dataflows for data transformation and loading
Extract from diverse sources — Oracle, SQL Server, Jira, Confluence, SharePoint, Planner, REST APIs, flat files
Write complex transformations using Data Factory expressions, Power Query M, and SQL
Implement incremental load and change data capture patterns
Schedule, monitor, and troubleshoot pipeline runs
Build semantic models and datasets in Power BI and Microsoft Fabric
Develop and optimize dataflows that feed Power BI reports
Support report developers with data preparation and modeling
Create Fabric lakehouses and data pipelines where applicable
Write DAX measures and optimize dataset performance
Ensure data quality and consistency across reporting layers
Qualification
Required
4+ years of ETL development and data pipeline experience
Strong hands-on experience with Azure Data Factory
Experience with Power Query / Dataflows
Strong SQL skills
Experience building Power BI datasets and semantic models
Understanding of data modeling for analytics (star schema, relationships)
Ability to troubleshoot pipeline failures and data quality issues
U.S. citizenship and the ability to successfully obtain and maintain a U.S. Department of Defense (DoD) clearance
Authorized to work in the United States without the need for employment-based visa sponsorship now or in the future
Preferred
Experience with Microsoft Fabric (lakehouses, pipelines, warehouses)
DAX proficiency
Experience with D365 Data Migration Framework (DMF)
Experience loading data into Dataverse / Power Platform
Familiarity with Jira, Confluence, SharePoint, Oracle APIs
Python or PowerShell scripting
Federal or DoD project experience
Azure/Fabric certifications (DP-203, DP-600, PL-300)
Company
HyerTek
HyerTek helps organizations solve complex IT and research problems for clients in government, education, healthcare, and financial services.
11-50 employees
Funding
Current Stage
Early StageTotal Funding
unknownKey Investors
Jack Hyman
2018-12-01Pre Seed
Leadership Team
Jack Hyman
Founder & Chief Executive Officer
Company data provided by crunchbase