Specialist Software Cloud Developer

Canadian Pacific Railway; Calgary; On-site; CAD 100,000 - 150,000; Full time

Benefits offered by this job

Benefits package

Pension plan

Employee Share Purchase Plan

Performance Incentive Program

Job summary

Canadian Pacific Railway (CPRC) is seeking an experienced Specialist Cloud Developer to lead serverless cloud and data integration initiatives across AWS, Azure, and on‑premises environments. You will design, build, and maintain data pipelines, collaborate with architects, data scientists, and engineers, and drive real‑time data processing and governance.

The role requires strong Python and SQL skills, hands‑on AWS service experience, and the ability to deliver scalable solutions while ensuring

Qualifications

• Bachelor's degree in Computer Science or related field
• 5+ years of AWS cloud development and data engineering experience
• Strong SQL and enterprise integration tools (Snowflake, Informatica)

Responsibilities

• Maintain and monitor production applications and cloud services
• Design and maintain ETL/ELT workflows across diverse sources
• Build scalable data pipelines from ingestion to analytics and ensure data quality

Skills

AWS Cloud

Data engineering

SQL

Python

ETL/ELT

Education

Bachelor’s degree in Computer Science

Tools

Snowflake

Informatica

CloudFormation

CDK

Job description

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 technologiesanddata engineering/integrationandrequires an experienced hands‑onfull-stack cloud and data developerwho 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

PRE-EMPLOYMENT REQUIREMENTS:

• 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).