Data Engineer - 173628

Responsibilities

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

Preferred

Experience with Python, PowerShell, XML, SSIS, Splunk, or Azure/cloud data environments is a plus

Benefits

Medical

Dental

Vision

401k Plan

Holidays

PTO

Sick leave as required by law

Zachary Piper Solutions is an IT company providing government contracting solutions in support of the nation’s Intelligence Community.

Mclean, Virginia, USA

http://zacharypiper.com/

Growth Stage

Total Funding

$3M

2018-02-22

Series Unknown· $1.3M

2014-04-10

Series Unknown· $1.7M

Leadership Team

Justin Jordan

Founder and Chairman

Company data provided by

AI Tools

Customize Your Resume

Maximize your interview chances

Build Cover Letter

Make your application stand out

Analyze How Well You Fit

Understand your strength & weakness

Qualifications

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

Required skills

Azure Data Factory (ADF), SQL, Power BI, ETL, Data Integration, Data Engineering, IAT Level II Certification

Experience

3+ years