Description

Responsibilities

- Develops and implements the data architecture for application development in a complex and distributed setting, including the determination of the flow and distribution of data, the location of databases, and data access methods.

- Provides a standard common business vocabulary, expresses strategic data requirements, outlines high level integrated designs to meet these requirements, and aligns with the enterprise strategy and related business architecture.

General Skills

- Knowledge and experience in information resource management tools and techniques

- Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols

- Knowledge of performance considerations for different database designs in different environments

- Experience in structured methodologies for the design, development and implementation of applications

- Experience in systems analysis and design in large or medium systems environments

- Experience in the use of Computer Aided Software Engineering (CASE) tools for the development and documentation of data architectures and detailed data models

- Experience in the use of data modelling methods and tools (e.g. ERWIN, VISIO, PowerDesigner) including a working knowledge of metadata structures, repository functions, and data dictionaries

- Knowledge and experience in the use of information retrieval packages

- Awareness of emerging I⁢ trends and directions

- Experience in monitoring and enforcing data modelling/normalization standards

- Experience in developing enterprise architecture deliverables (e.g. models) Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills

- A team player with a track record for meeting deadlines

Desirable Skills

- Experience with middleware and gateways

- Experience in designing/developing an automated data distribution mechanism

- Knowledge and understanding of object-oriented analysis and design techniques.

- Experience in developing enterprise architecture deliverables (e.g. models) based on Ontario Government Enterprise Architecture processes and practice

- Knowledge and understanding of Information Management principles, concepts, policies and practices

- Experience creating detailed data standards to enable integration with other systems

- Experience reviewing conceptual, logical and physical data models for quality and adherence to standards





- Knowledge and understanding of dimensional and relational data models

- Knowledge and experience in information resource management tools and techniques

Experience Requirements

General Skills (80%)

- Demonstrated experience developing conceptual, logical and physical data models.
- Extensive experience developing enterprise, common, canonical and domain data models that support interoperability, information exchange and data sharing across multiple business domains.
- Deep knowledge of data architecture principles, methodologies, standards and best practices.
- Experience using data modelling tools such as ERwin, PowerDesigner, Visio or equivalent CASE tools.
- Experience defining business entities, relationships, hierarchies, attributes and business rules.
- Extensive experience developing semantic data models, controlled vocabularies, business glossaries, canonical business definitions, reference data structures and semantic relationship models.
- Demonstrated experience establishing common business definitions, controlled vocabularies, semantic models and common data models to support interoperability, information sharing and enterprise data governance across multiple business domains.
- Experience facilitating business and technical workshops to define and reconcile business terminology, business entities, relationships and canonical definitions.
- Experience developing business glossaries, reference data models and semantic relationship models.
- Experience applying domain-driven modelling and business capability analysis to the development of common data models.
- Experience establishing modelling standards, naming conventions and metadata requirements.
- Experience designing reference data and master data structures.
- Experience supporting interoperability, information exchange and data integration initiatives.
- Experience developing architecture artefacts and checkpoint deliverables with traceability to business architecture requirements.
- Knowledge of metadata management, data lineage and data governance principles.
- Experience supporting data migration,



integration and modernization initiatives.
- Strong analytical, problem-solving and communication skills.

Resource will support the following deliverables:

- Common Data Model (CDM)
- Canonical Data Model
- Conceptual Data Models
- Logical Data Models
- Semantic Data Models
- Business Glossary
- Controlled Vocabulary
- Canonical Business Definitions
- Reference Data Models
- Semantic Relationship Models
- Data Standards and Naming Conventions
- Architecture artefacts supporting architecture governance and review processes
- Data interoperability and information exchange recommendations
- Data prototyping and proof-of-concept activities

Desirable Skills (20%)

- Experience developing common data models, business vocabularies and semantic frameworks for regulatory, permitting, licensing, compliance or public-sector programs involving multiple business domains and stakeholder groups.
- Experience with semantic modelling, ontology development or knowledge graph concepts.
- Knowledge of RDF, OWL, graph databases or semantic technologies.
- Experience with Databricks, Neo4j, Denodo or equivalent data platforms.
- Experience with metadata repositories and governance solutions.
- Knowledge and understanding of Information Management principles, concepts, policies and practices.
- Knowledge and understanding of AODA and related standards.
- Experience supporting permitting, regulatory, licensing or public sector business domains.

Supplier Comments

Closing Date/Time: 2026-10-29, 12:00 p.m. EST.

Max submission: 1 (one)

5 days onsite

HM is looking for someone who has hands-on data modeling experience – conceptual, semantic, logical and physical

Must Have:

- Extensive experience developing enterprise, common, canonical and domain data models that support interoperability, information exchange and data sharing across multiple business domains.
- Deep knowledge of data architecture principles, methodologies, standards and best practices.
- Demonstrated experience establishing common business definitions, controlled vocabularies, semantic models and common data models to support interoperability, information sharing and enterprise data governance across multiple business domains.
- Experience facilitating business and technical workshops to define and reconcile business terminology, business entities, relationships and canonical definitions.
- Experience developing business glossaries, reference data models and semantic relationship models.

📌 Data Architect/Modeller (Toronto)
🏢 Softline Technology
📍 Toronto