What are the responsibilities and job description for the Data Engineer position at Zachary Piper Solutions?
Zachary Piper Solutions is seeking a Data Engineer (Azure Data Factory) to support a government consulting organization in any of the following three locations: Norfolk, VA, San Diego, CA, or Jacksonville, FL. The Data Engineer will be responsible for ingesting, transforming, staging, aggregating, and preparing enterprise data for reporting and analytics initiatives across multiple systems and databases.
Responsibilities of the Data Engineer (Azure Data Factory) Include:
Responsibilities of the Data Engineer (Azure Data Factory) Include:
- Build, maintain, and optimize enterprise data pipelines using Azure Data Factory (ADF)
- Ingest, transform, cleanse, stage, and aggregate data from disparate and legacy systems
- Design and manage data movement between SQL databases, repositories, and cloud environments
- Develop backend data solutions that support Power BI and enterprise reporting platforms
- Collaborate with stakeholders to determine data connectivity, storage strategies, and reporting requirements
- Active Security (IAT Level II) certification and an
- Active Secret Clearance
- 3-4 years of hands-on Data Engineering experience, including enterprise data transformation, staging, aggregation, and pipeline development
- Experience building and maintaining data pipelines using Azure Data Factory (ADF) and integrating data across multiple systems and databases
- Strong experience with SQL databases, data modeling, and preparing data for enterprise reporting and analytics
- Experience supporting Power BI or similar Business Intelligence/reporting tools in an enterprise environment
- Salary Range: $95,000 - $105,000
- Comprehensive Benefits: Medical, Dental, Vision, 401(k), PTO, Sick Leave if required by law, and Holidays
Salary : $95,000 - $105,000