Data Architect

Posting Start Date: 10/8/26Join 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 ContractPOSITION 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 modelingDefine and enforce data modeling standards while innovating, transforming, validating, creating, and optimizing data sources to ensure data quality, consistency, and usability across the enterpriseStandardize and automate reporting solutions while developing a deep understanding of existing Business Intelligence platforms and business data needsBuild tools, processes, and governance frameworks that strengthen data management, improve data integrity, and support scalable analytics capabilitiesPartner with business analysts, architects, developers, and stakeholders as a liaison between business and technical teams, translating requirements into effective data solutions and architecture roadmapsDrive 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 insightsPOSITION REQUIREMENTS:
University degree in Computer Science, Information Systems, Engineering, or a related discipline, or an equivalent combination of education and experience6+ years of experience in data architecture, data management, data modeling, schema design, database optimization, data mining, data preparation, visualization, and process development3+ years of hands‑on experience with Snowflake Data Cloud, including Snowpipe, Streams, Tasks, and the design and implementation of modern data warehouse architecturesProven experience designing and implementing ETL/ELT frameworks, data flows, and scalable data integration solutions using SQL and database technologiesStrong knowledge of data governance, data quality, and architectural best practices, with demonstrated expertise applying data analysis to reporting, modeling, and AI/ML initiativesExceptional 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 prioritiesExperience 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 ParkingFree GymPRE-EMPLOYMENT REQUIREMENTS:
Background Investigation
Criminal history checkEducation verificationProfessional referencesBECOMING 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 TermPosition Type: Non-UnionLocation: Calgary, AlbertaCountry: Canada% of Travel: 0-10%# of Positions: 1Job Grade: 3Job Available to: Internal & External
#J-18808-Ljbffr