Senior Data Scientist, Predictive Analytics & Dashboards

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

Job summary

CPKC is seeking a Sr Data Analyst/Data Modeler to design and implement data-driven models, build scalable data pipelines on cloud platforms, and deliver executive dashboards. The role requires extensive SQL expertise, data governance, and collaboration with cross-functional teams to translate business needs into analytics for decision-making.

The position focuses on applying statistical methods to rail operations data, developing predictive insights, and presenting findings to executive

Qualifications

• 5 years of experience writing, optimizing, and troubleshooting advanced SQL queries.
• 5 years of experience building robust data pipelines and ETL processes to integrate disparate railroad data sources.
• 5 years documenting SQL queries, logic, data workflows, and analytics results for stakeholders.
• 5 years collaborating with cross-functional teams to gather requirements and deliver SQL-based solutions.
• 4 years applying statistical analysis (e.g., regression, time-series) to rail operations data.
• 3 years developing executive dashboards using Power BI or Qlik.
• 3 years rail transportation operations knowledge.

Responsibilities

• Design and implement data-driven models to support decision-making for business leadership.
• Develop data pipelines and data processing workflows on cloud platforms to enable scalable analytics.
• Create dashboards and visualizations for executives using Power BI or Tableau.
• Ensure data quality, governance, and compliance with data standards and regulations.
• Collaborate with stakeholders to translate business requirements into analytics and models.
• Present analytical findings and recommendations to executives and cross-functional teams.

Skills

Advanced SQL

Data modeling

ETL pipelines

Data visualization

Statistical analysis

Cross-functional collaboration

Education

Bachelor's degree (CS/IS/CE)

Tools

Power BI

Tableau

Qlik

Snowflake

AWS

Job description

CPKC is seeking a Sr Data Analyst/Data Modeler to design and implement data-driven models, build scalable data pipelines on cloud platforms, and deliver executive dashboards. The role requires extensive SQL expertise, data governance, and collaboration with cross-functional teams to translate business needs into analytics for decision-making.

The position focuses on applying statistical methods to rail operations data, developing predictive insights, and presenting findings to executive