Senior Specialist Data Analytics

Canadian National Inc.; Homewood (IL); On-site; USD 88,000 - 115,000; Full time

Benefits offered by this job

Annual bonus

ESIP

Pension

Railroad Retirement Benefits (RRB)

Other perks

Job summary

Canadian National Inc. is seeking a data analytics professional to collaborate with the Mechanical team, bringing operational data to life by analyzing thresholds, detector readings, and trends to improve locomotive and rolling stock reliability.

You will work with the Mechanical Reliability team, OEMs, and cross-functional groups to drive data-driven improvements. The role emphasizes data management, ETL development, and reporting, with opportunities to contribute to advanced analytics, ML, and

Qualifications

• Minimum 3 years of experience with data analytics tools (SQL, Tableau, Power BI, Excel, SAP).
• Experience with ML and Computer Vision is a plus.
• Experience with Databricks, Azure Data Factory, Informatica Claire, Palantir Foundry, and ETL is preferred.

Responsibilities

• Design, develop, and implement ETL processes to gather data from databases, APIs, and flat files.
• Load transformed data into data warehouses, data lakes, or other storage solutions.
• Apply data cleaning, transformation, and enrichment for analysis and reporting.
• Identify trends and opportunities; set alert thresholds by defect and fleet.
• Develop metrics and reports to support data-driven decisions; present findings to management.

Skills

Data Analytics

Data Visualization

ETL

SQL

Excel

Education

Bachelor's in Statistics/Math/Data Science/Engineering

Tools

Tableau

Power BI

Python

Pandas

SAP

Databricks

Azure Data Factory

Informatica Claire

Palantir Foundry

Job description

Please note that the language you select on this site will be the primary language used for all future communications regarding your application.

Hiring Salary Range: $88000 - 115000

This range represents the hiring range. Salaries are determined individually depending on skills and experience. You will also be eligible to an annual bonus, employee share investment program (ESIP), Pension, Benefits, Railroad Retirement Benefits (RRB) and other perks.

At CN, we are committed to our pursuit of excellence. We take pride in delivering work of the highest standard, continually innovating to shape the railroad of the future. As responsible railroaders, we make the right decisions every time, putting safety first, acting with unwavering integrity, and holding ourselves accountable for our actions. We believe in succeeding together-by fostering inclusivity and collaboration, we sustainably deliver exceptional results for our customers.

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

• We Care About Each Other
• We Strive for Excellence
• We Succeed Together
• 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

Additional Information (If Any)

About CN

CN is a premium railroad that sustainably generates value for our customers, shareholders, employees, and stakeholders with an unwavering commitment to safety and service. Essential to the economy, to the customers, and to the communities it serves, CN safely transports more than 300 million tons of natural resources, manufactured products, and finished goods throughout North America every year. CN's network connects Canada's Eastern and Western coasts with the U.S. South through an 18,800-mile rail network. CN and its affiliates have been contributing to community prosperity and sustainable trade since 1919. CN powers the North American economy and is committed to programs supporting social responsibility and environmental stewardship.

At CN, we are dedicated to building North America's safest, most inclusive and sustainable railroad, which includes reflecting the communities in which we operate. Research shows that candidates often don't apply unless they feel they fit the job posting at 100%. To all potential applicants, even if you don't meet every job requirement listed in a posting, we still encourage you to apply. If you require an accommodation for the recruitment process (including alternate formats of materials, accessible meeting rooms or other accommodations), please get in touch with our team at [e-mail].

As an equal opportunity employer, qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, and other protected status as required by applicable law.

Please monitor your email on a regular basis as communication to applicants is done via email