Apply now »

Sr Data Analyst

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 to learn about the CPKC advantage, our purpose and culture.



This position is responsible for researching, analyzing and translating business requirements into technical specs and designing the logical and physical models that support the BI Enterprise DW development effort. This position is responsible for managing customer expectations by taking ownership as a Business Analyst and Data Analyst for complex Capital projects.



  • Functions as the lead for BI-SDLC (Business Intelligence Software Delivery Lifecycle) projects.
  • Collaborates and work closely with Business, System Integration, Cloud data architects, ETL (Extract, Transform, Load) Integration specialists and Power BI dashboard development team.
  • Analyzes and translate business requirements into technical requirements.
  • Develops BRD and/or TDD independently.
  • Designs and develops data models and applies best practices for optimum performance of the models.
  • Documents project specific processes and data flows, data dependencies, data definitions and relevant business rules. 
  • Establishes data dictionaries to support the buildout of a data governance infrastructure.
  • Converts functional requirements into technical specifications.
  • Performs data analysis, data mapping, functional testing, unit testing, and test case preparation using required tools based on project needs.
  • Designs and develops SQL scripts, ad hoc queries and data models for high performance projects and deliverables.
  • Works with project teams and business stewards to refine business requirements that produce well-designed and developed solutions.
  • Exemplifies CPKC Vision, Values, and Culture interactions with coworkers, business partners, customers and stakeholders.



  • Bachelor's degree from an accredited university or college, preferably in a job-related major field of study
  • Minimum five (5) years of relevant professional experience, or equivalent combination of education and experience


  • 3+ years of hands-on experience with DAX, R, Python, MML, SAS Enterprise Miner or similar tools in support of on-demand, real-time analytic services.
  • Experience with warehouse data extraction/transformation and load tools, as well as metadata repository tools.
  • Knowledge of various database platforms SAP,MS SQL Server
  • Data Visualization software preferably Power BI
  • Proficient with MS Office tools like PowerPoint, MS Project, Visio, Excel and Word and shell scripting.
  • Understands and evaluates existing SQL scripts and Data Models.
  • Experience with the SDLC and ETL Processes, data mining, database design development, data modelling, data governance and unit testing. 
  • Proficient in data transformation, consolidating data from multiple disparate sources, develop process workflows and wireframe sketches to help business design effective dashboard solutions.

Working Conditions

  • Works with diverse set of data sources, such as Streaming Data, Time series data, semi-structured and unstructured data.
  • Works to apply and develop appropriate statistical, machine learning, and/or deep learning models and algorithms to classify structured or unstructured data.
  • Demonstrates ability to communicate technical recommendations to a non-technical audience in a clear and concise manner.
  • Demonstrates ability to understand logical relationships and to ensure that programming faithfully replicates these relationships.
  • Demonstrates ability to test and validate programming steps.
  • Demonstrates strong written and oral communication skills.
  • Exhibits attention to detail, self-motivation creative problem solving, with proven ability to successfully manage multiple disparate streams of work in a challenging, dynamic environment
  • Demonstrates solid organizational skills, performs detailed tasks with high degree of accuracy, and performs under pressure.
  • Multitasks, prioritizes and manages time effectively.
  • Displays excellent communication and presentation skills and must possess exceptional ability to work well with individuals and teams at all levels, across all divisions.
  • Works in a structured environment and performs in high-pressure ad hoc mode to address urgent needs.
  • This position has a regular full time schedule with a normal work week of Monday through Friday. There may be a need for occasional work after hours or weekends.
  • This position may require minimal travel up to 10% of the time.




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




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


Drug Test Elements:

CPKC is committed to the safety and health of its employees and the general public.  All new hires are required to undergo a drug screen.  We appreciate your cooperation in keeping CPKC safe and drug free. 


Background Investigation:

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


  • Criminal history check
  • Reference check
  • Education verification
  • Driver’s License Verification
  • Last 3 years of driving history
  • Last 7 years of employment history; includes military service
  • 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.


CPKC is an equal opportunity/affirmative action employer, inclusive of protected veterans and individuals with disabilities. 






With Job Requisition Fields

  • Req ID: 102977
  • Department: Strategic Planning
  • Job Type: Full-Time
  • Position Type: Non-Union
  • Location: Kansas City, Missouri
  • Country: United States
  • % of Travel: 0-10%
  • # of Positions: 2
  • Job Grade: 4
  • Compensation Rate:

Job Available to: Internal & External

Nearest Major Market: Kansas City

Apply now »