Senior Data Specialist/Consultant

Position Description This is an exciting time for CGI, and we want you to be part of it. We are Canada's largest independent information technology services firm, and we are still growing! We are expanding in Atlantic Canada, and we need your skills, enthusiasm, and dedication as part of our team. We are seeking a highly skilled Data Engineers to join our dynamic team. In this role, you will be responsible for managing and optimizing the data infrastructure, implementing data governance frameworks, and developing real-time data streaming solutions. This role requires expertise in AWS data streams (CDC), Postgres, Terraform, Git, Python, BigQuery CSW. If you are passionate about data, we would love to hear from you. Join this exciting new initiative as a Data Practitioner. Your future duties and responsibilities

• Design, build, and maintain data pipelines using AWS services with a focus on AWS Data Streams and Change Data Capture (CDC) patterns.
• Develop ETL/ELT workflows to ingest and transform data from PostgreSQL and other sources into BigQuery (using CSW or similar tools).
• Implement infrastructure as code using Terraform to manage cloud resources.
• Write clean, scalable, and maintainable code in Python for data transformation, automation, and orchestration.
• Collaborate using Git for version control and code reviews.
• Optimize data storage, transfer, and processing performance for large-scale datasets.
• Work cross-functionally to ensure data quality, observability, and consistency across systems.

Required Qualifications To Be Successful In This Role

• Strong experience with AWS Data Streams (Kinesis) and implementing CDC pipelines.
• Proficient in Python for data engineering and automation tasks.
• Hands-on experience with PostgreSQL, including schema design and query optimization.
• Experience working with BigQuery and CSW (Cloud Storage Writer) or similar data loading tools.
• Solid knowledge of Terraform for infrastructure-as-code and managing cloud environments.
• Proficient in Git and collaborative development workflows (e.g., pull requests, CI/CD).
• Experience building data pipelines in cloud environments, preferably AWS and GCP.
• Familiarity with data pipeline orchestration tools (e.g., Airflow, Prefect) is a plus.

Preferred Qualifications

• Bachelor's degree in Computer Science, Engineering, or a related field.
• Experience with event-driven architectures and real-time analytics.
• Knowledge of data modeling and best practices in data warehousing.
• Familiarity with DevOps practices and CI/CD pipelines for data systems.

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 value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter. To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries. Come join our team—one of the largest IT and business consulting services firms in the world.