CASY-MSCCN Jobs

At CN, everyday brings new and exciting challenges. You can expect an interesting environment where you’re part of making sure our business is running optimally and safely―helping keep the economy on track. We provide the kind of paid training and opportunities 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, safety-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, and failure trends, and other metrics, you will be a key member of a dedicated team of railroaders working to improve the reliability of locomotives and rolling stock. This 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 / Machine Vision teams, and Senior Mechanical Leaders. The ideal candidate has a passion for analyzing data and creating powerful reports and Tableau/Power BI dashboards that help bring ideas to life.

Main Responsibilities

· Identify trends, performance, safety, and productivity opportunities by applying data science techniques

· Design, develop, and implement ETL processes to extract data from various sources, including databases, 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

· Develop, maintain and analyze performance metrics and reports that support data-driven decision-making processes.

· Set alert thresholds by defect and fleet

· Collaborate with internal and external teams to identify improvement opportunities

· Communicate and present findings to teams and management at all levels

· Drive the collection of new data and the refinement of existing data resources

· Validate existing data sources by performing quality and audit checks

· Analyze and interpret the results from analytical tools and explain the meaning to the appropriate management levels

· Develop best practices for instrumentation and experimentation while communicating to team members

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%).

Requirements

Experience

Data Analytics

· Minimum 3 years of experience in data analytics tools including:

o SQL, Tableau, Power BI, SAP Bex, Excel

· Provide a minimum of 3 portfolio samples of dashboards or reports, PDF format or web link is preferred*

· Machine Learning and Computer Vision Experience*

· Minimum 3 years of experience including*:

o Databricks

o Azure Data Factory

o Similar advanced pipeline and analytics tools such as Informatica Claire, Palantir Foundry

o Familiarity with ETL - Extract Transform Load processes

*Any experience for these above would be considered as an asset

Education/Certification/Designation

· Bachelor’s of Science Degree in either Statistics, Mathematics, Data Science or Engineering, or equivalent experience.

Competencies

· Collaborates with key internal stakeholders to enable higher productivity

· Shares timely information within and across functions to get things done effectively

· Builds and maintains an internal network to support a better overall work experience

· Influences by translating expertise into practical business outcomes

· Is agile in responding to the rapid evolution of the industry and of technology

· Deals with pressure and change by staying calm to quickly adapt to changes

· Addresses risks in a timely manner to eliminate them

Technical Skills/Knowledge

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

· Construct and manage Structured Query Language (SQL) queries required for analysis

· Experience with Apache Spark and its integration with Databricks.

· Use visualization tools such as Tableau and Power BI

· Work independently on small projects

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.

CN is an Equal Employment Opportunity Employer. It is our policy to fill vacant positions with qualified candidates without regard to race, color, sex, religion, national origin, age, or disability, assuming an individual can perform the essential functions of the job with or without accommodation. Only qualified candidates under consideration will be contacted. Please monitor your email on a regular basis, as communication is primarily made through email.