Senior Data Analytics & Insights Specialist - Bonus Eligible

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

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