Data Engineer - U.S. Citizenship

Job Type

Full-time

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

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 Required Qualifications:

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 Desired Qualifications:

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

No recruitment agencies, please.

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.