Data Modeler & Data/Information Architect FY26/27

Job Description

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.

Requirements
Mandatory Skills & Experience Cloud & Infrastructure Engineering Proven experience designing, deploying, and maintaining hybrid infrastructure environments across: Microsoft Azure Amazon Web Services (AWS) Linux-based environments SaaS solutions COTS solutions On-premises systems Strong experience with Windows and Linux server administration including: CentOS Ubuntu CoreOS Experience supporting modern web technology stacks including: LAMP MEAN Drupal Elasticsearch Experience with virtualization platforms, storage solutions, networking, and enterprise infrastructure services. Strong understanding of cloud architecture frameworks, technology assessments, and cloud solution strategies. Identity & Access Management Experience managing and supporting identity and access controls using: Active Directory Microsoft Entra ID Enterprise IAM solutions Experience implementing authentication, authorization, and access governance controls. DevOps & CI/CD Automation Strong experience designing, building, and administering CI/CD pipelines for continuous integration and deployment. Experience with development and collaboration tools including: Azure DevOps JIRA Confluence Maven Jenkins Experience with Infrastructure as Code (IaC) and version-controlled deployments. Strong knowledge of DevOps methodologies, automation frameworks, and release management best practices. Experience with containerization and orchestration technologies including: Docker Kubernetes AKS / EKS Experience automating operational and compliance-related activities using: PowerShell Bash Python Programming & Scripting Hands-on experience with scripting and programming languages including: Python Bash PHP Java JavaScript Node.js Experience with build and configuration management tools including: Git Ansible Chef Puppet API & Integration Experience Experience building and consuming APIs and integration endpoints. Experience integrating cloud platforms, enterprise systems, and deployment pipelines. Understanding of enterprise integration architectures and service-based deployments. Security, Monitoring & Compliance Strong understanding of infrastructure security, cloud security, and DevOps security best practices including: Least privilege access Secure logging Secrets management Vulnerability remediation Experience with security and monitoring tools including: Radware Dynatrace Splunk Azure Monitor / Log Analytics AWS CloudTrail / CloudWatch ELK Stack / SIEM solutions Experience implementing centralized audit logging and monitoring across enterprise platforms. Ability to support internal and external audits through reporting, evidence gathering, and log analysis. Experience supporting forensic investigations, audit remediation, and incident reviews. Familiarity with Government of Ontario I&IT Directives, Policies, and Information Technology Standards. Release Management & Operational Support Experience coordinating infrastructure and application releases across technical and business teams. Knowledge of change management processes, deployment approvals, rollback planning, and release governance. Experience with release readiness reviews, deployment validation, and post-release monitoring. Ability to maintain release documentation, operational records, and audit artifacts. Project Management & Communication Strong project planning, coordination, and resource management skills. Experience with roadmap planning, modernization initiatives, and infrastructure investment planning. Strong stakeholder communication and cross-functional collaboration skills. Ability to explain complex technical concepts to business users, leadership teams, and non-technical stakeholders. Strong documentation, reporting, presentation, and technical writing skills. Mobile Device Management Experience supporting mobile device management for cellular devices and tablets across multiple platforms and operating systems. Desirable Skills Experience supporting Government of Ontario enterprise environments. Experience with enterprise modernization and cloud transformation initiatives. Familiarity with enterprise governance, compliance frameworks, and audit readiness programs. Experience mentoring and coaching junior DevOps and infrastructure resources. Strong understanding of operational resilience, disaster recovery, and enterprise monitoring strategies. Additional Information Strong hands-on DevOps, cloud infrastructure, automation, CI/CD, security, and enterprise release management experience is mandatory for this role.