Python & AWS Data Engineer

Capgemini; New York (NY); On-site; USD 86,129 - 127,189; Full time

Benefits offered by this job

Paid time off

Medical, dental, and vision coverage

Retirement savings plans

Life and disability insurance

Employee assistance programs

Job summary

Capgemini is seeking a highly skilled Senior Data Engineer for a role focused on enterprise data modernization initiatives, based in New York, Chicago, and Atlanta. This position emphasizes expertise in Python, AWS, and relational databases.

As a Senior Data Engineer, you will play a critical role in leading end-to-end data migration while ensuring accuracy and compliance. Capgemini offers a comprehensive benefits package including medical coverage and retirement savings plans.

Qualifications

• Deep expertise in Python and AWS.
• Strong experience in relational databases and mainframe technologies.
• Ability to ensure data accuracy, integrity, and governance.

Responsibilities

• Lead and execute end-to-end data migration efforts.
• Analyze legacy data structures and design transformation strategies.
• Develop and maintain data pipelines and automation scripts.
• Collaborate with stakeholders to gather requirements.

Skills

Python

AWS

Relational databases

Mainframe technologies (VSAM, DB2)

Tools

AWS RDS

Job description

Python & AWS Data Engineer

Onsite location: New York, Chicago & Atlanta

Job Description

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.

Key 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.

Compensation

The base compensation range for this role in the posted location is: $86,129 to $127,189.

Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law.

These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity.

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

Capgemini is an Equal Opportunity Employer encouraging inclusion in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status, or any other characteristic protected by law.