What are the responsibilities and job description for the Data Engineer - U.S. Citizenship Required position at ZenPoint Solutions LLC?
Description
ZenPoint Solutions LLC (“ZenPoint Solutions”) is a rapidly expanding Information Technology (IT) services company in the federal sector. We foster a thriving, ambitious work environment that prioritizes employee well-being and a positive company culture. We invite you to join our team and help us shape a dynamic future as we deliver innovative solutions to address the nation's most critical IT missions.
Clearance Requirement: None required at the time of application, though Public Trust or higher is preferred. Candidates must be eligible to receive and maintain a Public Trust.
Work Location: Huntsville, AL
Work Schedule (Onsite): Onsite 5 days a week (M-F) with core working hours of 9am-3pm CST.
Position Overview: ZenPoint Solutions 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.
Key Responsibilities
Required Qualifications:
Company Benefits: We take care of your well-being here at ZenPoint Solutions! Our comprehensive benefits package includes health, dental, and vision insurance to keep you and your family healthy. We also offer group and voluntary life insurance for financial security, and short-term and long-term disability insurance to provide peace of mind in case of unexpected illness or injury. You'll have the option to contribute to a 401(k)-retirement plan with company matching contributions to save for the future. We also offer flexible spending accounts to help manage medical and dependent care costs on a pre-tax basis. On top of that, you'll enjoy a generous paid leave policy, including federal holidays, to maintain a healthy work-life balance. To help you grow in your career, we offer professional development opportunities and a tuition assistance program.
Commitment to Equality: At ZenPoint Solutions, we value diverse perspectives and are committed to providing equal employment opportunities. We welcome applications from all qualified individuals, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other status protected under applicable federal, state, or local laws.
ZenPoint Solutions LLC (“ZenPoint Solutions”) is a rapidly expanding Information Technology (IT) services company in the federal sector. We foster a thriving, ambitious work environment that prioritizes employee well-being and a positive company culture. We invite you to join our team and help us shape a dynamic future as we deliver innovative solutions to address the nation's most critical IT missions.
Clearance Requirement: None required at the time of application, though Public Trust or higher is preferred. Candidates must be eligible to receive and maintain a Public Trust.
Work Location: Huntsville, AL
Work Schedule (Onsite): Onsite 5 days a week (M-F) with core working hours of 9am-3pm CST.
Position Overview: ZenPoint Solutions 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.
Key Responsibilities
- Data Pipeline Design: Design, build, and deploy automated data pipelines utilizing industry-standard tools such as SQL Server Integration Services (SSIS).
- ETL Management: Oversee complex ETL processes, optimizing data workflows for peak system performance, speed, and structural integrity.
- Data Mapping & Alignment: Define, validate, and maintain comprehensive source-to-target data mappings that accurately preserve structural relationships and semantic meaning.
- SME Collaboration: Validate data transformation rules and mapping dependencies directly with agency Subject Matter Experts (SMEs) prior to production deployment.
- Agile Integration: Formally link data migration tasks and ETL activities directly to user stories inside the team's agile backlog management tool.
- Testing & Quality Assurance: Test and verify data transformations under rigorous criteria, establishing 100% traceability from source systems to target systems while validating edge cases and handling anomalies.
- Technical Documentation: Create, update, and maintain critical data governance artifacts, including the project Data Dictionary, Entity Relationship Diagrams (ERDs), and comprehensive ETL Design Specifications.
Required Qualifications:
- 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.
- Education: Bachelor’s degree in a technical field
- Professional Certifications: Microsoft Certified: Azure Data Engineer Associate
- Cloud Infrastructure Knowledge: Familiarity with hosting environments, database synchronization, or data streaming within Amazon Web Services (AWS) or secure federal cloud environments.
- Data Governance Familiarity: Prior experience structuring databases and technical schemas in alignment with formal federal data management instructions or strict organizational governance frameworks.
Company Benefits: We take care of your well-being here at ZenPoint Solutions! Our comprehensive benefits package includes health, dental, and vision insurance to keep you and your family healthy. We also offer group and voluntary life insurance for financial security, and short-term and long-term disability insurance to provide peace of mind in case of unexpected illness or injury. You'll have the option to contribute to a 401(k)-retirement plan with company matching contributions to save for the future. We also offer flexible spending accounts to help manage medical and dependent care costs on a pre-tax basis. On top of that, you'll enjoy a generous paid leave policy, including federal holidays, to maintain a healthy work-life balance. To help you grow in your career, we offer professional development opportunities and a tuition assistance program.
Commitment to Equality: At ZenPoint Solutions, we value diverse perspectives and are committed to providing equal employment opportunities. We welcome applications from all qualified individuals, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other status protected under applicable federal, state, or local laws.