Python & AWS Data Engineer

Capgemini • New York, NY

1d • $86,129 - $127,189 • Onsite

About The Position

Seeking a highly skilled and motivated Senior Data Engineer to support enterprise data modernization initiatives. This role requires deep expertise in Python, AWS, and relational databases, combined with strong experience in mainframe technologies (VSAM, DB2). The candidate will play a critical role in end-to-end data migration, transforming legacy data systems into modern, scalable cloud-based architectures while ensuring data accuracy, integrity, and governance standards.

Requirements

• Deep expertise in Python
• Deep expertise in AWS
• Deep expertise in relational databases
• Strong experience in mainframe technologies (VSAM, DB2)

Responsibilities

• Lead and execute end-to-end data migration efforts, including planning, design, execution, validation, and post-migration support.
• Analyze legacy data structures (VSAM, DB2) and design transformation strategies into modern RDBMS and AWS environments.
• Develop and maintain data pipelines and automation scripts using Python.
• Design, implement, and maintain data models (conceptual, logical, and physical).
• Manage and administer AWS RDS environments, ensuring high availability, performance optimization, and security compliance.
• Collaborate with business and technology stakeholders to gather and translate requirements into scalable data solutions.
• Ensure adherence to data governance, data quality, and compliance standards.
• Troubleshoot data-related issues and provide timely resolution.
• Prepare technical documentation for data models, migration workflows, and architecture designs.

Benefits

• Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave
• Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
• Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed