Associate / Senior Data Analyst, Business Intelligence & Data Reporting

Job Description

What is the opportunity?

The Capital Markets Data Services team is seeking an Associate / Senior Data Analyst to join our Data Reporting function. Data Services ensures Capital Markets data is complete, accurate, and fit-for-purpose to meet business and regulatory requirements.

In this role, you will be the critical link between data and decision-making. You'll be responsible for designing and maintaining dashboards, analyzing complex datasets, and translating business requirements into actionable insights that drive strategic decision-making across the organization. You'll design, deliver, and optimize business intelligence solutions to meet business and operational stakeholder requirements, as well as measure data quality health, identify improvement opportunities, and provide executives with actionable insights to drive strategic priorities. This position offers high visibility with leadership and the opportunity to shape how our organization measures and optimizes its data.

What will you do?

Collaborate with stakeholders across Front Office, Operations, Finance, Risk, Technology etc. to understand requirements, propose suggestions based on Capital Markets knowledge and expertise, and deliver integrated solutions

Design, build, and maintain executive dashboards and visualizations in Tableau to provide key business and operational insights and to track data quality metrics, inclusive of materiality measures

Transform complex data patterns into compelling narratives and strategic recommendations that influence decision-making for leadership

Perform analysis on large datasets to identify trends, anomalies, and root causes of data quality issues, translating findings into risk mitigation strategies and operational improvements

Conduct data discovery and profiling to identify appropriate data sources for reporting purposes and write SQL queries to extract and transform data

Apply statistical methods and analytical frameworks to benchmark performance and forecast trends

Build end-to-end reporting solutions including data extraction, transformation, modeling, and visualization using SQL, Tableau, and ETL best practices

Optimize existing reports and data pipelines for performance, accuracy, and scalability

Establish and maintain metadata management practices

Lead forums with senior stakeholders to present insights, gather requirements, and ensure alignment between reporting solutions and business priorities

Create professional presentations and documentation that effectively communicate complex data scenarios to both technical and non-technical audiences

Stay current with industry best practices in business intelligence, data visualization, and performance management

Recommend and implement process enhancements to improve reporting efficiency and data governance maturity

Contribute to bank-wide data initiatives and strategic planning efforts

What do you need to succeed?

Must-have :

Degree in Finance, Economics, Computer Science, Statistics, Data Science, Engineering, Mathematics, or related field

5+ years of relevant experience in business intelligence, operations, data analysis, or financial services

Advanced proficiency in Tableau for dashboard development and data storytelling

Strong SQL programming skills for complex queries, data extraction, and analysis of large datasets

Proven experience with ETL processes and data modeling techniques

Strong quantitative and problem-solving skills with ability to analyze large data volumes and synthesize insights

Experience applying data visualization principles and dashboard design best practices

Ability to translate business requirements into technical specifications and reporting solutions

Solid understanding of data governance principles, data quality frameworks, and metadata management

Excellent stakeholder management and communication skills, with experience presenting to leadership

Strong attention to detail with ability to manage multiple priorities and deliver under deadlines

Proficiency in Microsoft Excel for data manipulation and PowerPoint for executive presentations

Nice-to-have :

Experience with Python for advanced analytics and automation

Knowledge of Capital Markets products, trading lifecycles, or market / reference data

Familiarity with data science methodologies (machine learning, pattern recognition)

Background in business intelligence, consulting, strategic planning, or process improvement initiatives

Experience with data governance tools or enterprise data management platforms

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.

A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable

Leaders who support your development through coaching and managing opportunities

Ability to make a difference and lasting impact

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

Opportunities to do challenging work

#LI-KA2

Job Skills

Big Data, Business Intelligence (BI), Business Requirements Gathering, Dashboard Development, Dashboard Management, Data Analysis, Data Discovery, Data Governance, Data Mining, Data Modeling, Data Quality, Data Quality Management, Data Reporting, Data Visualization, Detail-Oriented, Metadata Management, Python (Programming Language), Stakeholder Management, Strategic Thinking, Structured Query Language (SQL), Tableau Desktop, Tableau Server, Visualizations

Additional Job Details

Address :

90 WESTERN PKY : BEDFORD

City : Bedford

Country : Canada

Work hours / week : 37.5

Employment Type : Full time

Platform : CAPITAL MARKETS

Job Type : Regular

Pay Type : Salaried

Posted Date : 2026-02-09

Application Deadline :

2026-02-25

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

I nclusion 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 .

RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.