Data Analyst- EN

At CN , everyday brings new and exciting challenges . Y ou can expect a n interesting environment where you’re part of making sure our business is running opti mally and safely ― helping keep the economy on track . W e provide the kind of paid training and opportunit ies that long-term careers are built on and we recognize hard workers who strive to make a difference. You will be able to thrive in our close-knit, safe ty-focused culture working together as ONE TEAM . The careers we offer are meaningful because the work we do matters. Join us!

Job Summary

The Data Analyst 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 in order 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 team s 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. Due to the nature of the role, the incumbent must be able to meet tight deadlines, handle pressure and stress. The role requires minimal travel (10%) within Canada and the United States (U.S.).

Requirements

Requirements Experience

Data Analytics

• Minimum 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
• Any experience for these above would be considered as an asset
  
  

Education/Certification/Designation

• Bachelor’s Degree in Statistics, Mathematics, Data Science, Engineering, or equivalent experience
  
  

Competencies

• Collaborates with others and shares information
• Knows the business and stays current on industry needs
• Applies critical thinking
• Demonstrates agility and drives change
• Identifies potential safety and security risks
  
  

Technical Skills/Knowledge

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

About CN

CN is a world-class transportation leader and trade-enabler. 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. As the only railroad connecting Canada’s Eastern and Western coasts with the Southern tip of the U.S. through a 19,500 mile rail network, CN and its affiliates have been contributing to community prosperity and sustainable trade since 1919. CN is committed to programs supporting social responsibility and environmental stewardship. At CN, we work as ONE TEAM, focused on safety, sustainability and our customers, providing operational and supply chain excellence to deliver results.

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 from underrepresented groups often don’t apply unless they feel they fit the job posting at 100%. Even if you don’t see yourself in 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 reach out to our team at [email protected].

As an equal employment opportunity employer, all qualified applicants 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. We thank all applicants for their interest, however, only candidates under consideration will be contacted. Please monitor your email on a regular basis, as communication is primarily made through email.