MUST HAVES:

• Develops and supports data architecture for prototype and program development in a complex and distributed environment, 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.
• Collaborates with diverse and complex stakeholders to ensure alignment of data architecture with enterprise goals and compliance requirements.

Description

Responsibilities:

• Develops and supports data architecture for prototype and program development in a complex and distributed environment, 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
• Collaborates with diverse and complex stakeholders to ensure alignment of data architecture with enterprise goals and compliance requirements.
• Support work coming out of OHDC recommendations related to establishing system-level data governance and stewardship

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
• Strong knowledge of data modeling (conceptual, logical, physical) and database technologies.
• Experience in the use of 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. VISIO, PowerDesigner) including a working knowledge of metadata structures, repository functions, and data dictionaries
• Awareness of emerging I&IT trends and directions
• Experience in monitoring and enforcing data modelling/normalization standards
• Experience with big data technologies and knowledge of data privacy regulations within health domain.
• Expertise in data mesh and/or data fabric concepts.

Desirable Skills:

• 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
• Experience in designing/developing an automated data distribution mechanism; Knowledge and understanding of object-oriented analysis and design techniques.
• Experience in leading and developing enterprise and data architecture deliverables (e.g. models, playbooks) 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
• Knowledge and understanding of dimensional and relational data models

NOTE

• Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond the maximum contract value and any extension options included in the original SOW.
• Assignment Type: This position is currently listed as "Hybrid" as consultants will be required to work onsite at the work location 3 days a week and 2 days from home.

Experience and Skill Set Requirements

Data Architecture Experience - 50%

• Develops and supports data architecture for prototype and program development in a complex and distributed environment, 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.
• Collaborates with diverse and complex stakeholders to ensure alignment of data architecture with enterprise goals and compliance requirements.
• Breadth and depth of relevant career experience.
• Breadth and depth of public sector and/or health sectors.

General Skills and Experience - 30%

• 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
• Strong knowledge of data modeling (conceptual, logical, physical) and database technologies
• Experience in the use of tools for the development and documentation of data architectures and detailed data model
• Experience in the use of data modelling methods and tools (e.g. VISIO, PowerDesigner) including a working knowledge of metadata structures, repository functions, and data dictionaries
• Awareness of emerging I&IT trends and directions
• Experience in monitoring and enforcing data modelling/normalization standards
• Experience with big data technologies and knowledge of data privacy regulations within health domain
• Expertise in data mesh and/or data fabric concepts

Desirable skills - 20%

• 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
• Experience in designing/developing an automated data distribution mechanism; Knowledge and understanding of object-oriented analysis and design techniques.
• Experience in leading and developing enterprise and data architecture deliverables (e.g. models, playbooks) 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
• Knowledge and understanding of dimensional and relational data models