AWS Python Developer with ETL

Category: Software Development/ Engineering

Main location: United States, Virginia, reston

Position ID:J0826-2177

Employment Type: Full Time

U.S. - Work-life flexibility

Position Description:

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.

The Data Engineer will build and maintain ETL/ELT processes, perform source to target data mapping and data quality validation, optimize SQL workloads, and support reporting and analytics needs. The role also includes production troubleshooting, testing, technical documentation, and close collaboration with business stakeholders, data analysts, and development teams.

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

Your future duties and responsibilities:

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.

The Data Engineer will build and maintain ETL/ELT processes, perform source to target data mapping and data quality validation, optimize SQL workloads, and support reporting and analytics needs. The role also includes production troubleshooting, testing, technical documentation, and close collaboration with business stakeholders, data analysts, and development teams.

Required qualifications to be successful in this role:

. 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.
. Experience creating and executing test cases for data pipelines, data validation, and reporting solutions.
. Working knowledge of Business Intelligence (BI), reporting, and analytics concepts.
. Ability to troubleshoot production data issues, perform root cause analysis, and implement corrective actions.
. Experience working in an Agile/Scrum environment and using JIRA to manage work items and defects.
. Strong technical documentation skills, including mapping documents, data dictionaries, technical specifications, and operational procedures.
. Strong communication and collaboration skills, particularly when working with business and technical teams.
. Financial services or other highly regulated industry experience is beneficial.

Education:
Bachelor's degree in Computer Science, Information Systems, or a related field.

Other Information:
CGI is required by law in some jurisdictions to include a reasonable estimate of the compensation range for this role. The determination of this range includes various factors not limited to skill set, level, experience, relevant training, and licensure and certifications. To support the ability to reward for merit based performance, CGI typically does not hire individuals at or near the top of the range for their role. Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $70,800.00 $123,800.00.
CGI's benefits are offered to eligible professionals on their first day of employment to include: . 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

Skills:

• Agile
• Amazon Web Services Cloud
• Communication
• ETL
• Python
• SCRUM
• Data Engineering
• Data Engineering