Data Engineer - Jobs

Data EngineerZachary 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 reportingConnect & integrate legacy, disparate, & enterprise systems, establishing reliable data flows between databases, repositories, & downstream reporting platformsAnalyze new & unclean datasets to determine appropriate data ingestion, transformation, storage, staging, & aggregation strategiesDevelop & optimize SQL queries & database solutions to support data extraction, transformation, validation, & reporting requirementsSupport the development of Power BI dashboards & reports, ensuring reporting tools are fed with accurate, clean, & properly structured dataTroubleshoot & resolve data pipeline and integration issues while ensuring data quality, reliability, security, & performanceCollaborate with technical teams to identify opportunities for ETL, data integration, automation, & business intelligence improvementsQualifications of the Data Engineer include:3-4+ years of hands-on Data Engineering experience, with a focus on enterprise data transformation, staging, aggregation, & pipeline developmentHands-on experience developing Azure Data Factory (ADF) pipelines and integrating data from multiple systems and databasesStrong experience with SQL & SQL databases, including writing queries and working directly with enterprise dataHands-on experience with Power BI, including developing reports/dashboards and working with the underlying dataExperience with ETL, data integration, data transformation, data staging, & data aggregationExperience connecting legacy and/or disparate systems and moving data between systems and repositoriesAbility to independently evaluate unfamiliar datasets and determine how to ingest, transform, store, & prepare data for reportingActive DoD Secret security clearanceIAT Level II certificationExperience with Python, PowerShell, XML, SSIS, Splunk, or Azure/cloud data environments is a plusCompensation for the Data Engineer includes:Salary: $90,000-$100,000 depending on experienceBenefits: Medical, Dental, Vision, 401k Plan, Holidays, PTO, sick leave as required by law