Data Analyst II

Canadian Pacific (CP) and Kansas City Southern (KCS) are now CPKC. As the only truly North American railway, we are making big moves! Drawing on our strong foundations and heritage, CPKC moves essential goods across our 20,000-mile network to support economic growth throughout Canada, the U.S. and Mexico. Be a part of history as we connect a continent and create exciting career opportunities across our new transnational network. Visit cpkcr.com to learn about the CPKC advantage, our purpose and culture

Purpose of the position

The Data Analyst II position at Canadian Pacific Kansas City (CPKC) provides an outstanding chance to be a part of data-driven decision making in a credible transportation network. This role plays a crucial role in converting data into actionable insights, improving business intelligence solutions, and ensuring data integrity and accuracy. Join our driven team to contribute to the future of North American rail transportation, with equivalent experience accepted.

The Data Analyst II supports data analysis by translating business requirements into specifications and improving BI solutions. They assist senior analysts in handling requirements and ensuring data accuracy for BI reporting.

Position requirements

• This role supports business intelligence (BI) and data analysis by helping translate business needs into requirements and contributing to BI solutions.
• Major responsibilities include collaborating with team members to gather and detail business requirements, performing data analysis and testing, supporting data model and flow detailing.
• Your role will involve aligning data accurately with business needs, maintaining data integrity, and effectively communicating data insights. This will support decision-making and contribute to the successful delivery of Data projects.
• This position supports the development and maintenance of business analytics solutions by assisting in the translation of business requirements into deliverables.
• This role requires working closely with senior data analysts to analyze and validate data, contribute to data models, and support documentation efforts for consistent and accurate data representation.
• This position is vital for ensuring BI solutions meet business needs, improve data integrity, and support accurate, timely decision-making by providing valuable insights and reports aligned with organizational goals.
• Bachelor's degree or equivalent experience from an accredited university or college, preferably in a job-related major field of study.
• 2 years of professional experience, or equivalent combination of education and experience an asset.

Position accountabilities

• The role primarily interacts with collaborators from different departments to support BI and data-driven projects. Key contacts and the nature of communication include: Senior Data Analyst, Data Scientist, BI Developers, Business Collaborators.
• The role deals with moderately complex problems that require a basic understanding of business objectives.
• Innovation in the role typically focuses on finding efficient ways to integrate and streamline data across systems to improve reporting accuracy and usability.
• The position supports innovations by adapting and refining data analysis, testing new visualization techniques, and proposing improvements to data workflows and processes to ensure flawless data delivery.

What CPKC has to offer

• Flexible and competitive benefits package
• Competitive company pension plan
• Employee Share Purchase Plan
• Performance Incentive Program
• Annual Fitness Subsidy
• Part-time Studies Program
• Relocation package for those who are eligible

Background investigation

The successful candidate will need to successfully complete the following clearances:

• Criminal history check
• Reference checks

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