Associate Director - Lead Data Modeler/Analyst

ODAIA; Toronto; Hybrid; CAD 120,000 - 165,000; Full time

Benefits offered by this job

Total rewards program

Flexible work options

World-class training program

Job summary

RBC Capital Markets is seeking an Associate Director - Lead Data Modeler/Analyst to lead enterprise-grade data models across our cloud data lake. This senior role combines technical depth with business acumen, owning end-to-end data modeling strategy and guiding a team of data analysts.

You will bridge front-office stakeholders and backend engineering, delivering scalable, high‑quality data solutions in a fast-paced trading environment.

Qualifications

• Bachelor’s degree in computer science, software engineering, information systems, mathematics, or related field.
• 10+ years of progressive experience in data architecture, data modeling, and data strategy roles.
• 6+ years in capital markets with hands-on exposure to multiple asset classes and trading workflows.
• Demonstrated people management experience building high-performing teams.
• Ability to operate at a senior level, influencing executive stakeholders.
• Expert proficiency in data modeling (conceptual, logical, physical) for cloud-native data lakes.
• Hands-on experience with FIX connectivity and real-time data ingestion.
• Advanced SQL and Python for data analysis and transformation.
• Experience with ETL/ELT patterns and data pipeline orchestration.
• Experience using AI tools to speed up data analysis and modeling workflows.

Responsibilities

• Analyze cross-asset data from internal RBC systems and ISVs to understand lineage, relationships, and gaps.
• Design and implement standardized, scalable data models for a unified presentation layer by asset class.
• Engage early to conduct data gap analyses and identify quality issues before downstream impact.
• Define data contracts with upstream teams and track remediation for ongoing quality improvements.
• Collaborate with adjacent teams to diagnose and resolve data system issues across the trading data ecosystem.
• Leverage generative AI tools for data exploration, profiling, pattern detection, and prototype modeling.
• Coach and mentor direct reports to adopt AI-first workflows in analysis and modeling activities.
• Drive rapid proof-of-concept initiatives using cloud data lake resources to demonstrate value.
• Contribute to broader data strategy within the QTS division and influence platform architecture decisions.
• Engage with external stakeholders & ISVs to establish data connectivity and remediate data gaps.

Skills

Data Modeling

Data Architecture

SQL

Python

AI-driven data analysis

Stakeholder Management

Leadership

Cloud Data Lake

ETL/ELT

FIX Connectivity

Education

Bachelor’s degree in Computer Science / Software Engineering / Information Systems / Mathematics

Tools

Power BI

Tableau

Job description

Job Description

The Trading & Execution Services (TES) Data Services team within Capital Markets Technology has elevated data to first-class citizen status, providing strategic solutions for the capture, retention, analysis, and reporting of all transactional data spanning the Capital Markets cross-asset front-office trading lifecycle. Our team is responsible for ingesting and managing cross-asset trading data on our cloud data lake. We consolidate pre trade data from internal RBC trading execution systems and external Independent Software Vendors (ISVs) to deliver high-quality, standardized data products that power front office decision-making across all asset classes.

We are building a world-class data organization that leverages artificial intelligence and modern cloud-native architectures to transform how capital markets professionals access and consume data.

We are looking for a Associate Director - Lead Data Modeler/Analyst to lead the design and delivery of enterprise-grade data models across our cloud data lake. This is a senior leadership position that requires equal command of technical depth and business acumen. You will own the end-to-end data modeling strategy, build and manage a team of data analyst professionals, and serve as the connective tissue between front office stakeholders and backend engineering teams.

This role demands a self-driven leader who can operate independently, engage confidently with senior stakeholders, and deliver results at pace in a complex, multi-asset trading environment.

What will you do?

• Analyze cross-asset data from internal RBC systems and external ISV sources to understand data lineage, relationships, and gaps
• Design and implement standardized, scalable data models that serve as the foundation for a unified presentation layer organized by asset class and product
• Engage early in project lifecycles to conduct thorough data gap analysis and identify quality issues before they propagate downstream
• Partner with upstream source teams to define data contracts, track remediation efforts, and ensure sustained data quality improvements
• Liaise with adjacent teams to diagnose, adjust, and resolve data system issues across the trading data ecosystem
• Leverage generative AI tools and techniques as the primary methodology for data exploration, profiling, pattern detection, and model prototyping
• Coach and mentor direct reports to adopt AI-first workflows in their daily analysis and modeling activities
• Drive rapid proof-of-concepts using cloud data lake resources to demonstrate value and validate approaches for front office requirements
• Contribute to the broader data strategy for the QTS division and influence architectural decisions across the platform
• Liaise with external stakeholders & ISV to establish data connectivity with RBC for exchange of data & get sample data for analysis & work with them to remediate data gaps with respect to RBC requirements.

What do you need to succeed?

Must-have:

• Bachelor’s degree in computer science, Software Engineering, Information Systems, Mathematics, or related field
• 10+ years of progressive experience in data architecture, data modeling, and data strategy roles
• 6+ years working in capital markets with hands‑on exposure to multiple asset classes (equities, fixed income, derivatives, FX, commodities) & deep understanding of capital markets trading workflows, trade lifecycle, and market data structures
• Demonstrated people management experience with a track record of building and developing high‑performing teams
• Proven ability to operate at a senior level, influencing decisions and managing relationships with executive stakeholders
• Expert proficiency in data modeling methodologies (conceptual, logical, physical) and experience designing data architectures for cloud-native data lakes and lakehouses at enterprise scale
• Hands‑on experience with industry-standard communication protocols like FIX (Financial Information Exchange).
• Advanced SQL and Python skills for data analysis, profiling, and transformation
• Solid understanding of ETL/ELT patterns, data pipeline orchestration, and real-time data ingestion
• Working experience with using AI tools to speed up data analysis & us AI for productivity improvement in space of data analysis, modelling & mapping generation.

Nice-to-have:

• Familiarity with data from major financial ISVs and market data providers
• Demonstrated experience using AI/ML techniques for data analysis, data quality assessment, or automated model generation. Prior hands‑on use of generative AI tools (e.g., Copilot or similar) applied to data engineering or modeling workflows
• Knowledge of regulatory data requirements (MiFID II, CFTC, Dodd-Frank) and their impact on data architecture
• Experience with data visualization and BI tools (Power BI, Tableau) for building executive‑facing data products

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
• A world-class training program in financial services
• Flexible work/life balance options
• Opportunities to do challenging work

Job Skills

• Architectural Modeling
• Business Analysis
• Capital Markets (Trading)
• Critical Thinking
• Data Analysis
• Data Architecture Development
• Data Modeling
• Data Warehousing (DW)
• Enterprise IT Architecture
• ETL Processing
• FIX Connectivity
• Information Technology ConsultingLogical Data Modeling
• Multi-Level Communication
• People Management
• Physical Database Design
• Stakeholder Management

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: CAPITAL MARKETS

Job Type: Regular

Pay Type: Salaried

Posted Date: 2026-07-24

Application Deadline: 2026-10-03

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.