Onsite Backend Data Engineer – Azure & Data Pipelines

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

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

401k Plan

Paid time off

Job summary

Zachary Piper Solutions is seeking a Backend Data Engineer to support the US Navy. This role is 100% onsite in Norfolk, VA, joining a small team maintaining government tools linked to the Navy enterprise network.

You will build and optimize data pipelines, transform data, and prepare datasets for BI reporting, collaborating with a BI-focused engineer. Responsibilities include designing data pipelines, leveraging ADF, SQL development, and integrating legacy systems while aligning with enterprise

Qualifications

• 3–4 years of hands-on data engineering experience.
• Active Secret clearance and IAT Level II certification.
• Hands-on experience developing data pipelines and ETL/data integration solutions.
• Strong hands-on experience with Azure Data Factory (ADF).
• Strong SQL/SQL database experience.
• Experience transforming, staging, and aggregating data.
• Experience integrating disparate or legacy systems and moving data between them.
• Experience supporting data used by Power BI or enterprise reporting environments.
• Preferred: SSIS, Python, PowerShell, XML, Splunk, Azure/cloud environments.

Responsibilities

• Design, develop, and maintain enterprise data pipelines supporting Navy and DoD environments.
• Use Azure Data Factory (ADF) to build pipelines and connect legacy systems, applications, databases, and data repositories.
• Ingest data from new, legacy, and disparate sources and determine extraction and integration approaches.
• Transform, cleanse, stage, aggregate, and prepare data for downstream reporting and analytics.
• Develop SQL queries and work directly with SQL databases and data repositories.
• Integrate systems and move data between different platforms and repositories.
• Troubleshoot data pipeline failures, connectivity issues, and data quality problems.
• Collaborate with stakeholders to understand data sources, dependencies, and downstream reporting needs.
• Develop data solutions to feed Power BI and other enterprise BI tools.
• Document data flows, pipeline architecture, transformations, and dependencies.
• Support evolving enterprise data environments with modern cloud technologies and legacy systems.
• Coordinate with front-end/BI-focused Data Engineer to ensure reporting requirements are met by backend data infrastructure.

Skills

Data engineering

ETL pipelines

SQL

Power BI

Data transformation

Data ingestion

Data staging

Data warehousing

Azure Data Factory

Tools

Azure Data Factory

SSIS

Python

PowerShell

XML

Splunk

Job description

Zachary Piper Solutions is seeking a Backend Data Engineer to support the US Navy. This role is 100% onsite in Norfolk, VA, joining a small team maintaining government tools linked to the Navy enterprise network.

You will build and optimize data pipelines, transform data, and prepare datasets for BI reporting, collaborating with a BI-focused engineer. Responsibilities include designing data pipelines, leveraging ADF, SQL development, and integrating legacy systems while aligning with enterprise