Python ETL Developer (GCP)

CGI is a global business and technology service provider with $11.5B in revenues. CGI is on a mission to help financial services organizations focus on servicing their clients. CGI supports 15 of the top 20 banks worldwide and our top 10 banking clients have worked with us for 26 years on average. Our clients have seen the value and commitment we bring through our products. This is why nearly $1.6 trillion in assets managed through CGI’s portfolio management, investment fund and asset management solutions.

This is a hybrid role that requires you to work from any of our office locations in Atlantic Canada two (2) days a week. This requirement is subject to change at any time.

• Design, develop, and optimize ETL workflows and data pipelines to support data migration and consolidation, leveraging API and Python.
• Implement data processing and transformation logic using Pandas and SQLAlchemy, with PySpark and Databricks knowledge as a plus.
• Develop and maintain relational database solutions, particularly with SQL.
• Collaborate with business analysts, data engineers, and IT teams to define ETL strategies and understand requirements.
• Utilize best practices and design patterns to ensure efficient and scalable development.
• Troubleshoot and resolve issues throughout the entire software lifecycle, ensuring readiness for go-live.
• Engage actively with data scientists, IT product managers, and IT Architects throughout the product lifecycle.

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• 4+ years of experience in ETL development and cloud-based data solutions.
• Strong proficiency in Python, with hands-on experience building and automating ETL pipelines.
• Solid understanding of Google Cloud Platform (GCP) services, especially BigQuery, Cloud Storage, Cloud Functions, Pub/Sub, and Dataflow.
• Proficiency in SQL for querying, transforming, and analyzing structured data in cloud environments like BigQuery.
• Experience with containerization using Docker and orchestration with Kubernetes (preferably GKE on GCP).
• Familiarity with workflow orchestration tools such as Cloud Composer (Airflow) or Argo Workflows.
• Exposure to PySpark or Databricks is a plus, especially for processing large-scale datasets.
• Ability to apply software engineering best practices and design patterns in ETL development.
• Strong communication and collaboration skills; experience working in DevOps or Agile teams.

#LI-OA1

• ETL
• Google Cloud Platform
• Python
• SQL

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI, we recognize the richness that diversity brings. We strive to create a work culture where all belong and collaborate with clients in building more inclusive communities. As an equal-opportunity employer, we want to empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.

Come join our team-one of the largest IT and business consulting services firms in the world.