Job Description

Description

To respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basis.


"This position is listed as "Onsite"; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location".


The key deliverables for this role is to:


Review and update the existing DCP Stabilization Architecture (conceptual, logical and physical) to ensure it is current to the latest build Develop a business intelligence (BI) data model (conceptual, logical, physical) based on the client needs Map the transaction data model to the BI data model

Map the UI data fields to logical model to business components and physical model as the system is on a Siebel platform. This will facilitate future data extraction from the transactional system


Note: Existing data model is documented in Power Designer. Updates to the existing model and the new model are to be also documented in Power Designer.

Responsibilities:

Conduct comprehensive information architecture needs assessment under the guidance and leadership of project leads and cluster architects

Conducts and facilitates stakeholder interviews and/or workshops to determine reporting requirements

Plans, leads and facilitates review sessions to confirm and/or validate requirements

Lead, develop and present required information architecture artifacts to support Corporate/Cluster ARB approvals


o Conceptual Data Model



o Logical Data Model



o Fact/Dimension Matrix



o Logical Dimensional Model



o Interface Data Requirements and design


Support project leads to create detailed plans and resource estimates for information architecture components

Provide information architecture expertise and support/inform to solution design/development

Adhere to all applicable GO-ITS standards

Revise architectures per action and/or conditions arising from LRC's governance body (Project Gating Review Committee) and Corporate EA Governance review bodies as required

Knowledge Transfer Requirements

Knowledge transfer is expected to occur throughout the duration of the assignment through regular meetings, touchpoints, and working sessions with LRC staff All design, development, artefacts, and source code, including all relevant and complete documents must be transferred to the ministry in the designated repositories provided Dedicated knowledge transfer sessions will be scheduled to ensure completeness of knowledge transfer and all documentation is shared, and allow LRC staff to ask clarification and/or follow up questions

Experience Requirements

Evaluation Criteria:

Information Architecture Skills - 65%

Hands on demonstrated experience in the creation of data models (Conceptual, Logical, Physical) and capturing information integration requirements

Demonstrated experience in developing Fact & Dimensional Matrix

Demonstrated experience in determining Resource Types, using existing Business Process Models

Demonstrated experience in creating and normalizing Logical Data Models (With complete attributes, data type and data size)

Demonstrated experience in developing information architecture specifications through interpretation of relevant Business Architecture models and other business/application specifications

Demonstrated experience in information modeling for Siebel based applications

Hands on experience creating architecture artefacts, models and/or reports using PowerDesigner

Demonstrated experience in leading in-depth and 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 producing and presenting information architecture deliverables to successfully obtain Corporate/Cluster ARB approval

Demonstrated knowledge and working experience applying / aligning with OPS Information Architecture standards

Soft Skills - 30%

Experience working with agile/iterative methodologies

Excellent analytical, problem solving and decision-making skills

Excellent communication skills, both written and verbal

Excellent meeting facilitation skills to gather requirements

Experience reporting progress on deliverables to team, project leads and management, including proactively raising risks/issues with mitigations

Strong stakeholder management skills

Demonstrated consensus building skills

Public Sector Experience - 5%

Experience with OPS or Public Sector I&IT standards, project delivery methodologies, and practices

Experience with OPS or Public Sector enterprise architecture review / approval processes (Cluster and Corporate)

Demonstrated knowledge of Public Sector applications, databases and systems

Experience working in accordance with policies and procedures of the Ontario Public Service


Working knowledge of Accessibility for Ontarians with Disabilities Act (AODA)


? 10+ years demonstrated experience in creation of data models (Conceptual, Logical, Physical) and capturing information integration requirements


Experience producing and presenting information architecture deliverables (models) to successfully obtain Cluster/Corporate ARB approval.

10+ years demonstrated experience in developing BI data models (conceptual, logical, physical)

10+ demonstrated experience in creating and normalizing Logical Data Models with complete attributes, data type and data size

Demonstrated experience in information modeling for systems based on Siebel is an asset

10+ years demonstrated experience in developing information architecture specifications through interpretation of relevant Business Architecture models

10+ years demonstrated experience in defining, identifying and describing information architectural requirements with clients, and obtaining I&IT management approval

Demonstrated experience in leading in-depth and complex information architecture reviews and assessments

Demonstrated experience in providing professional information architecture expertise and undertaking comprehensive architecture needs assessments and complex reviews in support of systems/infrastructure needs

Demonstrated experience providing plans and resource estimates for large-scale and complex information architecture projects

Demonstrated hands on experience creating architecture artefacts, models and/or reports using PowerDesigner (or similar architecture/modeling tools)


Supplier Comments

Closing date/time:

2026-01-16, 2:30 p.m.

Max no. of submission: 1 (one)

Onsite

Must Have:

10+ years demonstrated experience in creation of data models (Conceptual, Logical, Physical) and capturing information integration requirements

Experience producing and presenting information architecture deliverables (models) to successfully obtain Cluster/Corporate ARB approval.

10+ years demonstrated experience in developing BI data models (conceptual, logical, physical)

10+ demonstrated experience in creating and normalizing Logical Data Models with complete attributes, data type and data size

Demonstrated experience in information modeling for systems based on Siebel is an asset

10+ years demonstrated experience in developing information architecture specifications through interpretation of relevant Business Architecture models

* 10+ years demonstrated experience in defining, identifying and describing information architectural requirements with clients, and obtaining I&IT management approval