Data Engineer - 173628

Piper Companies; Norfolk (VA); On-site; USD 90,000 - 100,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401k Plan

Holidays

PTO

Job summary

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

You will design, build, and maintain Azure-based data pipelines for enterprise reporting, using Azure Data Factory, SQL, and Power BI to transform unstructured data into reliable information. Responsibilities include building and optimizing pipelines, integrating disparate systems, refining data models, and supporting BI

Qualifications

• Experience designing and maintaining data pipelines in Azure.
• Strong SQL and data transformation skills.
• Proficiency with Power BI reporting and dashboards.
• Experience integrating legacy and disparate systems.

Responsibilities

• Design, develop, & maintain Azure-based data pipelines using ADF.
• Connect and integrate legacy systems to enable reliable data flows.
• Analyze datasets to determine ingestion, transformation, and storage strategies.
• Develop and optimize SQL queries and database solutions for reporting needs.
• Support Power BI dashboards and reports with clean, structured data.
• Troubleshoot data pipeline issues and ensure data quality and security.
• Collaborate on ETL, data integration, and BI improvements.

Skills

SQL queries

Data modeling

ETL processes

Power BI dashboards

Tools

Azure Data Factory (ADF)

SQL databases

Power BI

Azure/cloud data environments

Python

XML

SSIS

Splunk

Job description

Zachary Piper Solutions is seeking a Data Engineer to support the U.S. Navy. This role is 100% onsite in Norfolk, VA; 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. This role combines hands‑on Azure Data Factory (ADF), SQL, data integration, ETL, and Power BI to connect disparate systems and turn new or unstructured data into reliable, actionable information.

Responsibilities of the Data Engineer include:

• Design, develop, & maintain Azure-based data pipelines using Azure Data Factory (ADF) to ingest, transform, stage, aggregate, & prepare data for enterprise reporting
• Connect & integrate legacy, disparate, & enterprise systems, establishing reliable data flows between databases, repositories, & downstream reporting platforms
• Analyze new & unclean datasets to determine appropriate data ingestion, transformation, storage, staging, & aggregation strategies
• Develop & optimize SQL queries & database solutions to support data extraction, transformation, validation, & reporting requirements
• Support the development of Power BI dashboards & reports, ensuring reporting tools are fed with accurate, clean, & properly structured data
• Troubleshoot & resolve data pipeline and integration issues while ensuring data quality, reliability, security, & performance
• Collaborate with technical teams to identify opportunities for ETL, data integration, automation, & business intelligence improvements

Qualifications of the Data Engineer include:

• 3–4+ years of hands‑on Data Engineering experience, with a focus on enterprise data transformation, staging, aggregation, & pipeline development
• Hands‑on experience developing Azure Data Factory (ADF) pipelines and integrating data from multiple systems and databases
• Strong experience with SQL & SQL databases, including writing queries and working directly with enterprise data
• Hands‑on experience with Power BI, including developing reports/dashboards and working with the underlying data
• Experience with ETL, data integration, data transformation, data staging, & data aggregation
• Experience connecting legacy and/or disparate systems and moving data between systems and repositories
• Ability to independently evaluate unfamiliar datasets and determine how to ingest, transform, store, & prepare data for reporting
• Active DoD Secret security clearance
• IAT Level II certification
• Experience with Python, PowerShell, XML, SSIS, Splunk, or Azure/cloud data environments is a plus

Compensation for the Data Engineer includes:

• Salary: $90,000–$100,000 depending on experience
• Benefits: Medical, Dental, Vision, 401k Plan, Holidays, PTO, sick leave as required by law

Keywords: Data Engineering, Data Engineer, Azure Data Engineer, Data Engineering, Data Pipeline, Data Pipelines, Data Integration, Data Transformation, Data Ingestion, Data Staging, Data Aggregation, ETL, ELT, Enterprise Data, Data Migration, Cloud, Azure, Microsoft Azure, Azure Data Factory, ADF, Azure Data Pipelines, Azure Data Engineering, Cloud Data Engineering, Database, SQL, SQL Server, SQL Databases, T‑SQL, Database Development, Database Integration, Data Extraction, Data Warehousing, Business Intelligence, Data Visualization, Power BI, BI, Reporting, Dashboards, Enterprise Reporting, Data Integration, System Integration, Legacy System Integration, Data Connectivity, Data Repositories, Data Transformation

Programming / Supporting: Python, PowerShell, XML, Splunk, Automation, DOD Secret, Active Secret Clearance, Security+, IAT Level II, 8570, DoD 8570, CASP, CISSP, CASP+ CE, CASP+ce, certified information systems security professional, certified informations systems security professional, certified information system security professional, certified advanced security practitioner, comptia casp, comptia CASP+, Iat III, iat level iii, iat3, iat 3, iat level three, iat three, iatthree, iat3, CISA, GCED, GCIH, certified information systems auditor, certified information system auditor, GIAC Certified enterprise defender, GIAC certified incident handler, dod cleared, dod clearance, secret clearance, secret, secret cleared, secret security clearance, security clearance, security cleared

#LI-SW1 #LI-ONSITE