Find work in Canada.

327,586 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added just now
Référent en Sécurité - SA Software Sécurité et Conformité
Ericsson
Montreal, QC · Quebec, QC
Full-time
À propos de l'opportunité Au sein de l'unité Platform Engineering & Flow (PEF) de BCSS Core Networks Engineering, à Montréal, nous lançons un nouveau rôle de Security Champion pour diriger…
Added 1 hour ago
Agentic AI Lead
RBC
Toronto, ON
Full-time
We are seeking an experienced Agentic AI Lead/Solutions Architect to drive artificial intelligence and machine learning initiatives across RBC GAM. This role requires a strategic leader who…
Added 3 hours ago
DevOps Manager
Rightsline Inc
Toronto, ON
$85,000 to $95,000 CAD / year
…infrastructure our product runs on. You will report to the Senior DevOps Architect and partner closely with Engineering, QA, Security and Compliance, and…
Added 3 hours ago
Senior Data Modeler
OMERS
Toronto, ON · Head Office Toronto
Full-time
This role reports into the Director, Architecture and is important because it will help shape the data architecture and technical foundation supporting critical business solutions. In this…
Added 4 hours ago
Architecte de solutions PLM/PLM Solution Architect
Capgemini Engineering
Montreal, QC
Full-time
At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world’s most innovative companies…
Added 4 hours ago
Cloud Network Engineer
FNZ Group
Toronto, ON · CA Toronto Yonge St
$120,000 to $150,000 CAD / year
Full-time
…of network design principles and a demonstrated ability to architect scalable, secure, and resilient network solutions that exceed business needs. Your role in FNZ will be to act as a…
Added 5 hours ago
Java Developer Lead Analyst - Vice President
Citi
Mississauga, ON
Full-time
Embed risk awareness into engineering decisions, ensuring solutions meet compliance requirements and uphold Citi's standards for data integrity and regulatory adherence.
Added 5 hours ago
Java Developer Lead Analyst - Vice President
Citi
Mississauga, ON
Full-time
Embed risk awareness into engineering decisions, ensuring solutions meet compliance requirements and uphold Citi's standards for data integrity and regulatory adherence.
Added 9 hours ago
Sr. Back-End Java Developer, TD Securities
TD
Toronto, ON
Full-time
TD Securities is a leading North American investment bank and financial services provider that offers advisory and capital market services to corporate, government, and institutional…
Added 9 hours ago
Java Technology Lead Analyst - Vice President
Citi
Mississauga, ON
Full-time
Embed risk awareness into engineering decisions, ensuring solutions meet compliance requirements and uphold Citi's standards for data integrity and regulatory adherence.
Added 11 hours ago
Senior Cloud Solutions Architect (Hybrid)
Mara Consulting
Halifax, NS
Full-time
To support our growth, we are searching for an experienced Senior Cloud Solutions Architect to join our team. As part of a growing and well-respected team, you’ll work with clients in the…
Added 12 hours ago
Senior Data Solutions Architect (Hybrid)
Mara Consulting
Halifax, NS
Full-time
To support our growth, we are searching for an experienced Senior Data Solutions Architect to join our team. As part of a growing and well-respected team, you'll work with clients in the…
Added 1 day ago
Solution Architect
Aviso
Toronto, ON
$150,000 to $168,000 CAD / year
Full-time
Reporting to the Director, Technical Delivery and Architecture, the Solution Architect is responsible for developing and delivering technology architecture and design strategies and…
Added 2 days ago
Power Platform & Copilot Studio Architect
Softchoice
Calgary, AB · AB · NS · Oakville, ON · Ottawa, ON · Toronto, ON · Nova Scotia, Nova
Architect hybrid solutions that marry low-code and custom development: Copilot Studio and Power Automate as the orchestration or experience layer over custom Azure services (Functions,…
Added 2 days ago
Software Developer, Metadata
RBC
Calgary, AB
Full-time
…opportunity to work on challenging problems at the intersection of data management and the financial services industry. As a Software Engineer, you’ll be responsible for architecting,…
Added 2 days ago
Senior Full-Stack Developer
St. Joseph Communications
Toronto, ON
$100,000 to $120,000 CAD / year
Our engineering team is seeking a Senior Full-Stack Developer to play a key role in the engineering function for our Media organization. In this role you will be responsible for maintaining…
Added 3 days ago
Senior Consultant - GCP Cloud Infrastructure Architect
Deloitte
Toronto, ON
Full-time
The focus and passion of Deloitte's Cloud Engineering practice is to help our clients become a place where their employees are passionate about the work they do, and can dramatically…
Added 3 days ago
Senior Consultant - GCP Data & AI Architect
Deloitte
Toronto, ON
Full-time
The focus and passion of Deloitte's Cloud Engineering practice is to help our clients become a place where their employees are passionate about the work they do, and can dramatically…
Added 3 days ago
Senior Consultant - GCP Agent Platform Architect
Deloitte
Toronto, ON
Full-time
…they deliver value. We are a specialized capability within our technology consulting practice in Canada, focused on the technical, organizational, and cultural elements that must be…
Added 3 days ago
Lead Engineer
Raymond James Ltd.
Vancouver, BC
Full-time
The Lead Engineer is the senior technical engineering lead within Digital Workplace & Platform, responsible for improving the stability, resilience, automation, control effectiveness, and…
Added 3 days ago
Senior/Principal Enterprise Architect (Level 18 & Level 19) - EN 425
Export Development Canada | Exportation et développement Canada
Remote, Canada
Full-time · Remote
Enterprise Architecture (EA) is a compact but highly influential team within the Digital and Technology Solutions (DTS) group that provides critical strategic and tactical services to and…
Added 3 days ago
Solution Integration Architect
Plan Group Inc.
Vaughan, ON
Full-time
Plan Group is a leader in delivering Smart Building Technology in both Commercial Real Estate and in Smart Hospitals and we are looking to grow our ICAT team. Our focus, to connect the…
Added 3 days ago
Senior Full Stack Developer – Inventory Management, Vice President
Citi
Mississauga, ON
Full-time
The Senior Full Stack Developer will join the Inventory Management Applications team within the Capital Markets technology organization. This role will lead the design and delivery of…
Added 3 days ago
Solution Architect
BMO
Toronto, ON · SCC
Full-time
The SOS organization serves as the face of technology for internal users across the bank, supporting critical capabilities including IT Service Management (ITSM), Service Desk operations,…
Added 3 days ago
Architecte de solutions PLM/PLM Solution Architect
Capgemini
Montreal, QC
At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world’s most innovative companies…

OMERS

Senior Data Modeler

Toronto, ON, Canada
Head Office Toronto, Canada

Pay: This posting is for an existing vacancy.The expected salary range for this position is $86,000.00 - $130,000.00 per year.
Job type: Full-time
Posting language: English
Posted: Sep 28, 2026

Apply About employer

Applications open in a new tab.

Original job description

Choose a workplace that empowers your impact.

Join a global workplace where employees thrive. One that embraces diversity of thought, expertise and experience. A place where you can personalize your employee journey to be - and deliver - your best.

We are a purpose-driven, dynamic and sustainable pension plan. An industry leading global investor with teams in Toronto to London, New York, Singapore, Sydney and other major cities across North America and Europe. We embody the values of our 665,000 members, placing their best interests at the heart of everything we do.

Join us to accelerate your growth & development, prioritize wellness, build connections, and support the communities where we live and work.

Don’t just work anywhere - come build tomorrow together with us.

Know someone at OMERS or Oxford Properties? Great! If you're referred, have them submit your name through Workday first. Then, watch for a unique link in your email to apply.

Sr. Data Modeler

The OMERS Products and Technology team is seeking a self-motivated and highly experienced Senior Data Modeler to join the Pension Architecture team. The team is responsible for modernizing OMERS’ core pension administration system and related applications, while also providing architectural oversight for the organization’s analytics data platform and associated integrations.

This role reports into the Director, Architecture and is important because it will help shape the data architecture and technical foundation supporting critical business solutions. In this role, you will help design and maintain scalable, secure, and reliable data solutions for large, service-oriented applications. You will apply your expertise in data solution engineering, data modeling, and data architecture to ensure that solutions align with business needs, corporate standards, industry best practices, and security requirements.

You will create and maintain a range of technical designs and architectural artifacts, including data flows, logical and physical data models, application information models, data migration designs, deployment models, and related documentation. You will collaborate closely with business, engineering, DevOps, infrastructure, and security leaders throughout the development lifecycle to ensure solutions are fit for purpose and adhere to established technical and architectural standards.

This is an excellent opportunity for a hands-on professional who is passionate about technology, continuous learning, and delivering meaningful solutions. You will be a key contributor to an engaged, high-performing team that values collaboration, people development, and long-term growth. At OMERS, you will be part of a culture committed to innovation, building trusted relationships, anticipating stakeholder needs, and creating lasting value for our members and customers.

You will be responsible for:

Lead data modeling and architecture activities supporting OMERS’ legacy and modern pension administration systems, including systems with more than 2,000 tables and Employer and Member portal applications.
Define and maintain data architecture standards, frameworks, and principles covering data modeling, metadata, security, master data, reference data, naming conventions, data types, and data quality.
Design and maintain logical and physical data models for new initiatives and system enhancements, from initial requirements through executable DDL generation and implementation.
Design data flows, migration strategies, source-to-target mappings, and data transformations that preserve data integrity and support successful system implementations.
Provide expertise and guidance on data classification, data security, data masking, data encryption, metadata management, data governance, and data quality.
Act as a trusted data subject matter expert during requirements engineering, architecture reviews, working groups, and cross-functional project discussions.
Develop and publish data architecture diagrams, models, technical documentation, and related artifacts for review by business stakeholders, Security, Enterprise Architecture, Product, Development, and DevOps teams.
Establish and maintain data definitions for database objects and contribute to a shared Data Dictionary and broader metadata management practices.
Support multiple project teams by coordinating schema changes across development and testing environments and partnering with DevOps teams to plan and implement changes in production.

Required Skills & Experience

7 or more years of overall information technology experience, including at least 3 years of hands-on experience as a Data Architect, Data Modeler, or in a closely related role.
Demonstrated experience designing data solutions for complex enterprise applications, including relational databases and large-scale transactional or operational systems.
Strong experience developing logical and physical data models, database designs, data flows, data migration designs, and source-to-target mappings.
At least 3 years of experience using a data architecture or data modeling tool such as SAP PowerDesigner, ER/Studio, erwin Data Modeler, or a comparable platform.
At least 5 years of experience working with the Oracle database platform, preferably Oracle 19c or later, and related development and administration tools.
Strong hands-on data modeling experience with Oracle, PostgreSQL, Microsoft SQL Server, Azure SQL Database, or similar relational database platforms.
Proven experience with database development and design tools, such as Oracle SQL Developer, SQL Navigator, Quest Toad, or comparable tools.
Strong analytical experience with database programming languages, including Oracle PL/SQL, Microsoft T-SQL, PostgreSQL PL/pgSQL, or similar.
Strong understanding of data integrations, conversions, migrations, transformations, and data integrity controls.
Demonstrated knowledge of metadata management, data governance, data quality, data dictionaries, data classification, and related data management practices.
Excellent analytical, investigative, problem-solving, and quantitative skills, with a strong attention to detail and quality.
Ability to understand and translate complex business rules, processes, calculations, and system requirements into effective data solutions.

Preferred Skills & Experience

A university degree, preferably a master’s degree, in Computer Science, Information Systems, Engineering, or a related discipline.
Experience designing data solutions in the defined benefit pension industry, financial services, insurance, or another highly regulated environment.
Knowledge of Master Data Management, reference data management, data science, artificial intelligence, and machine learning concepts.
Experience supporting actuarial, benefits administration, financial calculation, or other systems involving complex mathematical formulas and business rules.
Experience with database schema deployment processes, DevOps practices, and promoting database changes across development, testing, and production environments.
Experience providing coaching, mentoring, or technical leadership to junior data professionals.

This posting is for an existing vacancy.The expected salary range for this position is $86,000.00 - $130,000.00 per year.

You may also be eligible to receive an annual Incentive Award pursuant to our Short-term Incentive plan and our Long-Term Incentive plan (if applicable), and to participate in our group benefits and retirement plans – details on these elements of compensation are included within OMERS & Oxford offer letters.

As one of Canada’s largest defined benefit pension plans, our people-first culture is at its best when our workforce reflects the communities where we live and work - and the members we proudly serve.

From hire to retire, we are an equal opportunity employer committed to an inclusive, barrier-free recruitment and selection process that extends all the way through your employee experience. This sense of belonging and connection is cultivated up, down and across our global organization thanks to our vast network of Employee Resource Groups with executive leader sponsorship, our Purpose@Work committee and employee recognition programs.

Artificial intelligence (AI) tools are used to support certain stages of the OMERS recruitment process. While AI assists us in our process, human judgment and decision-making remain central to our candidate experience.

Apply About employer

More about this job

Responsibilities

The Senior Data Modeler will lead data modeling and architecture activities to modernize pension administration systems and define data standards. They will design logical and physical data models, manage data flows, and provide expertise on data governance and security.

Requirements

Candidates must have at least 7 years of IT experience, including 3 years in data architecture or modeling roles. Proficiency with Oracle databases and data modeling tools like SAP PowerDesigner or erwin is required.

Skills

Data modeling
Data architecture
Oracle
SQL
PL/SQL
Metadata management
Data governance
Data quality
Database design
Data migration
Source-to-target mapping
Enterprise applications
Data security
Technical documentation
DevOps
Pension administration

Benefits

Short-term incentive plan
Long-term incentive plan
Group benefits
Retirement plans

Visa sponsorship

Not detected in the job text

Keywords

Data Modeler
Data Architecture
Pension Plan
Oracle 19c
PostgreSQL
Microsoft SQL Server
Azure SQL Database
SAP PowerDesigner
ER/Studio
erwin Data Modeler
Oracle SQL Developer
Quest Toad
Data Governance
Metadata Management
Data Integrity
Data Masking
Data Encryption
Master Data Management
DevOps
Pension Administration
Financial Services
Logical Data Modeling
Physical Data Modeling
DDL
Service-oriented Architecture
Data Flows
Data Migration
Technical Design
Information Systems
Database Programming

Report this job