Sr Data Analyst

CPKC

CPKC, the united front of Canadian Pacific and Kansas City Southern, stands as the sole North American railway crossing international borders. This pivotal role supports enterprise-wide business intelligence and data warehouse initiatives, driving the company's expansion into its vast transnational network. By joining, candidates will become part of a historical endeavor connecting Canada, the U.S., and Mexico.

In this role you can expect to have the responsibilities:

• Lead BI-SDLC projects collaborating with various teams.
• Transform business requirements into technical specifications.
• Design high-performance data models and SQL scripts.
• Manage project-specific documentation and data governance.
• Conduct functional testing, unit testing, and test case preparation.

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.
• Five years of relevant professional experience.

You would benefit from having:

• Experience with Power BI, SQL Server, and SQL scripts.
• Proficiency in data visualization tools and data transformation.
• Understanding of various database platforms and metadata repositories.

The location of the position may change based on organizational needs. All new hires undergo a drug screen, and various clearances including background checks are required. Participation in the Management Conductor Program may be necessary. CPKC champions equal opportunity employment.