HyerTek · 4 hours ago
Data Engineer
HyerTek is a fast-moving Microsoft solutions partner seeking a data engineer to support the full data engineering lifecycle — from cleansing to visualization. The role involves working directly with the solutions team and client end users to migrate and operationalize data for various programs, including building extraction and transformation pipelines and developing reporting and visualization layers.
GovernmentConsultingPublic SafetyInformation TechnologyProfessional ServicesManagement Consulting
Responsibilities
Migrate data from legacy data systems, Excel workbooks, SharePoint, and Access databases into Dataverse and Azure data stores
Build and maintain ETL/ELT pipelines using Azure Data Factory, Dataflows, Dataverse SDK, or whatever fits the problem
Design and build Power BI reports and dashboards that support operational decision-making at the command level
Work with Microsoft Fabric for data lakehouse architecture, data integration, and consolidated analytics
Model and manage data within Dynamics 365 / Dataverse, including entity design, relationships, and data quality
Transform messy, inconsistent source data into clean, governed datasets—Excel normalization, deduplication, validation
Connect data across Power Platform apps, Power Automate flows, and Power BI for end-to-end visibility
Work in Azure Government (GCC High / IL4-IL5) environments
Document data flows, mappings, and BI solutions so the team can maintain and scale them
Qualification
Required
Eligibility for an Active Secret clearance. You must be a U.S. citizenship
3+ years working across the Microsoft data stack—you don't need to be an expert in all of it, but you need real experience with most of: Azure data services, D365/Dataverse, Power BI, Power Platform, and Excel-based data work
Hands-on Power BI experience: data modeling, DAX, building reports and dashboards that stakeholders actually use
Experience migrating or integrating data into Dataverse or D365 (beyond simple imports—you've dealt with referential integrity, transformations, and data quality)
Solid SQL skills
Scripting ability in Python, PowerShell, or M (Power Query)
Prior work in DoD or federal IT environments
This position requires U.S. citizenship and the ability to successfully obtain and maintain a U.S. Department of Defense (DoD) clearance. Candidates must be authorized to work in the United States without the need for employment-based visa sponsorship now or in the future
Company
HyerTek
HyerTek helps organizations solve complex IT and research problems for clients in government, education, healthcare, and financial services.