Senior Data Scientist: Predictive Analytics & Pipelines

Canadian Pacific Kansas City; Kansas City (MO); On-site; USD 120,723 - 140,000; Full time

Job summary

Canadian Pacific Kansas City seeks a data analytics professional to design data models, build robust ETL pipelines, and deliver executive dashboards supporting strategic decisions. You will apply SQL, statistical methods, and cloud technologies (AWS, Snowflake) to analyze rail data, drive governance, and automate workflows in a collaborative, cross-functional environment.

The role emphasizes forecasting, data quality, and communicating insights to executive leadership to influence operational

Qualifications

• 5 years of professional SQL experience with complex joins, aggregations and performance tuning.
• 5 years building robust data pipelines and ETL processes for data integration.
• 5 years documenting SQL logic, data workflows and analytics results.
• 5 years collaborating with cross-functional teams to gather requirements and deliver SQL-based solutions.
• 4 years applying statistical analysis to rail operations data for insights.
• 3 years developing executive dashboards with Power BI or Qlik.

Responsibilities

• Design and implement data models and analytical data marts to support analytics and reporting.
• Develop and deliver dashboards and visualizations to communicate insights to stakeholders.
• Collaborate with business and IT teams to translate requirements into data-driven solutions.
• Establish data quality frameworks, lineage, and governance practices.
• Automate data processes and scale analytics solutions for increasing data volumes.
• Present findings and recommendations to executives to inform decisions.

Skills

SQL

Data modeling

ETL pipelines

Power BI

Statistical analysis

Time-series forecasting

Data governance

Python

Cloud platforms (AWS)

Snowflake

Education

Bachelor's degree

Tools

Snowflake

AWS

Job description

Canadian Pacific Kansas City seeks a data analytics professional to design data models, build robust ETL pipelines, and deliver executive dashboards supporting strategic decisions. You will apply SQL, statistical methods, and cloud technologies (AWS, Snowflake) to analyze rail data, drive governance, and automate workflows in a collaborative, cross-functional environment.

The role emphasizes forecasting, data quality, and communicating insights to executive leadership to influence operational