Sql data analyst Jobs in Oakville, ON

Job Description

What is the Opportunity?

The Actuarial Analyst will be responsible for the delivery of the RBC Insurance Economic and Regulatory Capital reporting including a number of the supporting components. This role also has accountabilities for building new Capital models, improving capital modeling methodologies, as well as maintaining and updating existing Capital models.

The Actuarial Analyst will be mainly responsible for the delivery of the RBC Insurance Economic Capital reporting on quarterly basis. The role also assists in the regulatory capital reporting such as Life Insurance Capital Adequacy Test (LICAT) and Financial Condition Testing (FCT).

What will you do?

• Support the quarter-end reporting for Economic Capital for RBC Insurance. This usually include model runs, model recalibrations, model improvements, data processing, and analysis of results.

• Support the identification, development, and implementation of enhancements to existing capital forecast methodologies and frameworks.

• Maintain Economic Capital model methodology documentations and model change procedures.

• Assist in LICAT forecasting, explaining quarterly movements and filing of LICAT results with OSFI before deadlines.

• Support ad-hoc projects and activities as required (mainly on IFRS 17 LICAT model change, other ad-hoc requests include methodology improvements, committee reporting, etc.)

• Assist with other RBC Insurance risk capital functionalities as needed, which may include Enterprise Wide Stress Testing (EWST) for insurance divisions, ORSA sensitivity test, and other ad-hoc stress testing.

What do you need to succeed?

• Strong analytical and communication skills for carrying out accountabilities

• Strong technical skills in GGY AXIS, R, MS Excel and MS Access (SQL)

• 1 year of related actuarial work experience

• Solid understanding of actuarial principles, practices, and modeling logics for valuation and capital projections

• Excellent problem solving skills for identifying and recommending enhancements to existing frameworks and methodologies

• Knowledge of life insurance standards of practice, capital regime, reserving principles, insurance accounting, product design and administration, and pricing framework

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 include competitive compensation and flexible benefits.

• 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.

• Opportunities to build close relationships with clients.

You have the potential to earn more through RBC’s discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided the business meets its performance targets and you meet your individual goals.

RBC’s compensation philosophy and principles recognize the importance of a highly qualified global workforce and plays a critical role in attracting, engaging and retaining talent that:

• Drives RBC’s high-performance culture

• Enables collective achievement of our strategic goals

• Generates sustainable shareholder returns and above market shareholder value

#LI – POST

Job Skills

Actuarial Modeling, Capital Adequacy, Economic Capital, Insurance Finance and Actuarial Concepts, Multi-Level Communication, Risk Analysis Management, Risk Assessments, Stress Testing

Additional Job Details

Address:

MEADOWVALE BUSINESS PARK, 6880 FINANCIAL DR:MISSISSAUGA

City:

Mississauga

Country:

Canada

Work hours/week:

37.5

Employment Type:

Full time

Platform:

GROUP RISK MANAGEMENT

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

2026-06-16

Application Deadline:

2026-09-05

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

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.