Associate & Senior Data Analyst, Business Intelligence & Data Reporting

RBC; Halifax; On-site; CAD 60,000 - 80,000; Full time

Job summary

A leading bank is seeking an Associate / Senior Data Analyst in Halifax. This role involves designing dashboards, analyzing complex datasets, and providing insights for strategic decision-making. The ideal candidate will have over 5 years of experience in business intelligence, strong SQL skills, and advanced proficiency in Tableau. Join a dynamic team, contribute to data governance initiatives, and optimize reporting solutions to enhance organizational performance.

Benefits

Competitive compensation

Total Rewards Program

Opportunities for development

Qualifications

• 5+ years of relevant experience in business intelligence or financial services.
• Strong SQL programming skills.
• Advanced proficiency in Tableau for dashboard development.

Responsibilities

• Collaborate with stakeholders to deliver integrated solutions.
• Design and maintain dashboards and visualizations in Tableau.
• Analyze large datasets to identify trends and improve data quality.

Skills

Tableau

SQL

Data Analysis

Business Intelligence

Data Governance

Problem-Solving

Education

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

Tools

Python

ETL

Job description

Job Description

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

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.

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.