The key deliverables for this role is to:
- Review and update the existing ECHO information 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 GOITS 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
Requirements
Experience and Skill Set Requirements
Information Architecture Skills
- 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 indepth 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
- Experience working with agile/iterative methodologies
- Excellent analytical problem solving and decisionmaking 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
- 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 modelling 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 indepth 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 largescale and complex information architecture projects
- Demonstrated hands on experience creating architecture artefacts models and/or reports using Power Designer (or similar architecture/modelling tools)
MUST HAVES:
- 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 knowledge and working experience applying / aligning with OPS Information Architecture standards
- Hands on experience creating architecture artefacts models and/or reports using Power Designer
- Demonstrated experience in creating and normalizing Logical Data Models (With complete attributes data type and data size)