Enable job alerts via email!

Expert, Data Analysis

Canadian National Railway Company

Montreal

On-site

CAD 80,000 - 100,000

Full time

3 days ago
Be an early applicant

Boost your interview chances

Create a job specific, tailored resume for higher success rate.

Job summary

A leading transportation company is seeking an Expert in Data Analysis to enhance data-driven decisions. This role involves managing large datasets, creating visualizations, and collaborating with internal stakeholders to drive operational efficiency. Ideal candidates will have extensive experience in data analysis and visualization tools, and a strong educational background in relevant fields.

Qualifications

  • Minimum 10 years overall work experience.
  • Minimum 5-7 years experience in a technical expert role.

Responsibilities

  • Conduct detailed analysis and provide advanced analytics solutions.
  • Create visualizations to aid in understanding data.
  • Develop and optimize Tableau and Power BI reports.

Skills

Data Analysis
Data Management
Communication
Problem Solving

Education

Bachelor’s Degree in Business Administration
Bachelor’s Degree in Computer Sciences
Bachelor’s Degree in Software Engineering
Bachelor’s Degree in Statistics

Tools

Tableau
Power BI
SQL
Microsoft Office

Job description

At CN, we work together to move our company—and North America—forward. Be part of our Information & Technology (I&T) team, a critical piece of the engine that keeps us in motion. From enterprise architecture to operational technology, our teams use the agile methodology to automate and digitize our railroad ensuring our operations run optimally and safely and our employees can focus on value-added tasks. You will be able to develop your skills and career 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 Expert, Data Analysis is responsible for conducting detailed analysis and providing access to advanced analytics solutions to solve business problems, while leveraging statistical and optimization techniques. The role handles and governs large quantities of data from multiple data sources, including the ability to merge it and ensure its consistency. Moreover, the role encompasses the development and creation of visualization and analysis tools to be used by internal stakeholders. It involves seeking out and understanding new data sources, merging it with other sources, and modelling in order to provide a consumable format for analysis and presentation at an executive level. The incumbent contributes to enabling automation and supports better and faster data-driven decisions in virtually every aspect of its business.

Main Responsibilities

Data Management & Analytics

· Find and interpret rich data sources, merge and ensure consistency of datasets

· Handle large amounts of data despite hardware, software, and bandwidth constraints

· Query large datasets and link related factors to reveal performance, safety orcost-saving opportunities

· Analyze data, spot trends, and bring change to the organization

· Develop initiatives to assist the Financial Planning team in leveraging data to draw causal relationships between financial information and operating KPIs in the respective functions (Transportation, Engineering, Mechanical, etc.)

· Assist in understanding sensitivities, impacts of change, and draw insights on action items that can positively impact operations while being cognizant of ripple effects on other areas of the business.

· Use data science techniques to find data patterns, anomalies, and optimization opportunities

· Interpret, translate, and communicate analytical findings to business stakeholders

· Tackle and solve complex analytical problems using quantitative approaches

Data reporting and visualisation

· Create visualizations to aid in understanding data and build mathematical models

· Provide analytical support by creating and sharing regular and ad hoc reports as required in a format that can be easily consumed and interpreted by internal customers

· Develop and optimize Tableau and Power BI reports and applications to deliver simplified analytics to support insight development

Center of Expertise

· Stay abreast of market best practices

· Autonomously identify the best approach, process, and tools for the function

· Educate internal stakeholders on data visualization

Working Conditions

The role has standard working conditions in an office environment with a regular workweek from Monday to Friday. The role is eligible to participate in CN’s flexible work policy. Due to the nature of the role, the incumbent must be able to meet tight deadlines, handle pressure, and stress.

Requirements

Experience

Relational Databases and Modeling

· Minimum 10 years overall work experience

· Minimum 5-7 years experience in a technical expert role, with relational databases and modeling techniques and coding (e.g., Structured Query Language (SQL) Server)

· Experience developing dashboards and interactive analytical tools and visualizations

· Experience handling various types of data (unstructured, semi-structured and structured)

· Experience handling projects, (e.i.: scope and timeline), delivering results with an Agile approach

Education/Certification/Designation

· Bachelor’s Degree in Business Administration, Computer Sciences, Software Engineering, Statistics or equivalent degree and experience

· Demonstrates agility and drives change

· Knows the business and stays current on industry needs

· Communicates with impact

· Collaborates with others and shares information

· Demonstrates active listening

· Solves problems to create value

Technical Skills/Knowledge

· Expert-level skills and usage of Microsoft Office (Excel and Access), Tableau and Power BI

· Expansive knowledge of financial metrics, data, and business intelligence strategies

· Knowledge polyglot databases (SQL, NoSQL, Graph, Search, Time-Series)

· Knowledge of business intelligence (OLAP, cubes, Power BI, Tableau)

