Job DescriptionWhat will you do?- Design and build analytics solutions: Uncover product requirements and translate them into end-to-end analytics solutions, data models, transformations, semantic layers, and consumption patterns. Own quality and maintainability.
- Solve technical and analytical problems: Navigate complex data scenarios. Find elegant solutions to tricky modeling challenges. Make trade-offs and move forward.
- Enable self-service analytics: Design semantic models and data contracts that let analysts and data scientists independently use trusted data. Reduce friction, eliminate bottlenecks.
- Collaborate effectively: Work with data engineers, governance experts, analysts, data scientists, product teams and internal business users . Understand their needs. Communicate constraints and possibilities clearly. Establish ownership and accountability of data to reduce ambiguity and clarify decision making.
- Set technical standards: Establish how semantic models are built, documented, and consumed. Champion best practices for dimensional design, metric governance, and data quality. Your work becomes the template for how the organization thinks about metrics and analytics.. Mentor on best practices, advocate for consistency and quality.
- Team Leadership: Lead a team of analysts in creating data product solutions which may include the creation of reporting using Tableau
What do you need to succeed?Must-Have:- Semantic layer expertise is non-negotiable: 5-10 years with analytics platforms with deep hands-on experience in semantic layers (dbt, Cube.js, Looker Semantic Layer, or similar). You have proven experience in building solutions that drive decisions. You understand dimensional data modeling, data contracts and how to make metrics consistent and discoverable . You know what works at scale, what creates debt
- Hands-on modern data stack experience: You've worked with dbt (or another transformation tool), cloud data warehouses (Snowflake, Databricks, BigQuery), and semantic layer concepts (dbt, Cube.js, Looker, etc.). You understand how these pieces fit together.
- Outcome-focused problem solver: You think about impact, not output. You're comfortable with ambiguity and make sound decisions with incomplete information. You iterate and move forward. You care about code quality, maintainability, and how others will use what you build.
- Clear communicator: You explain trade-offs honestly. You write documentation people want to read. You speak across technical and business audiences without jargon.
- Meticulous about craft: You care about code quality, maintainability, and how others will use what you build.
Nice to have:- Financial services or regulated industry experience
- Hands-on experience with Gen AI for code generation, documentation, and problem-solving
- Experience evolving analytics infrastructure or modernizing BI platforms
- Strong foundation in data modeling and dimensional design
- Track record collaborating across business domains
What's In 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 take on progressively greater accountabilities.
- Access to a variety of job opportunities across business and geographies.
#LI-POST
#TECHPJ
Job SkillsBig Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Quality Management, Requirements Analysis, Waterfall Model
Additional Job DetailsAddress:MEADOWVALE BUSINESS PARK, 6880 FINANCIAL DR:MISSISSAUGA
City:Mississauga
Country:Canada
Work hours/week:37.5
Employment Type:Full time
Platform:INSURANCE
Job Type:Regular
Pay Type:Salaried
Posted Date:2026-05-04
Application Deadline:2026-07-31
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 RangeThe expected pay range for this position is:
$105,000.00 - $155,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.
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.
