Data Architect

Job summary

Design and evolve scalable data architectures, warehouses, and pipelines that support business intelligence, reporting, analytics, predictive modeling, and AI/ML initiatives. Establish data modeling and governance practices, improve data quality and reporting, and collaborate with business and technical stakeholders to translate requirements into effective data solutions.

Job details

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

What you’ll do

Design and evolve scalable data architectures, warehouses, and pipelines that support business intelligence, reporting, analytics, predictive modeling, and AI/ML initiatives. Establish data modeling and governance practices, improve data quality and reporting, and collaborate with business and technical stakeholders to translate requirements into effective data solutions.

Requirements

Requires a university degree in Computer Science, Information Systems, Engineering, or a related discipline, or equivalent education and experience, plus 6 or more years of relevant data experience. Candidates need at least 3 years of hands-on Snowflake experience, expertise in ETL/ELT, SQL, data integration, governance, and quality, and strong analytical and stakeholder communication skills.

Benefits

• Free Parking
• Free Gym

Listed skills

• SQL · Preferred
• Machine learning · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Data Architecture
• Data Modeling
• Snowflake
• Snowpipe
• Streams
• Tasks
• ETL/ELT
• SQL
• Data Warehousing
• Data Integration
• Data Governance
• Data Quality
• Database Optimization
• Business Intelligence
• Data Analytics
• Machine Learning

Job areas

• Data & Analytics
• Technology
• Transportation
• Logistics

More jobs from CPKC