Business Intelligence Manager

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:

This individual will participate in developing business intelligence solutions that collect, analyze, and present information to the business, and subsequently develop the solution to address the business requirements. 

POSITION ACCOUNTABILITIES:

• Leads a professional team responsible for the design, development and delivery of timely, accurate, comprehensive reports and Dashboards
• Responsible for successful delivery of functional and technical components of Business Intelligence (BI) reporting solutions using Qlikview,Qliksense and Power Bi
• Operational and Business Objectives: Collaborate with Executive Management, Finance, Engineering, and Operations teams to define and understand operational and business objectives, ensuring alignment with overall organizational goals.
• Business Requirements and Metrics: Gather and document business requirements, and Key Performance Indicators (KPIs) to establish benchmarks and evaluate success criteria.
• Data Analysis and Reporting: Analyze performance data from business, operations, and software systems to identify trends, patterns, and insights. Convert business performance objectives and requirements into clear and actionable reports and presentations.
• Interactive Reporting and Dashboards: Build and test interactive operational reports, analytics, and dashboards using tools such as PowerBI, Excel, or other suitable software, providing stakeholders with real-time access to relevant data.
• Query Development: Develop and execute queries to extract, transform, and analyze data from SQL databases, Excel spreadsheets, and other relevant sources to support reporting and data analysis requirements.
• Performance Improvement: Collaborate with Engineering, Software, Data, and Operations teams to drive performance improvement initiatives based on analytical insights, identifying areas for optimization, efficiency, and process enhancements.
• Collaboration and Project Management: Work in a highly collaborative manner, engaging with cross-functional teams to ensure smooth project execution and timely delivery of analytical solutions. Leverage project management skills to coordinate tasks, timelines, and resources effectively.

POSITION REQUIREMENTS:

• Bachelor’s degree in Computer Science, Information Systems, or equivalent education or work experience.
• Minimum of 7+ years of experience in Reporting using Qlikview and Qlik Sense
• Minimum 3 years as a functional manager managing a team od 15-20 individuals
• Highly proficient with data analysis, analytics, and reporting, with a track record of delivering insights and actionable recommendations.
• Experience in report and dashboard development, data modeling, and data visualization.
• Proficiency in working with SQL or HANA databases, including data extraction, transformation, and analysis.
• Adaptable and flexible to a fast-paced work environment and shifting priorities and responsibilities
• Leading the design and development of system integration using APIs, FTP, and other integration software.
• Minimum of 7-10 years of experience in Power BI - Nice to have

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

ADDITIONAL INFORMATION:

As an employer with North American presence, the possibility does exist that the location of your position may be changed based on organizational requirements.

Background Investigation:

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

• Criminal history check
• Reference check

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.

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

• Req ID: 101721
• Department: Information Services
• Job Type: Full-Time
• Position Type: Non-Union
• Location: Calgary, Alberta
• Country: Canada
• % of Travel:
• # of Positions: 1
• Job Grade: 3
• Job Available to: Internal & External

#LI-GK1

#LI-ONSITE