Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The Trading & Execution Services (TES) Data Services team is seeking an Associate Director - Lead Data Modeler/Analyst to lead the design and delivery of enterprise-grade data models across their cloud data lake. This senior leadership position requires technical depth and business acumen, owning the end-to-end data modeling strategy, building and managing a team, and acting as a liaison between front office stakeholders and backend engineering teams. The role demands a self-driven leader capable of operating independently, engaging confidently with senior stakeholders, and delivering results in a complex, multi-asset trading environment.

Responsibilities

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 for a unified presentation layer organized by asset class and product.
Engage early in project lifecycles to conduct data gap analysis and identify quality issues.
Partner with upstream source teams to define data contracts, track remediation efforts, and ensure data quality improvements.
Liaise with adjacent teams to diagnose, adjust, and resolve data system issues.
Leverage generative AI tools and techniques for data exploration, profiling, pattern detection, and model prototyping.
Coach and mentor direct reports to adopt AI-first workflows.
Drive rapid proof-of-concepts using cloud data lake resources to demonstrate value and validate approaches.
Contribute to the broader data strategy for the QTS division and influence architectural decisions.
Liaise with external stakeholders & ISV to establish data connectivity, obtain sample data, and work with them to remediate data gaps.

Requirements

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 & use AI for productivity improvement in space of data analysis, modelling & mapping generation.
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.

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 Consulting
Logical Data Modeling
Multi-Level Communication
People Management
Physical Database Design
Stakeholder Management
SQL
Python
AI/ML
Generative AI

Location

Toronto, Canada

Work Type

Full time

Experience Level

Associate Director
10+ years of experience
6+ years in capital markets

Education Level

Bachelor’s degree in computer science, Software Engineering, Information Systems, Mathematics, or related field

Benefits

A comprehensive Total Rewards Program including bonuses and flexible benefits
Competitive compensation
Commissions
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

About the Company

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.