Power BI Developer

RBC • Mississauga, ON

4d • Onsite

About The Position

Design, develop and maintain Power BI dashboards to monitor asset and liability performance, compliance metrics, risk analytics, and performance attribution. Enable dynamic functionality to drill down into detail views by asset classes, region, sector, ratings etc. Develop dashboard to track changes in regulatory capital (capital charge by asset class, duration, etc.). Work with data engineers and IT teams to ensure clean, well structured, and timely data flows. Maintain documentation on data sources, calculations, and assumptions used in Power BI reports. Partner with product, finance, actuaries, risk management teams to understand evolving data needs. Automate reporting process and reduce reliance on excel based workflows. Ensure consistency and version control of published dashboards. Help design presentations (alongside the primary portfolio manager) to tell the story of investment and ALM actions. Use data and graphical tools to support business cases for growth.

Requirements

• Minimal bachelor’s degree in computer science, quantitative mathematics or related fields with working knowledge on insurance asset and liability management.
• 3+ years of working experience in data visualization with a focus on Power BI or equivalent.
• Proficiency in developing data pipelines and standardizing procedures for accuracy and efficiency.
• Solid understanding on various asset classes (bonds, equities, linear and nonlinear derivatives, structured products), capital requirements, and portfolio level analytics.
• Passionate to solve technical problems and flexible to adapt to changes in a dynamic working environment.
• Excellent communication skills and ability to collaborate across investment, risk and other functional partners.

Nice To Haves

• Experience with Insurance company data and reporting process.
• Knowledge of large-scale data warehouses such as Snowflake would be an Asset.

Responsibilities

• Design, develop and maintain Power BI dashboards to monitor asset and liability performance, compliance metrics, risk analytics, and performance attribution.
• Enable dynamic functionality to drill down into detail views by asset classes, region, sector, ratings etc.
• Develop dashboard to track changes in regulatory capital (capital charge by asset class, duration, etc.)
• Work with data engineers and IT teams to ensure clean, well structured, and timely data flows.
• Maintain documentation on data sources, calculations, and assumptions used in Power BI reports.
• Partner with product, finance, actuaries, risk management teams to understand evolving data needs.
• Automate reporting process and reduce reliance on excel based workflows.
• Ensure consistency and version control of published dashboards.
• Help design presentations (alongside the primary portfolio manager) to tell the story of investment and ALM actions.
• Use data and graphical tools to support business cases for growth.

Benefits

• bonuses
• flexible benefits
• competitive compensation
• Leaders who support your development through coaching and managing opportunities
• Opportunities to take on progressively greater accountabilities
• Access to a variety of job opportunities across business and geographies

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees