Data Engineer - U.S. Citizenship Required
About The Position
ZenPoint Solutions LLC is seeking a highly skilled Data Engineer to support a federal law enforcement agency’s enterprise software modernization initiative. In this role, you will be responsible for data migration activities and establishing a robust target data architecture optimized for complex transactions and data analysis. The Data Engineer will design and execute advanced data pipelines, transitioning data structures from a legacy repository system into a modular, modernized cloud environment. This position requires deep expertise in Extract, Transform, Load (ETL) workflows, semantic data mapping, and continuous collaboration with agency subject matter experts to preserve historical data integrity. This position is contingent upon the successful award of a government contract and subsequent government approval.
Requirements
- Candidate must be a United States Citizen and present proof of Citizenship, if selected
- Minimum of 4 years of experience focusing on data migration, pipeline engineering, and data architecture
- Demonstrated experience writing clean transformation logic, managing complex database objects, and executing structured data workflows.
Nice To Haves
- Bachelor’s degree in a technical field
- Microsoft Certified: Azure Data Engineer Associate
- Familiarity with hosting environments, database synchronization, or data streaming within Amazon Web Services (AWS) or secure federal cloud environments.
- Prior experience structuring databases and technical schemas in alignment with formal federal data management instructions or strict organizational governance frameworks.
Responsibilities
- Design, build, and deploy automated data pipelines utilizing industry-standard tools such as SQL Server Integration Services (SSIS).
- Oversee complex ETL processes, optimizing data workflows for peak system performance, speed, and structural integrity.
- Define, validate, and maintain comprehensive source-to-target data mappings that accurately preserve structural relationships and semantic meaning.
- Validate data transformation rules and mapping dependencies directly with agency Subject Matter Experts (SMEs) prior to production deployment.
- Formally link data migration tasks and ETL activities directly to user stories inside the team's agile backlog management tool.
- Test and verify data transformations under rigorous criteria, establishing 100% traceability from source systems to target systems while validating edge cases and handling anomalies.
- Create, update, and maintain critical data governance artifacts, including the project Data Dictionary, Entity Relationship Diagrams (ERDs), and comprehensive ETL Design Specifications.
Benefits
- health, dental, and vision insurance
- group and voluntary life insurance
- short-term and long-term disability insurance
- 401(k)-retirement plan with company matching contributions
- flexible spending accounts
- generous paid leave policy, including federal holidays
- professional development opportunities
- tuition assistance program
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
Associate degree
