Data Architect/Modeller - Senior

Job Title: Data Architect/Modeller - Senior
Project: INSITE Data Modeler & Data/Information Architect FY26/27
Location: Toronto, Ontario
Work Model: Hybrid
Duration: 9 Months
Extension: 1 Extension
Submission Deadline: 2026-07-14, 12:00 p.m. EST

Supplier Comments / MSP Notes

Must Haves

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

• Continue data prototyping to validate Conceptual Data Model (CDM) recommendations.
• Refine and enhance the Logical Data Model (LDM).
• Support MECP's Data Migration Strategy and Plan.
• Assist with Alpha phase prototyping and proofs of concept.
• Support development of enterprise architecture artefacts for Architecture Review Board (ARB) submission and Architecture Gate Point 1 (AGP1).

Project Background

The Environmental Monitoring and Reporting Branch (EMRB) of the Ministry of Environment, Conservation and Parks (MECP) manages province-wide environmental monitoring and modelling initiatives covering:

• Air
• Water
• Terrestrial conditions
• Environmental sampling
• Data collection
• Analytics
• Open data reporting

Current systems are aging, fragmented, and no longer meet modern business or OPS standards.

The INSITE modernization initiative aims to replace legacy systems with a modern platform utilizing:

• Microsoft Fabric
• Databricks Lakehouse
• Java
• Angular
• ESRI GIS
• Modern analytics and reporting tools

Current Project Phase

The project has completed:

• Pre-Discovery
• Discovery

Current focus areas include:

Alpha / Infrastructure Build

• Technology provisioning
• Databricks platform setup
• Microsoft Fabric setup
• Architecture documentation
• Logical Data Model refinement
• Information Architecture Document (IAD)

Beta / Live

• Agile delivery model
• 4-Month Sprint Cycles
• 6-Sprint Releases
• Integration and modernization of environmental monitoring systems

Responsibilities

Data Architecture

• Develop and implement enterprise data architecture.
• Define enterprise data flow and distribution.
• Determine database locations and access patterns.
• Align information architecture with enterprise strategy.
• Define common business vocabularies and data standards.

Data Modelling

• Continue validating and refining existing conceptual and logical data models.
• Support Logical Data Model evolution.
• Support enterprise information architecture activities.
• Ensure adherence to modelling and normalization standards.

Data Migration

• Develop and support migration strategies.
• Create migration plans and data mapping approaches.
• Analyze legacy datasets and migration requirements.

Architecture Governance

• Develop enterprise architecture artefacts.
• Support Architecture Review Board submissions.
• Contribute to Information Architecture Documents (IAD).
• Support AGP1 architecture gate reviews.

Alpha Phase Activities

• Data prototyping.
• Proofs of concept.
• Validation of architecture recommendations.
• Collaboration with DBA and infrastructure teams.

Experience & Skill Set Requirements

Mandatory Skills 50%

Information Architecture & Data Modelling

• Information resource management tools and techniques.
• Information architecture definition and governance.
• Enterprise information architecture reviews and assessments.
• Data modelling and normalization standards.
• Metadata repositories and data dictionaries.

Data Architecture Tools

Experience with:

• ERWIN
• PowerDesigner
• Visio
• CASE Tools

Technical Expertise

• Experience across multiple:
  • Platforms
  • Operating systems
  • Database technologies
  • Programming languages
  • Communication protocols
• Database performance design considerations.
• Structured design and development methodologies.
• Large and medium-scale systems analysis and design.

Architecture Deliverables

• Enterprise architecture models.
• Architecture documentation.
• Governance submissions.

Data Model Deliverables

• Continue data prototyping for CDM validation.
• Refine Logical Data Models.
• Support Data Migration Planning.
• Assist with Alpha proofs of concept.
• Support Architecture Gate Point (AGP1) deliverables.

Desirable Skills 30%

• Information Management principles and practices.
• AODA standards and accessibility awareness.
• Middleware and gateway integration.
• Automated data distribution mechanisms.
• Object-Oriented Analysis & Design.
• Data integration standards.
• Dimensional and relational modelling.
• Data quality and architecture reviews.

Communication & Soft Skills 15%

• Strong verbal communication.
• Strong written communication.
• Presentation and facilitation skills.
• Relationship-building capabilities.
• Leadership and collaboration skills.
• Attention to detail.
• Ability to work under tight deadlines.
• Project rescue and triage experience considered an asset.

Public Sector Experience 5%

• Ontario Government experience.
• Public Sector experience.
• Ontario Design System awareness.
• Ontario Government Enterprise Architecture processes.
• Enterprise Architecture deliverables and governance processes.

Technology Environment

Data & Analytics

• Microsoft Fabric
• Databricks Lakehouse
• Enterprise Data Models
• Data Migration
• Data Integration

Application Technology

• Java
• Angular

GIS

• ESRI

Architecture & Modelling Tools

• ERWIN
• PowerDesigner
• Visio
• CASE Tools