Data Architect

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

Benefits offered by this job

Free Parking

Free Gym

Job summary

CPKC is hiring a Data Architect in Calgary, Alberta, for a 1-year fixed-term contract. The role focuses on designing scalable data platforms, data warehouses, and end-to-end pipelines to support reporting, analytics, and AI initiatives.

Collaboration with business and technical teams is essential to drive enterprise data strategy. The position requires 6+ years in data architecture, Snowflake experience (Snowpipe/Streams/Tasks), and strong SQL skills.

Qualifications

• 6+ years of experience in data architecture, data management, modeling, and analytics.
• Experience with Snowflake Data Cloud, Snowpipe, Streams, Tasks.
• Strong SQL skills and data integration expertise.

Responsibilities

• Design and evolve scalable data architecture, data warehouses, and end-to-end pipelines for BI and analytics.
• Define and enforce data modeling standards to ensure data quality and usability.
• Standardize reporting solutions and deepen understanding of BI platforms and business needs.
• Build governance frameworks to strengthen data management and scalability.
• Collaborate with analysts, architects, developers, and stakeholders to translate requirements into data solutions.
• Drive continuous improvement and contribute to AI/ML initiatives for advanced analytics.

Skills

Data architecture

Data modeling

ETL/ELT

SQL

Data governance

Stakeholder management

Education

University degree in Computer Science/Information Systems/Engineering

Tools

Snowflake

Job description

Posting Start Date: 10/8/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 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).

• 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