· Knowledge of programming languages (SQL, Python, R, Scala)

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.

FAQ
Check here for answers to your CN hiring questions.

Applying for a Job at CN
Does CN offer entry-level positions?

Yes, we have many positions ranging from entry to senior levels, both in the field and in corporate and IT functions. All available positions are posted onto our Careers website.

Does CN hire students, interns, and new graduates?

Yes, Internship opportunities are posted onto our Careers website, when available.

What's the best way to apply for a position at CN?

Search and apply for a job on our Careers website. Once you've created a profile you'll be able to apply for additional openings and view the status of your application(s). We do not accept resumes by email, fax or mail.

Can I apply for more than one job at the same time?

Yes, feel free to apply to any jobs you're qualified for.

What is the rehire process for former CN employees?

The application process for a former CN employee is the same as for all other candidates.

Does CN accept foreign applicants?

CN requires that applicants be legally eligible to work in Canada or the US. This includes Citizens, Permanent Residents, or anyone in possession of a work permit with certain conditions. At this time, CN does not provide immigration assistance to foreign applicants.

My Job Application
What is my application status?

To see your application status, go to our Careers website and login to your candidate profile. It may take some time before your status is updated, as we receive a high volume of applications on a daily basis. If you are being considered for a job, you will be contacted by a member of our Recruitment Team.

Can I withdraw an application?

Yes, if you change your mind about a particular job, you may withdraw your application at any time. If you've already received a job offer, you can simply decline it.

I completed an Online Assessment, what are my next steps?

The Recruitment Team will notify you by email whether or not you will be moving on to the next step of the recruitment process, based on your online assessment results. If successful, you will be invited to the next available recruitment session hosted in the location you have applied to. Keep in mind that it can take several weeks before a session becomes available.

I was unsuccessful with the online assessment - how long must I wait before I can re-apply?

You will have to wait a period of 6 months before you are eligible to re-apply to a position that requires the same testing.

I am having technical difficulties with the online assessment.

For online assessment troubleshooting and support please contact cnrecruitment@cn.ca .

I was not selected for a job and would like feedback on my application.

Due to the high number of applications we receive, we cannot provide feedback as to why each candidate was not progressed.

Using our career site
How do I create a Careers profile?

Click the Create a Profile button in the upper right-hand corner of our Careers website and complete the form and captcha.

Can I edit a previously submitted cover letters, resumes, and/or documents?

No, once an application has been submitted, you cannot upload additional documents, revise questions, nor replace the existing resume or letters attached to that application.

I forgot my password.

If you forgot your password or need to create a new one, click on the Forgot Password link. Enter your User Name or User ID, and an email containing your password will be sent to you. Be sure to check your inbox, spam, and junk folders for the password recovery email. If you do not receive the password recovery email within 24hrs, contact your Talent Acquisition Advisor directly or send an email to cnrecruitment@cn.ca .

For all other technical issues

If you are experiencing technical difficulties with our Careers website, send us an email at cnrecruitment@cn.ca describing the technical issue(s) in detail and provide us with screenshots so that we can better assist you.

Get your free, confidential resume review.
or drag and drop a PDF, DOC, DOCX, ODT, or PAGES file up to 5MB.

Similar jobs

Expert, Data Analysis

CN360

Montreal

On-site

CAD 80,000 - 110,000

Yesterday
Be an early applicant

Analyste Statistique Principal/Principal Statistical Analyst

IQVIA Argentina

Kirkland

Remote

CAD 70,000 - 110,000

14 days ago

Consultant(e) (recherche quantitative ou mixte centrée sur le patient) / Consultant (Quantitati[...]

IQVIA

Kirkland

On-site

CAD 80,000 - 110,000

12 days ago

Consultant(e) (recherche quantitative ou mixte centrée sur le patient) / Consultant (Quantitati[...]

IQVIA Argentina

Kirkland

On-site

CAD 80,000 - 120,000

14 days ago

Technical Sales Specialist II, Data Analytics, Google Cloud (French)

Google

Montreal

On-site

CAD 90,000 - 120,000

Today
Be an early applicant

Senior Consultant/Manager, Data, Analytics and Automation

KPMG LLP Canada

Montreal

On-site

CAD 70,000 - 90,000

Today
Be an early applicant

Manager, Data, Analytics and Automation-Snowflake

KPMG LLP Canada

Montreal

On-site

CAD 90,000 - 120,000

Today
Be an early applicant

Associate Operations Research Specialist/Spécialiste associé en recherche opérationnelle

UKG

Montreal

On-site

CAD 60,000 - 100,000

8 days ago

Associate Operations Research Specialist/Spécialiste associé en recherche opérationnelle

Ultimate Software

Montreal

On-site

CAD 60,000 - 100,000

11 days ago