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.
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.