Associate & Senior Data Analyst, Business Intelligence & Data Reporting

RBC; Bedford; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading bank in Canada is looking for an Associate / Senior Data Analyst to join their Capital Markets Data Services team in Bedford. This role involves designing and maintaining dashboards, analyzing complex datasets, and translating business requirements into actionable insights. Candidates should have at least 5 years of experience in business intelligence and strong skills in SQL and Tableau. If you're looking to shape data practices and drive strategic decision-making, this is an exceptional opportunity.

Benefits

Competitive compensation

Flexible benefits

Bonuses and stock options

Qualifications

• 5+ years of relevant experience in business intelligence, operations, data analysis, or financial services.
• Strong SQL programming skills for complex queries and data extraction.
• Advanced proficiency in Tableau for dashboard development.

Responsibilities

• Collaborate with stakeholders to understand requirements and deliver integrated solutions.
• Design, build, and maintain executive dashboards and visualizations in Tableau.
• Transform complex data patterns into compelling narratives for leadership.

Skills

Business Intelligence (BI)

Data Analysis

SQL

Tableau

Python

Data Governance

Data Visualization

Detail-Oriented

Education

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

Tools

Tableau Desktop

SQL

Job description

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 modelling 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

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

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.