AWS Python Developer with ETL

About the role

CGI is seeking an experienced AWS Python Developer with ETL to develop, enhance, and support data pipelines and data processing solutions within a large-scale financial services environment. This role is well suited for a hands-on data engineer with strong Python and SQL skills and experience working with AWS data services. Responsibilities include building and maintaining ETL/ELT processes, performing source to target data mapping and data quality validation, optimizing SQL workloads, and supporting reporting and analytics needs. The role also includes production troubleshooting, testing, technical documentation, and close collaboration with business stakeholders, data analysts, and development teams.

Responsibilities

• Develop, enhance, and support data pipelines and data processing solutions.
• Build and maintain ETL/ELT processes.
• Perform source to target data mapping and data quality validation.
• Optimize SQL workloads, including complex queries, stored procedures, and query performance tuning.
• Support reporting and analytics needs.
• Troubleshoot production data issues, perform root cause analysis, and implement corrective actions.
• Create and execute test cases for data pipelines, data validation, and reporting solutions.
• Develop technical documentation, including mapping documents, data dictionaries, technical specifications, and operational procedures.
• Collaborate closely with business stakeholders, data analysts, and development teams.

Requirements

• 2+ years of professional experience in data engineering, data development, or a closely related role.
• Strong hands-on Python development experience for data processing, automation, and ETL/ELT workloads.
• Advanced SQL skills, including complex queries, stored procedures, database objects, and query performance optimization.
• Experience developing and supporting ETL/ELT data pipelines.
• Hands-on experience with AWS data services, ideally including AWS Lambda, Amazon Redshift, Apache Iceberg, and Amazon Glacier.
• Experience with source to target data mapping, data transformation, and data quality validation.
• Strong understanding of relational databases and data modeling/database concepts.
• Working knowledge of Business Intelligence (BI), reporting, and analytics concepts.
• Experience working in an Agile/Scrum environment and using JIRA to manage work items and defects.
• Strong communication and collaboration skills, particularly when working with business and technical teams.
• Financial services or other highly regulated industry experience is beneficial.
• Bachelor's degree in Computer Science, Information Systems, or a related field.

Location and Work Model

This role is located at a client site in either Reston, VA or Washington, DC. A hybrid working model is acceptable.

Pay

A reasonable estimate of the current range for this role in the U.S. is $70,800.00 – $123,800.00.

Benefits

• Competitive compensation
• Comprehensive insurance options
• Matching contributions through the 401(k) plan and the share purchase plan
• Paid time off for vacation, holidays, and sick time
• Paid parental leave
• Learning opportunities and tuition assistance
• Wellness and well-being programs