HEF Data Analyst (12-month Contract)

RBC; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading financial institution in Toronto is seeking a Data Analyst to enhance business intelligence through management reporting and automation solutions. The role involves collaborating with the HEF Business team and migrating coding from SAS to Python, as well as optimizing reports using Tableau. Candidates should have 2+ years of experience in data analytics within the Financial Services sector, with proficiency in SAS, SQL, and Python. This is a 12-month contract position with opportunities for impact and collaboration.

Benefits

Work in a dynamic team

Opportunities for challenging work

Ability to make a difference

Qualifications

• 2+ years of data analytics or data science experience in the Financial Services industry.
• Proficient technical skills in SAS, SQL, Python, Tableau.
• Strong collaboration and time management skills with high attention to detail.

Responsibilities

• Execute and maintain reports to ensure effective monitoring.
• Identify inefficiencies in reporting processes and develop automation solutions.
• Optimize existing reports in Tableau and PowerPoint.

Skills

Data Analytics

SAS

SQL

Python

Tableau

Collaboration

Time Management

Education

Bachelor's or Master's degree in a quantitative field

Tools

Data Lake

Trino

Job description

Job Summary

Job Description

Please note: This is a 12-month contract role to cover a parental leave.

What is the opportunity?

The Data Analyst role on HEF Analytics team will be responsible for management reporting and developing automation solutions for HEF Business team.

What will you do?

• Execute and maintain reports in with regular cadence to ensure effective monitoring

• Proactively identify inefficiency in the reporting process and responsible for automation solutions

• Act as key contributor for coding migration from SAS to Python and further automation using advanced tools through collaboration with Infrastructure team

• Optimize existing reports in Tableau and PowerPoint to tell stories using data. Collect feedbacks with various users to improve and meet their needs

• Develop code samples for the team and establish coding standard

What do you need to succeed?

Must have:

• 2+ years of data analytics or data science experience in the Financial Services industry, knowledge of credit products preferred

• Proficient technical skills in SAS, SQL, Python, Tableau

• Knowledge of data infrastructure and automation tools

• Strong collaboration and time management-skills with high attention to detail

• Effective written and verbal communication skills

• Intellectually curious, independent, growth mindset with bias for action

Nice to have:

• Technical skills: experience with Data Lake, Trino, etc.

• Understanding of the mortgage industry, including the financial drivers of the business

• Bachelors /Masters degree in a quantitative field is (e.g. Statistics, Computer Science, Business, Economics, Engineering, etc.)

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• Ability to make a difference and lasting impact

• Work in a dynamic, collaborative, progressive, and high-performing team

• Opportunities to do challenging work

Job Skills

Critical Thinking, Data Administration, Data Mining, Data Modeling, Data Movement, Detail-Oriented, Group Problem Solving, Quantitative Research, Research Documents

Additional Job Details

Address:

RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO

City:

TORONTO

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

PERSONAL & COMMERCIAL BANKING

Job Type:

Contract (Fixed Term)

Pay Type:

Salaried

Posted Date:

2025-07-29

Application Deadline:

2025-08-12

Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

Join our Talent Community

Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.