Sr Data Analyst

CPKC

CPKC is a company formed from the merger of Canadian Pacific and Kansas City Southern, creating the only truly North American railway. With a network spanning 20,000 miles, CPKC supports economic growth across North America by moving essential goods. This role in the Strategic Planning & Corporate Services department offers the chance to be part of a historic transformation and contribute to the success of a transnational network.

In this role you can expect to have the responsibilities:

• Lead Business Intelligence Software Delivery Lifecycle projects.
• Collaborate with system integration, cloud data architects, and Power BI teams.
• Translate business requirements into technical specifications.
• Independently develop Business Requirements Documents (BRD) and Technical Design Documents (TDD).
• Design and enhance data models for performance optimization.
• Document project processes, data flows, and establish data dictionaries.

This role comes with the following benefits:

• Flexible and competitive benefits package.
• Employer Funded Retirement Plan.
• Employee Share Purchase Plan.
• Performance Incentive Program.
• Annual Fitness Subsidy.
• Part-time Studies Program.

This role requires you to have:

• Bachelor's degree in a relevant field.
• At least 5 years of relevant professional experience.

You would benefit from having:

• 3+ years with DAX, R, Python, or similar tools.
• Experience with warehouse data extraction and metadata tools.
• Proficiency in using Power BI for data visualization.
• Understanding of SDLC and ETL processes.

The position may require relocation based on organizational needs, with up to 10% travel. Successful candidates must pass a drug test and background checks. CPKC is committed to safety and offers an inclusive work environment.