Data Engineer and Modeler

About the role

We are seeking an experienced Data Engineer and Modeler with deep expertise in designing relational data models, building scalable ETL/ELT pipelines, and processing large datasets across modern cloud environments. This role is ideal for engineers who excel at transforming complex data into reliable, high quality structures that power enterprise applications, analytics, and reporting. You will work closely with engineering, analytics, and product teams to deliver robust, cloud native data solutions on AWS.

Responsibilities

• Design, develop, and optimize data pipelines to process large volumes of structured and unstructured data.
• Build and maintain relational data models (RDBMS) for transactional systems, operational data stores, and reporting environments.
• Work extensively with Oracle, Postgres (Aurora RDS), and Snowflake databases.
• Perform large scale data analysis, transformation, and automation using Python, including handling massive datasets.
• Develop and maintain Java based APIs and microservices for data access, ingestion, and integration.
• Implement CI/CD workflows using Jenkins, UDeploy, and container technologies such as Docker and Kubernetes.
• Design and support ETL/ELT processes, ensuring data quality, reliability, and performance across pipelines.
• Lead and execute data migration initiatives, including schema mapping, validation, reconciliation, and cutover planning.
• Build cloud native data solutions using AWS services such as RDS, S3, Lambda, Glue, and more.
• Collaborate with cross functional teams to understand data requirements and deliver scalable, high performing solutions.

Requirements

• 6-9 years of software development experience, with a strong focus on data engineering.
• Extensive experience handling and processing large volumes of data.
• Strong proficiency in RDBMS data modeling for operational and reporting systems.
• Hands on experience with Oracle, Postgres (Aurora RDS), and Snowflake.
• Proficiency in Python for large scale data analysis, transformation, and automation.
• Strong experience with Java, including building APIs and microservices.
• CI/CD and containerization experience with Jenkins, UDeploy, Docker, and Kubernetes.
• Solid understanding of ETL/ELT tools and processes.
• Experience with data migrations, including mapping, validation, and reconciliation.
• Hands on experience with AWS cloud computing and cloud native development.
• Strong communication, organizational skills, and attention to detail.

Qualifications

• Bachelor's degree in Computer Science or related field.

Benefits

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 $77,800.00 - $172,400.00.

CGI provides reasonable accommodations to qualified individuals with disabilities. If you need an accommodation to apply for a job in the U.S., please email the CGI U.S. Employment Compliance mailbox at US_Employment_Compliance@cgi.com. You will need to reference the Position ID of the position in which you are interested. Your message will be routed to the appropriate recruiter who will assist you. Please note, this email address is only to be used for those individuals who need an accommodation to apply for a job. Emails for any other reason or those that do not include a Position ID will not be returned.

We make it easy to translate military experience and skills! Click here to be directed to our site that is dedicated to veterans and transitioning service members.

All CGI offers of employment in the U.S. are contingent upon the ability to successfully complete a background investigation. Background investigation components can vary dependent upon specific assignment and/or level of US government security clearance held. Dependent upon role and/or federal government security clearance requirements, and in accordance with applicable laws, some background investigations may include a credit check.

CGI will consider for employment qualified applicants with arrests and conviction records in accordance with all local regulations and ordinances.