Data Modeler / Architect

About the role

Requirements: What you'll need

Skills, Knowledge, Experience, and Qualifications:

Mandatory Skills:

Knowledge and experience in information resource management tools and techniques

Defines, identifies and describes information architectural requirements with clients, and obtains I&IT management approval.

Ability to complete complex information architecture reviews and assessments, development and/or support projects, to support new and changed enterprise priorities and initiatives, and client clusters’ and their clients’ information architecture and/or business needs.

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 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&IT 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

Resource will build upon the Conceptual and Logical Data Models which are technology-and application-independent and will assist with the following tasks/deliverables:

Continue ‘data prototyping’ to proof CDM recommendation

Refine the Logical Data Model as required.

Support MECP in developing their Data Migration strategy/plan

Assist with Alpha prototyping and/or proofs-of-concept

Support development of enterprise architecture artefacts for submission to Architecture Review Board for Architecture Gate Point 1 (AGP1) in spring 2027

Desirable Skills:

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

Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

Experience with middleware and gateways

Experience in designing/developing an automated data distribution mechanism

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

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

Public Sector Experience:

Previous experience working in Government or Public Sector organizations

Demonstrated experience in Ontario Design System https://designsystem.ontario.ca/

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

Must Have:

Resource will build upon the Conceptual and Logical Data Models which are technology-and application-independent and will assist with the following tasks/deliverables:

Continue ‘data prototyping’ to proof CDM recommendation

Refine the Logical Data Model as required.

Support MECP in developing their Data Migration strategy/plan

Assist with Alpha prototyping and/or proofs-of-concept

Support development of enterprise architecture artefacts for submission to Architecture Review Board for Architecture Gate Point 1 (AGP1) in spring 2027