Lead Ab Initio Data Engineer

Lead Data Engineer (Ab Initio / AWS / Data Pipelines)

Location: Reston, VA (Hybrid – onsite roughly once every 1–2 months)
Duration: 12-Month Contract

About the Role

We’re looking for a Lead Data Engineer to build and optimize cloud-based data pipelines supporting large-scale AI and analytics initiatives. You’ll lead the design and implementation of data integration solutions using Ab Initio and AWS services , helping modernize how enterprise data is moved, transformed, and leveraged for AI/ML applications.

What You’ll Do

• Design, develop, and maintain ETL/ELT data pipelines using Ab Initio .

• Move structured and unstructured data from on-prem to AWS cloud for AI and analytics workloads.

• Work with AWS services such as S3, Athena, Kendra, and Aurora to ensure scalable data storage and access.

• Collaborate with architects, data scientists, and developers to deliver reliable and performant data solutions.

• Apply best practices for data quality, performance, reliability, and automation .

• Lead technical design reviews, mentor engineers, and ensure compliance with enterprise standards.

What We’re Looking For

• 8+ years of data engineering experience, including leading or mentoring teams.

• Proven expertise with Ab Initio development (required).

• Hands-on experience building data pipelines in AWS environments .

• Strong knowledge of ETL/ELT processes, data modeling, and SQL/NoSQL databases .

• Programming skills in SQL, Python, or similar languages .

• Excellent communication and problem-solving skills with the ability to collaborate across functions.

Nice to Have

• Experience supporting AI/ML or data-driven applications .

• Familiarity with data lake, data warehouse, and big data technologies .

• AWS certifications or cloud data engineering credentials.

System One, and its subsidiaries including Joulé, ALTA IT Services, TeamPeople, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.