Back to jobs

Data Architect

Calgary, AB, CA, T2G 3J5

Live, first seen by us 19 days ago
Pay
Pay not listedSimilar roles state $155K–$227K
Work setting
Not stated
Employment
Fixed-term — employment source
Department: Information Services & Network Service Centre (NSC) Job Type: Fixed Term Position Type: Non-Union
Read the full posting

What you’ll work on

Full posting
  • Design and evolve scalable data architecture, warehouse frameworks and end-to-end pipelines

  • Define and enforce data modeling standards and improve data quality

  • Standardize and automate reporting solutions

  • Build tools and governance frameworks that strengthen data management

  • Translate business requirements into data solutions and architecture roadmaps

From the employer’s posting
Design, maintain, and continuously evolve scalable data architecture, data warehouse frameworks, and end-to-end data pipelines
Define and enforce data modeling standards while innovating, transforming, validating, creating, and optimizing data sources
Standardize and automate reporting solutions
Build tools, processes, and governance frameworks that strengthen data management
translating requirements into effective data solutions and architecture roadmaps
Apply at CPKC

Posting record

Report an error
Status in our records
Live
First seen by us
Nov 2, 202619 days ago
Recorded sightings
20
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$155K–$227K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 3,272 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 19

Similar jobs usually come down between day 8 and day 57.

From 9,984 similar postings that came down. Coming down is not always a hire.

CPKC is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Snowflake
Where the posting names them
- 3+ years of hands-on experience with Snowflake Data Cloud, including Snowpipe, Streams, Tasks, and the design and implementation of modern data warehouse architectures - Proven experience designing and implementing ETL/ELT frameworks, data flows, and scalable data integration solutions using SQL and database technologies - Strong knowledge of data governance, data quality, and architectural best practices, with demonstrated expertise applying data analysis to reporting, modeling, and AI/ML initiatives
- 6+ years of experience in data architecture, data management, data modeling, schema design, database optimization, data mining, data preparation, visualization, and process development - 3+ years of hands-on experience with Snowflake Data Cloud, including Snowpipe, Streams, Tasks, and the design and implementation of modern data warehouse architectures - Proven experience designing and implementing ETL/ELT frameworks, data flows, and scalable data integration solutions using SQL and database technologies

Your next step

Complete your application on careers.cpr.ca. The employer’s form will show what is required.

Applying through SAP SuccessFactors

  • Images (.jpg) aren’t accepted as a resume.

Already applied? Track this application

Job description

View original posting ↗

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 Data Architect, you will play a key role in driving the organization's data and analytics transformation by designing and delivering modern, scalable data solutions that turn complex data into actionable business insights. Working within the Business Intelligence & Data Analytics team, you will collaborate with business and technology stakeholders to architect robust data platforms that support reporting, advanced analytics, real-time data processing, and emerging AI and Machine Learning initiatives. This is an exciting opportunity to influence enterprise data strategy, leverage cutting-edge technologies, and enable data-driven decision-making across the organization while helping shape the future of analytics and innovation.

This is a 1-year Fixed Term Contract

 

POSITION ACCOUNTABILITIES:

  • Design, maintain, and continuously evolve scalable data architecture, data warehouse frameworks, and end-to-end data pipelines that support Business Intelligence, reporting, analytics, and predictive modeling
  • Define and enforce data modeling standards while innovating, transforming, validating, creating, and optimizing data sources to ensure data quality, consistency, and usability across the enterprise
  • Standardize and automate reporting solutions while developing a deep understanding of existing Business Intelligence platforms and business data needs
  • Build tools, processes, and governance frameworks that strengthen data management, improve data integrity, and support scalable analytics capabilities
  • Partner with business analysts, architects, developers, and stakeholders as a liaison between business and technical teams, translating requirements into effective data solutions and architecture roadmaps
  • Drive continuous improvement by analyzing business needs, recommending and implementing efficiencies, presenting solutions to diverse audiences, managing stakeholder relationships and priorities, and contributing to AI and Machine Learning initiatives that enable advanced analytics and actionable insights

 

POSITION REQUIREMENTS:

  • University degree in Computer Science, Information Systems, Engineering, or a related discipline, or an equivalent combination of education and experience
  • 6+ years of experience in data architecture, data management, data modeling, schema design, database optimization, data mining, data preparation, visualization, and process development
  • 3+ years of hands-on experience with Snowflake Data Cloud, including Snowpipe, Streams, Tasks, and the design and implementation of modern data warehouse architectures
  • Proven experience designing and implementing ETL/ELT frameworks, data flows, and scalable data integration solutions using SQL and database technologies
  • Strong knowledge of data governance, data quality, and architectural best practices, with demonstrated expertise applying data analysis to reporting, modeling, and AI/ML initiatives
  • Exceptional analytical, communication, and stakeholder management skills with the ability to interpret complex data, present insights to technical and non-technical audiences, work independently, and develop effective plans aligned to business objectives and priorities
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

 

WHAT CPKC HAS TO OFFER:

  • Free Parking
  • Free Gym

 

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: 106575
  • Department: Information Services & Network Service Centre (NSC)
  • Job Type: Fixed Term
  • Position Type: Non-Union
  • Location: Calgary, Alberta
  • Country: Canada
  • % of Travel: 0-10%
  • # of Positions: 1
  • Job Grade: 3
  • Job Available to: Internal & External

 

#LI-ONSITE

#LI-HN2

Demand for Data Leadership roles

New Data Leadership postings at the employers we follow are up 8% over the last 6 weeks compared with the 6 before.

Weekly new Data Leadership postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 751, the most 1,165, and the latest week had 775.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Leadership, by the work the posting describes.

Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.

Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.

Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.

US government figures for computer and information systems managers

Median yearly pay, May 2025
$175,140
Expected change, 2025 to 2035
15.8% more jobsagainst 3.5% for all jobs

The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 11-3021.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Calgary, AB, CA, T2G 3J5

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.