Senior Data Analytics Engineer for Mechanical Reliability

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

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.