Data Modeler & Data/Information Architect FY26/27

Job Title: INSITE Data Modeler & Data/Information Architect (FY26/27)

Location: Toronto, ON (Hybrid – 3 days onsite at 40 St. Clair Ave. West / 125 Resources Road, Toronto, and 2 days remote within Ontario)

Contract Type: Ontario Government Contract

Job Description

Our Ontario Government client is seeking an experienced Data Modeler & Data/Information Architect to support the INSITE program. The successful candidate will be responsible for developing and implementing enterprise data architecture in a complex, distributed environment while supporting enterprise information management initiatives and government modernization projects.

The consultant will work closely with business and technical stakeholders to define enterprise information architecture, develop conceptual and logical data models, establish data standards, and support architecture governance activities. The role also includes contributing to enterprise architecture deliverables required for Architecture Review Board (ARB) submissions and Architecture Gate Point 1 (AGP1).

Key Responsibilities

• Develop and implement enterprise data architecture for complex, distributed applications.
• Design and maintain conceptual, logical, and physical data models.
• Define enterprise information architecture requirements and obtain stakeholder approval.
• Develop standard business vocabularies, metadata, and enterprise data standards.
• Design data flows, database distribution, and data access strategies.
• Review and enforce enterprise data modelling and normalization standards.
• Support enterprise architecture governance and Architecture Review Board (ARB) processes.
• Collaborate with business and technical teams to align data architecture with enterprise strategies.
• Produce architecture documentation, models, and governance artifacts.
• Provide technical guidance on enterprise information management best practices.

Project Deliverables

The consultant will build upon existing Conceptual and Logical Data Models and assist with:

• Continuing data prototyping to validate Conceptual Data Model (CDM) recommendations.
• Refining and enhancing the Logical Data Model (LDM).
• Supporting MECP in developing the Data Migration Strategy and Migration Plan.
• Assisting with Alpha prototypes and Proof of Concept (PoC) activities.
• Developing enterprise architecture artifacts for submission to the Architecture Review Board (ARB) for Architecture Gate Point 1 (AGP1) scheduled for Spring 2027.

Required Skills & Experience

Enterprise Information Architecture

• Enterprise Information Architecture
• Information Resource Management (IRM)
• Data Governance
• Metadata Management
• Enterprise Data Standards
• Data Dictionaries
• Information Architecture Reviews
• Business Vocabulary Management

Data Modelling

• Conceptual Data Modelling
• Logical Data Modelling
• Physical Data Modelling
• Relational Data Modelling
• Dimensional Data Modelling
• Data Normalization
• Metadata Repository Management

Data Modelling Tools

Experience with one or more of the following:

• ERwin Data Modeler
• PowerDesigner
• Microsoft Visio
• CASE Tools

Database Technologies

Experience working with multiple database platforms such as:

• Oracle
• SQL Server
• PostgreSQL
• DB2

Knowledge of:

• Database Design
• Database Performance Optimization
• Data Distribution
• Data Access Methods

Systems Analysis & Design

• Structured Systems Analysis and Design
• Enterprise Application Development
• Large-scale Distributed Systems
• Application Architecture

Enterprise Architecture

• Enterprise Architecture Deliverables
• Architecture Governance
• Architecture Review Board (ARB)
• Enterprise Modelling
• Architecture Documentation

Desired Qualifications

• Knowledge of Information Management principles and best practices.
• Experience with middleware and integration gateways.
• Experience designing automated data distribution mechanisms.
• Knowledge of Object-Oriented Analysis and Design (OOAD).
• Experience developing enterprise data standards and integration models.
• Experience reviewing conceptual, logical, and physical data models for quality and compliance.
• Strong understanding of relational and dimensional modelling techniques.
• Knowledge of Accessibility for Ontarians with Disabilities Act (AODA) and accessibility standards.

Public Sector Experience (Preferred)

• Previous experience working with Ontario Government or Public Sector organizations.
• Experience with Ontario Government Enterprise Architecture processes and governance.
• Experience developing architecture deliverables for Architecture Review Board (ARB) approvals.
• Familiarity with Ontario Design System.
• Experience supporting enterprise modernization and digital transformation initiatives.

Soft Skills

• Excellent verbal and written communication skills.
• Strong analytical and problem-solving abilities.
• Excellent stakeholder management and relationship-building skills.
• Strong presentation and documentation skills.
• Ability to manage multiple priorities and deliver under tight deadlines.
• Self-motivated team player with strong collaboration skills.
• High attention to detail and organizational skills.
• Project rescue/triage experience is considered an asset.

Work Arrangement

• Hybrid: 3 days onsite in Toronto and 2 days remote (within Ontario).
• Must be able to collaborate with business stakeholders, architects, developers, and project teams in an enterprise government environment.

This role is ideal for a senior Data Modeler/Data Architect with extensive experience in enterprise information architecture, data modelling, and public sector digital transformation, capable of delivering enterprise-grade data architecture solutions in support of Ontario Government modernization initiatives.