Senior Data Modeler, GFT

ODAIA; Toronto; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Total rewards program

Flexible benefits

Training & development opportunities

Career progression

Job summary

RBC's Global Functions Technology (GFT) seeks a seasoned data modeller to design scalable data models for a unified presentation layer across asset classes and products. You will partner with risk, finance, and operations teams to ensure models meet business needs while supporting data quality and governance.

In this role you will lead detailed data analysis, document standards, and guide cross-functional stakeholders through model concepts, ensuring alignment with RBC data strategies and

Qualifications

• Bachelor’s degree in Computer Science or related field.
• 7+ years data modelling experience in financial sector.
• Advanced SQL and Python for data analysis and transformation.
• Experience with data governance and data integration in Capital Markets.
• Strong communication and collaboration skills.

Responsibilities

• Design scalable data models for a unified presentation layer by asset class and product.
• Research industry data standards and map to RBC model extensions.
• Document metadata and model standards for governance and reuse.
• Lead internal reviews and knowledge sharing to avoid duplication.
• Engage with stakeholders to align data projects with business strategies.

Skills

Agile Methodology

Analytical Thinking

Data Modeling

Data Analysis

Teamwork

Education

Bachelor’s degree in Computer Science

Tools

PowerDesigner/Erwin

Job description

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?

• 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

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.