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: Candidates must hold and maintain an active Top Secret clearance
Work Location: Washington, D.C.
Work Schedule (Onsite): Five (5) days a week, onsite at the customer’s facility
Position Overview: ZenPoint Solutions is seeking a skilled Data Engineer to support the maintenance, optimization, and effective use of the Private Sector Portal (PSP) across the enterprise. Responsibilities include managing and auditing PSP data, supporting HQ and field users, and coordinating technical requirements with relationship management teams and contractors. The position designs, implements, and automates enterprise-level ETL and data analysis pipelines, aggregating data from multiple sources to ensure timely, accurate delivery. The role also focuses on improving system efficiency through automation and emerging technologies, while developing clear technical documentation and providing reliable customer support. Strong independence, collaboration, and a results-driven mindset are essential for success in this position.
Requirements
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: Candidates must hold and maintain an active Top Secret clearance
Work Location: Washington, D.C.
Work Schedule (Onsite): Five (5) days a week, onsite at the customer’s facility
Position Overview: ZenPoint Solutions is seeking a skilled Data Engineer to support the maintenance, optimization, and effective use of the Private Sector Portal (PSP) across the enterprise. Responsibilities include managing and auditing PSP data, supporting HQ and field users, and coordinating technical requirements with relationship management teams and contractors. The position designs, implements, and automates enterprise-level ETL and data analysis pipelines, aggregating data from multiple sources to ensure timely, accurate delivery. The role also focuses on improving system efficiency through automation and emerging technologies, while developing clear technical documentation and providing reliable customer support. Strong independence, collaboration, and a results-driven mindset are essential for success in this position.
Requirements
- Support the maintenance, optimization, and effective use of the Private Sector Portal (PSP) across the enterprise
- Manage, audit, and ensure the quality and consistency of PSP data, including identifying missing or inappropriate metadata
- Provide customer service and subject-matter support to HQ and field users, addressing system questions and troubleshooting issues
- Coordinate with relationship management teams and contractors to identify, document, and resolve technical requirements related to the PSP system
- Design, implement, automate, and maintain enterprise-level ETL and data analysis pipelines that aggregate data from multiple sources
- Ensure the scheduling, processing, documentation, and implementation of data deliveries in a timely and accurate manner
- Identify and recommend automation, emerging technologies, and alternative solutions to improve system efficiency and support developers and application stakeholders
- Develop and maintain technical documentation, including system guidance, process documentation, and software design references
- Work independently while collaborating effectively with team members to deliver results in a fast-paced environment
- Candidate must be a United States Citizen and present proof of Citizenship, if selected
- Bachelor’s degree in a quantitative field (e.g., Statistics, Operations Research) or a technical field (e.g., Computer Science, Engineering)
- Minimum of 2–4 years of professional experience in a data analytics, data engineering, or related role
- Exceptional proficiency in written and verbal communication, including strong writing and editing skills using Microsoft Office
- High proficiency in Python and advanced SQL for data processing and analysis
- Experience designing and building modern medallion-style ETL processes for data lakes, data warehouses, or lakehouse architectures
- Experience designing, implementing, and maintaining data processing and analysis pipelines using Python, Spark, or similar technologies
- Experience building and automating data pipelines and workflows using tools such as Apache NiFi or Databricks
- Experience implementing automated data CI/CD pipelines and dataframe-based processing
- Proficiency with data warehousing concepts and architectures
- Experience with cloud platforms such as AWS and Google Cloud, including services like BigQuery or Redshift
- Experience with business intelligence and data visualization tools (e.g., Looker, Tableau, Microsoft Power BI)
- Experience with web technologies including HTML, CSS, JavaScript, and modern frameworks such as React or Bootstrap/Reactstrap
- Strong critical thinking, troubleshooting, debugging, and research skills
- Ability to clearly explain technical concepts to non-technical stakeholders
- Strong ability to work independently, remain focused, and demonstrate a continuous desire to learn and grow
- Working knowledge of PostgreSQL
- Experience working in Agile/Scrum project environments
- Experience collaborating with a diverse range of stakeholders, including managers and technical resources, and translating business requirements into operational metrics and reports
- Strong interpersonal and communication skills, with a positive and professional approach when engaging with internal teams and business stakeholders
- Proven ability to work collaboratively as a team player and effectively represent the team across the organization
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.