Power BI Developer

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:

CPKC is hiring an experienced Power BI Developer. 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. 

This position is located in Calgary or Kansas City. 

POSITION ACCOUNTABILITIES:

Responsibilities include, but are not limited to:

• Responsible for successful delivery of functional and technical components of Business Intelligence (BI) reporting solutions using Power BI

• Primary responsibilities include collaborating with cross-functional teams to gather and analyze business requirements, translate them into technical specifications, and implement BI solutions accordingly

• Design and develop complex Power BI solutions, including data models, reports, and dashboards, to support business requirements and drive data-driven decision-making

• Implement best practices for data modeling, data integration, and data visualization to ensure optimal performance, scalability, and usability of Power BI solutions

• Optimize DAX and M queries, as well as data transformation processes, to improve report performance and data refresh times

• Implement and manage security measures, including row-level security, object-level security, and data encryption, to ensure data confidentiality and compliance with regulatory requirements

• Stay updated with the latest developments in Power BI, including new features, updates, and best practices, and evaluate their applicability to the organization’s BI strategy

• Provide technical leadership and guidance to junior developers, as well as support and training to end-users, on Power BI tools, techniques, and best practices

• On-call support for Power BI reports, Dashboards

POSITION REQUIREMENTS:

• Bachelor’s degree in Computer Science, Information Systems, or any related field

• 5+ years of experience in developing business intelligence solutions using Power BI, with a strong focus on data modeling, data visualization, and report development

• Expertise in SQL, DAX, and M languages, as well as proficiency in data integration techniques using Power Query Editor

• Good understanding of following tools:

            Tabular Editor

            SSAS

            DAX Studio

            ALM Toolkit

• Relevant certifications in Power BI (e.g., Microsoft Certified: Data Analyst Associate) is an asset

• Knowledge of the Railway business is an asset

WHAT CPKC HAS TO OFFER:

• Flexible and competitive benefits package
• Competitive company pension and/or retirement plans
• 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
• Driver’s License verification and/or last 3 years of driving history if a requirement of the position
• Background checks that may included 7 years of employment history and Social Security number verification

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.

For our US 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 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: 102841
• Department: Information Services
• Job Type: Full-Time
• Position Type: Non-Union
• Location: Calgary, Alberta
• Country: Canada
• % of Travel: 0-10%
• # of Positions: 2
• Job Grade: 4
• Job Available to: Internal & External

#LI-ONSITE

#LI-GK1