Senior Specialist Data Analytics

CN; Homewood (AL); On-site; USD 85,000 - 115,000; Full time

Job summary

CN is seeking a data analytics professional to collaborate with the Mechanical team and bring operational data to life. You will analyze alert thresholds, detector readings, and trends to improve locomotive reliability.

You will design ETL processes, load data into warehouses, and create reports to support data-driven decisions. Strong SQL, Tableau, Power BI, and SAP experience is essential.

Qualifications

• Minimum 3 years of experience with data analytics tools, including SQL, Tableau, Power BI, Excel and SAP.
• Experience with Databricks, Azure Data Factory, Informatica Claire, Palantir Foundry, and ETL is an asset.
• Candidates with an equivalent combination of education, training, and experience will be considered.

Responsibilities

• Design, develop, and implement ETL processes to gather data from databases, APIs, and flat files.
• Load transformed data into data warehouses or data lakes for accessibility and use.
• Apply data cleaning and enrichment to prepare data for analysis and reporting.
• Drive data collection and refine existing data resources.
• Validate data sources with quality and audit checks.
• Collaborate with internal and external teams to identify improvement opportunities.
• Identify trends and performance opportunities; develop metrics and reports for decision-making.
• Set alert thresholds by defect and fleet; interpret results for management.

Skills

SQL

Tableau

Power BI

Excel

Python

Pandas

Machine Learning

Computer Vision

Education

Bachelor's Degree in Statistics, Mathematics, Data Science, Engineering

Tools

Databricks

Azure Data Factory

Informatica Claire

Palantir Foundry

SAP

Job description

Job Summary

The incumbent is responsible for collaborating with various members of the Mechanical team to bring operational data to life. By analyzing alert thresholds, wayside detector readings, failure trends, and other metrics, the role improves the reliability of locomotives and rolling stock. The position contributes to the Mechanical Reliability team, which includes Car and Locomotive, Locomotive Subject Matter Expert (SME), Fleet leaders, Original Equipment Manufacturers (OEM), Wayside Detector and Machine Vision teams, and Senior Mechanical Leaders.

Main Responsibilities

Data Management

• Design, develop, and implement Extract, Transform, Load (ETL) processes to gather data from various sources, including databases, Application Programming Interfaces (APIs), and flat files
• Load transformed data into data warehouses, data lakes, or other storage solutions to ensure accessibility and usability
• Apply data cleaning, transformation, and enrichment techniques to prepare data for analysis and reporting
• Drive the collection of new data and the refinement of existing data resources
• Validate existing data sources by performing quality and audit checks
• Collaborate with internal and external teams to identify improvement opportunities

Analysis and Reporting

Identify trends, performance, safety, and productivity opportunities by applying data science techniques. Develop, maintain, and analyze performance metrics and reports that support data-driven decision-making processes. Set alert thresholds by defect and fleet. Analyze and interpret the results from analytical tools and explain the meaning to the appropriate management levels. Develop best practices for instrumentation and experimentation. Communicate and present findings to teams and management at all levels.

Working Conditions

The role has standard working conditions in an office environment with a regular workweek from Monday to Friday. The incumbent must be available to work night shifts and weekends when necessary. The role involves managing priorities and delivering work within established timelines, with support from the team to ensure sustainable and effective workload management. The role requires minimal travel (10%) within Canada and the United States (U.S.).

Requirements

Experience

Data AnalyticsMinimum 3 years of experience working with data analytics tools, including Structured Query Language (SQL), Tableau, Power BI, Excel and Systems, Applications, and Products (SAP)Machine Learning and Computer Vision Experience*Experience with Databricks, Azure Data Factory, Informatica Claire, Palantir Foundry, and ETL

• Candidates with an equivalent combination of education, training, and experience will be considered

Any requirement marked with (*) will be considered an asset (not mandatory).

Education/Certification/Designation

Bachelor's Degree in Statistics, Mathematics, Data Science, Engineering, or equivalent experienceCandidates with equivalent practical experience, education, or training will be considered

Competencies

• We Care About Each Other
• We Strive for Excellence
• We Succeed Together
• We Lead Responsibly
• Abstract reasoning skills
• AI Literacy and data orientation
• Think broadly
• Depth of analysis
• Business acumen

Technical Skills/Knowledge

Knowledge of one or more scripting languages including Python, Pandas, or equivalent to perform required research and analysis