Specialist Software Cloud Developer

CPKC; Calgary; On-site; CAD 110,000 - 140,000; Full time

Benefits offered by this job

Flexible benefits package

Company pension plan

Employee Share Purchase Plan

Performance Incentive Program

Annual Fitness Subsidy

Part-time Studies Program

Job summary

CPKC (Calgary, Alberta) is seeking an experienced Cloud Development Specialist to lead serverless cloud and data engineering initiatives. You will design and implement ETL/ELT pipelines, work with Snowflake, Informatica, PySpark, and Python, and collaborate with teams across cloud, data science, and operations.

The role demands hands-on full-stack cloud development, strong SQL, and knowledge of AWS services such as Lambda and CloudWatch, with incident response and on-call duties as part of the

Qualifications

• Bachelor's degree in Computer Science or related field.
• 5+ years in AWS cloud development with data engineering/ETL/ELT.
• Strong SQL and enterprise integration tooling experience.

Responsibilities

• Maintain, support, and monitor production applications, data processes, and cloud services.
• Design, develop, and maintain ETL/ELT workflows from diverse sources.
• Utilize SQL, Python, Informatica, Snowflake, PySpark for data wrangling and transformation.
• Build scalable data pipelines from ingestion to analytics with quality controls.
• Collaborate with architects, analysts, and business stakeholders.
• Provide 24/7 on-call cloud support and ensure security/compliance.

Skills

AWS Cloud

Data Engineering

SQL

Python

ETL/ELT

Snowflake

Informatica

CI/CD

Big Data

Education

Bachelor's degree in CS

Tools

Snowflake

Informatica

CloudFormation

CDK

Job description

Posting Start Date: 9/18/26

Join CPKC, North America’s first transnational railroad connecting U.S., Canada, and Mexico, where your career drives progress and safety is paramount. We connect communities, fuel economic growth, and provide meaningful work in a culture that values diversity, accountability, and pride. With opportunities for training, development, and advancement, you’re not just building a career—you’re part of something bigger. Together, we move goods, connect people, and create lasting change. Your future starts here.

PURPOSE OF THE POSITION

The Cloud Team delivers cloud-based solutions across CPKC, providing expertise in AWS and Azure to support real‑time data processing, on‑premises integrations, custom web applications, AI, containers, and EC2‑hosted workloads. The team also designs, develops, and maintains enterprise data integration solutions, working with diverse data sources including Oracle, SQL Server, SAP, SAP BW, Snowflake and other enterprise systems across on-premises and cloud environments. The Specialist Cloud Development position focuses on serverless cloud technologies and data engineering/integration and requires an experienced hands‑on full‑stack cloud and data developer who can lead technical initiatives in collaboration with other developers, solution architects, business analysts, and business stakeholders.

POSITION ACCOUNTABILITIES

• Maintain, support, and monitor production applications, data processes, and cloud services - including incident resolution and root‑cause analysis
• Design, develop, and maintain ETL/ELT workflows to extract data from diverse sources including Oracle, SQL Server, SAP, SAP BW, Snowflake, AWS, Azure, GCP, and other enterprise systems
• Utilize SQL, Python, Informatica, Snowflake, PySpark, and additional data integration technologies to wrangle, transform, and consolidate data from on-premises and cloud environments
• Build, optimize, and maintain scalable data pipeline architecture (including time series pipelines) from ingestion to analytics, ensuring data quality, integrity, and accessibility through robust pipeline architecture and documentation
• Assemble large, complex datasets that meet functional and non‑functional business requirements
• Identify and implement internal process improvements, including automation and performance optimization for data delivery
• Follow and contribute to development standards (naming, documentation, promotion, integrations, code repositories)
• Monitor cloud usage and recommend cost‑optimization strategies
• Collaborate with cloud team members, architects, developers, data scientists, and engineers to ensure best‑practice solutions across cloud, big data, NLP, and ML
• Provide sustainment duties, including 24/7 on‑call rotation for cloud support
• Maintain security and confidentiality standards while staying aware of emerging trends in cloud computing and serverless technologies

POSITION REQUIREMENTS

• Bachelor’s degree in Computer Science or related field
• 5+ years of experience in AWS cloud development combined with data engineering / ETL / ELT development, strong SQL, and enterprise integration tools (e.g., Snowflake, Informatica)
• Strong programming skills in Python and SQL, with exposure to TypeScript, React, and Node.js for cloud applications
• Hands‑on experience with core AWS services (Lambda, CloudWatch) and Infrastructure as Code (CloudFormation, CDK)
• Solid understanding of AWS architecture and infrastructure components (VPCs, EC2, ELB, EBS) and AWS development tools (CDK, CLI, Amplify)
• Experience building data pipelines and large‑scale cloud solutions using tools such as PySpark, Pandas, APIs, and modern data platforms (Snowflake, Palantir)
• Knowledge of data architecture and governance including data modeling, warehousing, quality frameworks, and integrations (SAP/SAP BW, Oracle, SQL Server, NoSQL)
• Familiarity with AI/ML tools (Amazon Bedrock, SageMaker), CI/CD pipelines, cloud security best practices, and exposure to Azure or GCP as an asset

WHAT CPKC HAS TO OFFER

• Flexible and competitive benefits package
• Competitive company pension plan
• Employee Share Purchase Plan
• Performance Incentive Program
• Annual Fitness Subsidy
• Part‑time Studies Program

PRE-EMPLOYMENT REQUIREMENTS

Background Investigation

• Criminal history check
• Education verification
• Professional references

BECOMING A RAILROADER

As an employee with a North American presence, the possibility does exist that the location of your position may be changed based on organizational requirements.

Management Conductor Program

Becoming a qualified conductor or locomotive engineer is the single best way for a management employee to learn the business at CPKC. You may be required to obtain a certification or to maintain your current certification/qualification as a conductor or locomotive engineer.

CULTURE OF INCLUSION

For our U.S. applicants, CPKC is an equal opportunity/affirmative action employer, inclusive of protected veterans and individuals with disabilities. For Canadian applicants CPKC is an employment equity employer committed to the principles of employment equity and inclusion. We encourage all qualified candidates to apply including: women, Black, Indigenous, People of Color (BIPOC), members of the LGBTQ+ community and people with disabilities. Accommodations for the job application process can be provided, as appropriate, upon request. All applicant information will be managed in accordance with the federal Personal Information Protection and Electronic Documents Act (PIPEDA).

• Req ID: 106497
• Department: Information Services & Network Service Centre (NSC)
• Job Type: Full-Time
• Position Type: Non-Union
• Location: Calgary, Alberta
• Country: Canada
• % of Travel: 0-10%
• # of Positions: 1
• Job Grade: 4
• Job Available to: Internal & External