Senior Specialist, Data Science
Kansas City, MO - USA
Job Summary
Design develop and implement data-driven models and analytical frameworks to generate predictive insights and support strategic business decision-making; apply statistical methods data mining techniques and analytical tools to analyze large datasets and identify patterns trends and correlations; develop and optimize data pipelines and data processing workflows using cloud platforms (e.g. AWS) and data warehouse technologies (e.g. Snowflake) to support scalable analytics; perform predictive modeling scenario analysis and forecasting to evaluate business performance risks and opportunities; establish and maintain data quality frameworks validation processes and monitoring systems to ensure accuracy reliability and consistency of analytical outputs; design and implement data models including structured datasets and analytical data marts to support advanced analytics and reporting use cases; develop and deliver dashboards and data visualizations using tools such as Power BI or Tableau to communicate insights to stakeholders; collaborate with business and technical stakeholders to translate business requirements into data-driven solutions and analytical models; conduct root cause analysis of data and performance issues and implement data-driven solutions to improve system performance and business outcomes; evaluate and recommend advanced analytics tools technologies and methodologies to enhance data science capabilities; apply advanced SQL and programming techniques to extract manipulate and analyze data for modeling and reporting purposes; support data governance initiatives including data lineage metadata management and compliance with data standards and regulatory requirements; present analytical findings models and recommendations to stakeholders including executive leadership to support decision-making; drive continuous improvement through automation optimization of data processes and implementation of scalable analytics solutions. Salary: $120723 - $140000 per year.
MINIMUM REQUIREMENTS: Bachelors degree or its U.S. equivalent in Computer Science Information Systems Computer Engineering or a related field plus 5 years of professional experience as a Sr. Data Analyst Data Modeler or any occupation job title position involving data analysis data management and database design.
Must also have experience in the following: 5 years of professional experience writing optimizing and troubleshooting advanced SQL queries; including complex joins aggregations subqueries stored procedures functions and performance tuning in relational databases; 5 years of professional experience performing data manipulation automation and statistical analysis including building robust data pipelines and ETL processes to integrate disparate railroad data sources; 5 years of professional experience documenting SQL queries logic data workflows and analytics results for technical and non-technical stakeholders; 5 years of professional experience working with cross-functional teams (including business IT and finance) to gather requirements clarify business needs and deliver solutions strictly via SQL; 4 years of professional experience utilizing statistical analysis including regression analysis time-series forecasting applied to rail operations data to generate insights; 3 years of professional experience developing executive dashboards and interactive reports using tools including Power BI or Qlik to communicate operational insights and performance metrics effectively; 3 years of professional experience in rail transportation operations including knowledge of industry terminology and processes and applying this knowledge to support analysis and decision-making in a railroad environment.
CONTACT: Apply online at or submit resume via email to . Must specify Ad Code PSPT.
Required Experience:
Senior IC
About Company
With operations stretching from Vancouver to New York, Canadian Pacific Railway (CP) hauls freight over about a 15,000-mile network in Canada and the US. Its system includes about 10,700 miles of company-owned track and another 4,100 miles of track that is jointly owned, leased, or op ... View more