Note: Hybrid - Candidate MUST be able to work 3 days onsite and 2 days remote

MUST HAVES:

• 7+years experiences in the following:
• Developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas.
• Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer).
• Developing and implementing common data models and master data management strategies
• Design schemas that balance agility, schema flexibility, data governance, and quality.
• Expertise in creating schemas that allow flexible querying and analysis across various data formats.
• Defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns.
• Implementing schemas and metadata structures that support efficient data management.
• Understanding of data governance principles and practices, especially in designing schemas and metadata structures.
• Experience in creating Architecture Artefacts based on enterprise standards.
• 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse.
• 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment.
• Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks
• 10+ years experience with Solutions development.
• Experience in addressing complex data integration challenges and design efficient, scalable data models.
• Experience in monitoring and enforcing data modelling/normalization standards.

Description

NOTE

• Assignment Type: This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager.
• Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value. The Statement of Work (SOW) shall expire on March 31, 2026. HSC may exercise its option(s) to extend a SOW beyond March 31, 2026 using unused days/funds left on the contract. Such extension(s) will be allowable only if the Master Service Agreement is extended beyond April 5, 2026 and be upon the same terms, conditions and covenants contained in the SOW.

Responsibilities:

• Construct a high-level overview of the entire data landscape of the organization.
• Illustrate how data moves through the organization and between systems.
• Develop high-level designs outlining the main entities and their relationships.
• Design detailed models showing attributes, primary keys, and relationships between entities without considering physical aspects.
• Implement designs showing how data will be stored, including tables, columns, indexes, and relationships.
• Design diagrams showing how different data systems and databases interact and are integrated.
• Document standards and policies for data management, including naming conventions, data quality standards, and data security policies.
• Plan and guide the roles and responsibilities of data stewards in maintaining data quality and integrity.
• Compile detailed descriptions of data elements, their meanings, and their relationships.
• Create a comprehensive list of business terms and their definitions to ensure consistent usage across the organization.
• Document and design processes for extracting, transforming, and loading data from various sources.
• Strategize and schedule the movement of data from legacy systems to new systems or platforms.
• Detail the design of the data warehouse, including the schema, dimensions, and fact tables.
• Set up and configure BI tools and dashboards.
• Regularly report on the quality of data, identifying issues and areas for improvement.
• Develop strategies and methods for cleaning and improving the quality of data.
• Plan and diagram how data security will be implemented and maintained.
• Document compliance with relevant regulations and standards.
• Develop strategies for improving the efficiency and performance of data systems.
• Detail plans for data architecture projects, including timelines, milestones, and resources required.
• Document technical specifications for all data architecture components and processes.

Experience and Skill Set Requirements

Public Sector Experience - 5 points

• 5+ years of experience working with federal/provincial/broader public-sector healthcare providers.
• Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices.
• In-depth knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies.
• Knowledge and experience with Public Sector Health related projects.
• Knowledge and understanding of Ministry policy and IT project approval processes and requirements.
• Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies.
• Experience with large complex IT Health-related projects.

Technical Skills and Experience - 50 points

• 7+years experiences in the following:
• Developing conceptual, logical and physical data models for structured, semi-structured, and unstructured data with relational, star and snowflake schemas.
• Proficiency in data modeling methods and tools (e.g. ERWIN, VISIO, Power Designer).
• Developing and implementing common data models and master data management strategies
• Design schemas that balance agility, schema flexibility, data governance, and quality.
• Expertise in creating schemas that allow flexible querying and analysis across various data formats.
• Defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns.
• Implementing schemas and metadata structures that support efficient data management.
• Understanding of data governance principles and practices, especially in designing schemas and metadata structures.
• Experience in creating Architecture Artefacts based on enterprise standards.
• 4+ years experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse.
• 3+ years experience of implementing Medallion architecture or similar frameworks. Familiarity with tools and techniques for managing metadata in a data lakehouse environment.
• Hands-on experience with Azure services, including Azure Data Factory, Azure Data Lake Storage, and Azure Databricks.

Core Skill and Experience - 30 points

• 10+ years experience with Solutions development.
• Experience in addressing complex data integration challenges and design efficient, scalable data models.
• Experience in monitoring and enforcing data modelling/normalization standards.
• Experience with the privacy and security requirements or software development in a health context, or equivalent.
• Demonstrated knowledge of leading technical design, security and recovery procedures for application development.
• Experience with relational and hierarchical database technologies.
• Demonstrated understanding and experience with the use of information retrieval packages using query languages.
• Experience in production environment troubleshooting and tuning to improve performance.
• Knowledge and experience of Information Management tools, principles, concepts, policies and practices.

General Skills - 15 points

• 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.
• Awareness of emerging I&IT trends and directions
• Excellent analytical, problem-solving and decision-making skills; A team player with a track record for meeting deadlines. Strong communication skills to articulate data architecture concepts and collaborate with stakeholders.
• Experience working with cross-functional teams, including IT, business, and data engineering teams.
• Strong analytical skills to understand and model complex data relationships and structures.
• Meticulous attention to detail in designing and implementing data models and schemas.