to design, implement, and maintain logical and physical data models that support business intelligence, analytics, and operational data solutions. You will play a critical role in shaping how data is structured, accessed, and maintained across the organization.
Your primary responsibility will be to build scalable and efficient data models that align with business requirements, utilizing both traditional relational modeling techniques and modern data architecture practices.
What will you do?
Design and develop
relational
,
dimensional
, and
NoSQL data models
for enterprise-wide applications and analytics.
Collaborate with business analysts, data engineers, and software developers to translate business requirements into optimal data structures.
Define and enforce data modeling standards and naming conventions.
Create and maintain
conceptual
,
logical
, and
physical data models
.
Ensure data models are optimized for performance, scalability, and security.
Evaluate and integrate
modern data modeling tools
and frameworks.
Participate in data governance initiatives, including data lineage, data cataloging, and metadata management.
Support database administrators and data engineers in implementing and maintaining physical databases based on models.
Review and optimize existing data models for evolving business and technical needs.
What do you need to succeed?
Must-have:
Bachelor's or Master's degree in Computer Science, Information Systems, or related field.
Proven experience as a
Data Modeller
or
Data Architect
, ideally in a mid-to-large scale enterprise environment.
Deep knowledge of
relational database design
and
normalization/denormalization
techniques.
Proficiency in
SQL
and relational databases such as PostgreSQL, SQL Server, MySQL, or Oracle.
Experience designing data models for
data warehouses
,
data lakes
, and
analytics platforms
.
Strong understanding of
dimensional modeling
(e.g., star schema, snowflake schema).
Familiarity with
data modeling tools
, such as:
+
Erwin Data Modeler
+
IBM InfoSphere Data Architect
+
SAP PowerDesigner
+
dbt (data build tool)
for modern data stack modeling
+
SQLDBM
+
Lucidchart
or
Draw.io
(for lightweight modeling and collaboration) Knowledge of
cloud-based data platforms
, such as Snowflake, BigQuery, Redshift, or Azure Synapse Analytics.
Understanding of
metadata management
and
data governance
best practices.
Ability to communicate complex data concepts to both technical and non-technical audiences.
Nice to have:
Experience with
data modeling in agile environments
.
Familiarity with
Data Vault 2.0
,
anchor modeling
, or other modern modeling techniques.
Exposure to
NoSQL
data models (e.g., MongoDB, Cassandra).
Hands-on experience with
CI/CD pipelines
for data infrastructure.
Certification in data modeling or cloud data services (e.g., Snowflake, AWS Data Analytics, Google Cloud).
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.
Ability to make a difference and lasting impact
Work in a dynamic, collaborative, progressive, and high-performing team
Opportunities to do challenging work
Job Skills
Critical Thinking, Data Administration, Database Structures, Data Modeling, Data Movement, Detail-Oriented, Group Problem Solving, Information Capture, Standard Operating Procedure (SOP), Teamwork
Additional Job Details
Address:
RBC WATERPARK PLACE, 88 QUEENS QUAY W:TORONTO
City:
Toronto
Country:
Canada
Work hours/week:
37.5
Employment Type:
Full time
Platform:
PERSONAL & COMMERCIAL BANKING
Job Type:
Contract (Fixed Term)
Pay Type:
Salaried
Posted Date:
2025-09-19
Application Deadline:
2025-10-04
Note
Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
I
nclusion
and Equal Opportunity Employment
At 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.
Join our Talent Community
Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.
Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at jobs.rbc.com.
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.