Backend Data Engineer

Zachary Piper Solutions is seeking a Backend Data Engineer to support the USN. This role is 100% onsite and is open to candidates in Norfolk, VA. The Backend Data Engineer will join a small team that supports & manages government tools connected to the Navy's enterprise network. The team is increasingly focused on the data engineering & data infrastructure supporting enterprise reporting and analytics. This position is heavily focused on the backend data engineering lifecycle connecting to new and existing data sources, integrating disparate and legacy systems, building data pipelines, transforming and cleaning data, staging and aggregating datasets, and preparing data for downstream reporting and business intelligence.

Responsibilities of the Backend Data Engineer:

• Design, develop, and maintain enterprise data pipelines supporting Navy and DoD environments • Use Azure Data Factory (ADF) to build pipelines and establish connections between legacy systems, applications, databases, and data repositories • Ingest data from new, unfamiliar, legacy, and disparate sources and determine the appropriate approach for extraction and integration • Perform data transformation, cleansing, staging, aggregation, and preparation for downstream reporting and analytics • Develop and maintain 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,…