Analyst, Analytics Engineer

RBC•Toronto, ON

3d•Onsite

About The Position

This is an opportunity to join the Global Procurement & Supplier Management Product & Data Team, where you will work alongside experienced data, reporting and insights professionals while supporting the organization’s evolving data and reporting needs. As an Analytics Engineer, you will support data processes, reporting solutions, dashboards and analytical requests. You will gain practical experience with ETL processes, data extracts, report generation, data quality, business intelligence and ad hoc analysis within a large, matrixed organization.

Requirements

Foundational experience or education in data analytics, business intelligence, reporting, data management, computer science, information systems or a related field.
Experience using Microsoft Excel and foundational knowledge of SQL to organize, analyze, validate and retrieve data.
Exposure to a programming language such as Python, Java or C#
Exposure to a business intelligence or data-visualization tool such as Tableau, Power BI, or a similar platform.
Strong analytical, problem-solving, communication and organizational skills, with close attention to detail and a willingness to learn.

Nice To Haves

Up to three years of experience in data analytics, reporting, data operations, business analysis, or a related area.
Hands on experience with Python or another scripting language used for data analysis, automation, or data processing.
Familiarity with ETL processes, relational databases, data warehouses, or scheduled data workflows.
Experience developing reports, dashboards, data extracts, or automated reporting solutions using large datasets.

Responsibilities

Support the execution, monitoring and maintenance of scheduled ETL processes and data workflows, including investigating data or process issues.
Extract, transform, validate and reconcile data from multiple source systems to support accurate and reliable reporting.
Produce recurring and ad hoc data extracts, reports and analytical outputs based on business requirements.
Develop, enhance and maintain dashboards and data visualizations using tools such as Tableau, Power BI and Excel.
Collaborate with business partners, analysts and data engineers to understand requirements, automate manual processes and improve data and reporting solutions.

Benefits

bonuses
flexible benefits
competitive compensation
commissions
stock where applicable
Leaders who support your development through coaching and managing opportunities
Ability to make a difference and lasting impact
A world-class training program in financial services
Flexible work/life balance options
Opportunities to do challenging work
Opportunities to take on progressively greater accountabilities