Senior Data Architect/Modeller

We are seeking a seasoned Senior Data Architect with extensive experience in designing and implementing data models and architecture frameworks within public sector healthcare projects. The ideal candidate will possess a strong technical background in data architecture, modeling, and management, coupled with significant public sector experience, particularly in healthcare.

Public Sector Experience

• Extensive experience working with federal, provincial, or broader public-sector healthcare providers.

• Knowledge of Public Sector Enterprise Architecture artifacts, processes, and practices, with the ability to produce technical documentation that complies with industry standards.

• In-depth understanding of Project Management Institute (PMI) and public sector I&IT project management methodologies.

• Experience with public sector health-related projects and familiarity with Ministry policy and IT project approval processes.

• Proven experience adhering to Public Sector Unified I&IT Project Methodology, Enterprise Architecture, Gating processes, and Standard Systems Development Methodologies.

• Expertise in managing large, complex IT health-related projects within the public sector.

Technical Skills and Experience

• Over 7 years of experience in developing conceptual, logical, and physical data models for structured, semi-structured, and unstructured data, employing relational, star, and snowflake schemas.

• Proficiency in data modeling methods and tools such as ERWIN, VISIO, and Power Designer.

• Experience in developing and implementing common data models and master data management strategies.

• Expertise in designing schemas that balance agility, flexibility, data governance, and quality, allowing for flexible querying and analysis across various data formats.

• Skilled in defining data partitioning, clustering, and indexing strategies to optimize query performance and data access patterns.

• Experience in implementing schemas and metadata structures that support efficient data management, with a strong understanding of data governance principles and practices.

• Experience in creating architecture artifacts based on enterprise standards.

• Over 4 years of experience in designing schemas that integrate diverse data types stored in a data lake or data lakehouse.

• At least 3 years of experience in implementing Medallion architecture or similar frameworks, with familiarity in 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 Skills and Experience

• Over 10 years of experience in solutions development, particularly in addressing complex data integration challenges and designing efficient, scalable data models.

• Proficient in monitoring and enforcing data modeling/normalization standards, with an understanding of privacy and security requirements in a healthcare context or equivalent.

• Demonstrated knowledge of leading technical design, security, and recovery procedures for application development.

• Experience with relational and hierarchical database technologies.

• Proficient in using information retrieval packages with query languages, and in troubleshooting and tuning production environments to improve performance.

• Strong knowledge and experience with Information Management tools, principles, concepts, policies, and practices.

General Skills

• Experience with at least two different platforms, operating systems, environments, database technologies, languages, and communication protocols.

• Knowledge of performance considerations for different database designs in various environments.

• Experience with 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, with a proven track record for meeting deadlines and 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.