Senior Data Modeler, GFT

RBC; Toronto; On-site; CAD 120,000 - 170,000; Full time

Benefits offered by this job

Total rewards program

Coaching and development

Flexible work options

Challenging work

Job summary

RBC, based in Toronto, seeks a seasoned Data Modelling specialist to design standardized, scalable data models and maintain governance across Capital Markets, Retail Banking, Wealth Management, and more. You will partner with diverse teams to ensure accurate representation of financial products and robust metadata management.

The role demands strong communication, cross-functional collaboration, and the ability to drive data standard adoption in a high-velocity environment.

Qualifications

• Bachelor’s degree in computer science, software engineering, information systems, mathematics, or related field.
• 7+ years hands-on data modelling experience in a high-pressure financial sector.
• Expertise in data management and governance in data integration projects.
• Advanced SQL and Python skills for data analysis and transformation.
• Excellent communication and facilitation skills; able to work cross-functionally.
• Self-starter with strong time management and problem solving.

Responsibilities

• Understand detailed consumer requirements and research industry data standards.
• Design and implement standardized, scalable data models for a unified presentation layer.
• Model financial products to support stakeholders’ requirements across RBC lines of business.
• Produce and maintain high quality documentation and metadata.
• Lead internal reviews, ensure adherence to models and standards.
• Explain models and standards to consumers and data suppliers via walkthroughs.
• Interface with business areas and high-profile stakeholders to align initiatives with strategy.
• Identify required data sets and coordinate with upstream data suppliers and SMEs.
• Provide leadership to ensure adherence to published standards.

Skills

SQL

Python

Data Modelling

Communication

Time Management

Cross-functional Collaboration

Analytical Thinking

Education

Bachelor’s degree in Computer Science or related field

Tools

PowerDesigner

Erwin

Job description

What is the opportunity?

Are you a talented, creative, and results-driven professional who thrives on delivering high-performing applications? Come join us!

Job Description

What is the opportunity?

Are you a talented, creative, and results-driven professional who thrives on delivering high-performing applications? Come join us!

Global Functions Technology (GFT) is part of RBC’s Technology and Operations division. GFT’s impact is far-reaching as we collaborate with partners from across the company to deliver innovative and transformative IT solutions. Our clients represent Risk, Finance, HR, CAO, Audit, Legal, Compliance, Financial Crime, Capital Markets, Personal and Commercial Banking and Wealth Management. We also lead the development of digital tools and platforms to enhance collaboration.

The Finance IT Data Standards team manages data model standards that are used by several RBC Lines of Business, such as: Capital Markets, Retail Banking, Wealth Management, Insurance and Commercial Banking. These data standards support data storage/transfer to RBC back-office control functions, like Finance, Market Risk, Trading Credit Risk, Liquidity Risk and Enterprise Risk. In this role you will be responsible for ensuring that our model standards meet business requirements while supporting data scalability and reliability.

This position requires a lot of interpersonal interaction at all levels within the organization, from technical personnel to high level management, excellent communication skills are a must for this role.

What will you do?

• Understand in detail consumer requirements, research industry data standards for financial products and propose appropriate design/standards extensions to support such requirements.
• Design and implement standardized, scalable data models that serve as the foundation for a unified presentation layer organized by asset class and product
• Understand the various financial products in RBC and work with our partners to ensure they are represented/modelled correctly to support stakeholders’ requirements
• Produce and maintain high quality documentation and metadata required to support each model and standard published
• Strong teamwork mentality. Organize and conduct internal reviews of work/analysis done; the goal is to avoid overlap of work with other team members, knowledge share and guarantee adherence to existing models/standards/designs
• Demonstrate clear understanding of each model/standard and articulate the intent and vision via walkthroughs for consumer and data suppliers; the goal is to communicate updates and educate our partners on models and standards supported by the team
• Interface with business areas, including high profile stakeholders, to ensure all initiatives support business strategies and goals and provide recommendations for future state
• Help determine what data sets are required by back office control functions, determine what data sets are available from upstream data supplier, and work with SMEs in both groups to reach agreement on model or standard extensions.
• Provide leadership and direction to ensure adherence to published standards
• Apply extensive, in-depth knowledge, skills, and practices to perform complex assignments.

What do you need to succeed?

Must have:

• Bachelor’s degree in computer science, Software Engineering, Information Systems, Mathematics, or related field
• 7+ years hands-on data modelling experience (including data analysis and profiling) in high pressure environment in financial sector, preferably in Capital Markets
• Expertise in data management and governance in data integration projects involving Capital Markets trading platforms
• Advanced SQL and Python skills for data analysis, profiling, and transformation
• Excellent communication skills, including presentation and facilitation skills, are critical for this role
• Able to quickly and effectively gather, synthesize and drive resolution of modelling tasks in a cross-functional team environment
• Self-starter and ability to work with minimal supervision
• Detail oriented with strong problem solving skills with analytical mind and creative thinking
• Expert in time management and organizational skills with the ability to manage multiple projects with competing deadlines
• Experience in PowerDesigner or Erwin

Nice-to-have

• Knowledge in FSLDM (Financial Services Logical Data Model), FpML (Financial Product Markup Language) and Financial Regulatory Reports (Canada, US, UK)
• Knowledge of regulatory data requirements
• Understanding and experience in software development life-cycle
• Experience designing and building systems for extremely high traffic and transaction volumes, such as Data Lake / Hadoop / Databricks environment
• Demonstrate integrity and a constructive approach to challenges
• Lead, coach and mentor others while providing constructive feedback

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

Agile Methodology, Analytical Thinking, Artificial Intelligence Technologies, Business Analytics, Business Data Analysis, Business Needs, Business Process Modeling, Communication, Critical Thinking, Data Analysis, Data Modeling, Data Warehousing (DW), Decision Making, Design Thinking, Finance, Group Problem Solving, Interpersonal Relationship Management, Logical Data Modeling, Requirements Analysis, Teamwork

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

TECHNOLOGY AND OPERATIONS

Job Type

Regular

Pay Type

Salaried

Posted Date

2026-08-20

Application Deadline

2026-10-31

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.