What are the responsibilities and job description for the Senior 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 Senior 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 Senior 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
- Design, implement, automate, and maintain Enterprise level of scalable Extract, Transform and Load (ETL) data ingestion and data analysis pipelines.
- Build robust data processing, enriching and analysis pipelines that aggregate and normalize large datasets across diverse sources, including sources from web services.
- Automate and optimize database and data workflows for best performance and efficiency.
- Identify and propose emerging technologies, automation, or alternative solutions to efficiently provide better support for developers and application stakeholders.
- Develop and maintain documentation, inline comments, confluence, and stand-alone documents, wherever necessary for the readability of the software design and code.
- Ability to focus on producing results efficiently.
- Ability to work independently and coordinate with team members.
- Candidate must be a United States Citizen and present proof of Citizenship, if selected
- Bachelor’s degree
- Minimum 10 years of relevant experience.
- Experience with designing, implementing, and maintaining big data processing, normalizing, and enriching pipelines in languages such as Python, pySpark, or Spark.
- Experience with architecting, designing, and building modern medallion ETL processes for data lakes, data warehouses or lakehouses.
- Experience with implementing automated data pipelines with Continuous Integration/Continuous Delivery (CI/CD).
- Experience with dataframe processing with filtering conditions.
- Experience with organizing data version history to optimize processing and retrieving performance.
- Experience with data indexing for robust searching and querying.
- Knowledge of PostgreSQL.
- Knowledge of automating data pipeline and workflow on Apache Niagra Files (NiFi) or Databricks for ease of maintenance.
- Strong verbal and written communication skills to effectively collaborate and integrate with enterprise partners and customers.
- Excellent at troubleshooting, debugging, and researching.
- Focus and have the desire to learn.
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.