Manager, Data Analytics at Royal Bank of Canada

Mississauga, Ontario, Canada -

Full Time

Start Date

Immediate

Expiry Date

31 Jul, 26

Salary

110000.0

Posted On

02 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data analytics, Power BI, SQL, Snowflake, Python, Financial modeling, Data modeling, DAX, Power Query, Time-series analysis, Investment analysis, Project leadership, Stakeholder management, Business intelligence, Forecasting

Industry

Financial Services

Description

Job Description What is the opportunity? RBC Insurance Investments is seeking a skilled Manager, Data Analytics, to help and scale our investment data and analytics capability. This role is suited for a well-rounded leader who can operate across the full analytics lifecycle – from raw data sourcing, transformation, and data modelling through to advanced visualization, business insights, and predictive analysis. The successful candidate will combine strong technical expertise with financial and business acumen. In addition to delivering robust datasets, dashboards, and analytical solutions, this individual will lead high-value analytical work that supports investment and balance sheet decision-making, including cash flow projections, and balance movement analysis. What will you do? End-to-End Analytics Leadership Lead the design and delivery of end-to-end analytics solutions, from raw data acquisition and transformation through to dashboarding, business insight generation, and user adoption. Translate complex business questions into scalable data, reporting, and analytical solutions. Ensure analytics outputs are accurate, well-governed, and aligned with business priorities. Build and Enhance Data Foundations Work with raw and curated data from multiple internal and external sources to create scalable, high-quality datasets for reporting and analysis. Write and optimize SQL queries in Snowflake and other cloud-based environments. Partner with data engineering and data squad teams to improve data pipelines, controls, and analytical data models. Identify opportunities to enhance data quality, reusability, and operational efficiency across the analytics stack. Deliver Investment Visualization Lead the design and implementation of high-impact Power BI dashboards for portfolio managers, actuaries, finance, risk, and senior leadership. Develop robust semantic models, DAX logic, and Power Query transformations to support flexible and trusted reporting. Present complex analysis in a clear, concise, and business-relevant manner for a range of audiences, including senior management. Drive Financial Analytics and Forecasting Lead analysis of investment and financial data, including positions, transactions, cash flows, balances, performance, and time-series data. Develop forecasting and modeling solutions to support business needs, including balance sheet analysis, inflow/outflow projection, and related decision-support analytics. Connect model outputs to business interpretation and strategic decision-making. Stakeholder Leadership and Business Partnership Partner with senior stakeholders across investment, actuarial, finance, risk, and product teams to identify opportunities where analytics can drive better decision-making. Influence adoption by ensuring solutions are intuitive, relevant, and aligned to stakeholder needs. Lead cross-functional delivery across business and technical teams, balancing strategic goals with execution realities. Team Leadership and Capability Building Help build a strong analytics culture grounded in curiosity, ownership, and practical problem-solving. What do you need to succeed? Must-have Bachelor’s degree in quantitative fields such as Finance, Mathematics, Statistics, Actuarial Science, Engineering, Computer Science, Economics, or related discipline. Master’s degree in a quantitative, financial, or analytical field is strongly preferred. 3+ years of relevant experience in analytics, business intelligence, quantitative analysis, data engineering, financial modeling, or a related field. Experience in investment, insurance, asset management, treasury, banking, or other financial services environments is strongly preferred. Demonstrated experience delivering end-to-end analytics solutions and working directly with senior business stakeholders. Experience leading projects, workstreams, or teams in a cross-functional environment. Advanced Power BI capabilities, including data modeling, DAX, report design, and Power Query. Strong SQL skills, ideally in Snowflake or similar cloud-based database platforms. Hands-on experience with Python for data analysis, automation, forecasting, or modeling. Strong understanding of structured financial data, time-series analysis, and large-scale datasets. Nice-to-have Experience in investment analytics, insurance investment, ALM, portfolio analytics, treasury analytics, or capital markets. Familiarity with Bloomberg, Reuters, or other market and financial data platforms. Exposure to cloud platforms and modern data ecosystems. Experience with machine learning or advanced analytics techniques is an asset. CFA, actuarial, data science, or analytics-related certifications are an asset. What’s in it for you? Whether it’s developing new skills, opportunities to innovate and grow, modern and comprehensive benefits, or the flexibility to enjoy the moments that matter, at RBC you have everything you need at your fingertips to build your career and life. Working with an award-winning team Awards | RBC Diversity & Inclusion A comprehensive Total Rewards package that prioritizes your overall wellbeing, including flexible and modern benefits, competitive compensation and stock options Work where you belong as part of a supportive, inclusive team and company that celebrate your unique perspectives, background and experience and want you to bring your whole self to work, every day. Leaders who are invested in your success and provide opportunities to learn, to grow and to try new things. Develop new skills, sharpen existing ones and explore paths you never knew existed with a host of learning programs and tools designed to support you in every phase of your career. An opportunity to have real impact on the lives of our clients and the communities you serve. RBCI software tools to boost your productivity Job Skills Big Data Management, Budgeting, Business Performance Management, Critical Thinking, Knowledge Organization, Long Term Planning, Performance Management (PM) Additional Job Details Address: RBC CENTRE, 155 WELLINGTON ST W:TORONTO City: Toronto Country: Canada Work hours/week: 37.5 Employment Type: Full time Platform: INSURANCE Job Type: Regular Pay Type: Salaried Posted Date: 2026-05-01 Application Deadline: 2026-05-15 Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above Compensation for this position (including salary and discretionary/variable payments) will be determined by factors, including but not limited to candidate's experience, skills, registration status, performance, individual goals, market conditions, and business needs. Pay Range The expected pay range for this position is: $67,000.00 - $110,000.00 The pay range provided is for the primary work location referenced in the Additional Job Details section of this job posting. Pay ranges may differ based on location. If the posting lists multiple job locations, a recruiter can confirm availability of the role and the relevant pay rage for the additional locations listed. RBC supports pay transparency and we strive to ensure all pay ranges are competitive, fair, and equitable. You have the potential to earn RBC's discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided that business meets its performance targets and you meet your individual goals. Our Employment Opportunities At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.

Responsibilities

Lead the design and delivery of end-to-end analytics solutions, including data sourcing, transformation, and visualization to support investment decision-making. Partner with senior stakeholders across finance, risk, and actuarial teams to drive business insights and operational efficiency.