Job Description

HM Note: This onsite contract role is in office every day at the manager's discretion. Candidate resumes must include first and last name, email and telephone contact information.

Description

Deliverables

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 Conceptual Data Model Logical Data Model Fact/Dimension Matrix Logical Dimensional Model 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

Skills

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)

Experience and Skill Set Requirements

Evaluation Criteria:

Information Architecture Skills a?? 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 a?? 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 a?? 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)

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