Onsite Data Engineer – Azure, SQL & Power BI

Zachary Piper Solutions; Norfolk, Northern (VA, KY); Hybrid; USD 90,000 - 100,000; Full time

Benefits offered by this job

Medical, Dental, Vision

401k Plan

Holidays

PTO

Sick leave as required by law

Job summary

Zachary Piper Solutions is seeking a Data Engineer to support the U.S. Navy. This 100% onsite role is based in Norfolk, VA (also in San Diego, CA or Jacksonville, FL).

The Data Engineer will design, build, and maintain Azure-based data pipelines that ingest, transform, stage, aggregate, and prepare data for enterprise reporting. You will work with Azure Data Factory, SQL, ETL, and Power BI to connect disparate systems and turn unstructured data into reliable, actionable information while

Qualifications

• 3-4+ years of hands-on Data Engineering experience in enterprise data environments.
• ADF pipelines and data integration across multiple systems.
• Strong SQL querying and enterprise data handling.
• Power BI dashboard/report development experience.
• ETL, data integration, data transformation, data staging, and data aggregation.
• Experience connecting legacy/disparate systems and moving data between repositories.
• Active DoD Secret clearance and IAT Level II certification.
• Experience with Python, PowerShell, XML, SSIS, Splunk, or Azure/cloud data environments is a plus.

Responsibilities

• Design, develop, and maintain Azure-based data pipelines for ingestion, transformation, staging, aggregation, and reporting.
• Connect legacy and enterprise systems to ensure reliable data flows and reporting readiness.
• Evaluate and process new datasets to determine ingestion/ transformation/storage strategies.
• Develop and optimize SQL queries and database solutions to support data extraction and reporting.
• Support Power BI dashboards and reports with clean, structured data.
• Troubleshoot data pipelines and integration issues ensuring data quality, security, and performance.
• Collaborate with technical teams to identify BI improvements and automation opportunities.

Skills

Azure Data Factory

SQL

Power BI

ETL

Data Integration

Data Pipeline

Data Transformation

Data Staging

DoD Secret clearance

IAT Level II

Python

PowerShell

XML

Splunk

Tools

SQL Server

SSIS

PowerShell

XML

Splunk

Azure

Job description

Zachary Piper Solutions is seeking a Data Engineer to support the U.S. Navy. This 100% onsite role is based in Norfolk, VA (also in San Diego, CA or Jacksonville, FL).

The Data Engineer will design, build, and maintain Azure-based data pipelines that ingest, transform, stage, aggregate, and prepare data for enterprise reporting. You will work with Azure Data Factory, SQL, ETL, and Power BI to connect disparate systems and turn unstructured data into reliable, actionable information while