Solution Architect

Client Industry: Healthcare IT

Contract Terms: 7 months

Hours: Full Time (37.5 hours/ week)

Work Location: Hybrid. Must work PST hours and go into office when required in Vancouver, BC

Project Description:

This project aims to establish a secure, compliant framework for data sharing among BC’s health organizations, enabling inter-organizational collaboration without the need for physical data transfers. Additionally, it focuses on modernizing the Ministry's data warehouse, Health ideas, by adopting cloud technologies to support growing data needs and align with healthcare data strategies. The goal is to facilitate timely, accurate, and near-real-time data access to enhance healthcare decision-making across the province.

Project Specifications:

• Federated Data Lakehouse with Microsoft Fabric and Data bricks: This PoC uses a hybrid model to test a federated data lakehouse environment, leveraging Microsoft Fabric and Data bricks for secure data access and collaboration.
• Role-Based Access and Security Framework: Establishes role-based access controls (RBAC) and auditing mechanisms to comply with healthcare data regulations and streamline data access securely.
• Data Cataloging and Metadata Management: Implements tools for data cataloging and lineage tracking, enhancing data discoverability and governance. A metadata management solution spans all health organizations, supporting both technical and business data visibility.
• Pilot Testing with Fake Data: Uses curated, de-identified fake data to simulate real-world data sharing, ensuring that data handling standards are met before implementing on live data.

Role Overview:

This partner role is critical in designing and optimizing data architectures, ensuring secure and collaborative federated environments. The Solutions Architect: Secure Data Movement Enablement will focus on transforming healthcare data, building robust data platforms, and ensuring alignment with governance, compliance, and evolving healthcare priorities.

• Extract and Transform Healthcare Data: Apply industry best practices in data transformation and modelling techniques, ensuring validated, accurate, and reliable outputs for use by downstream data teams and stakeholders.
• Enhance platforms using modern tools and technologies: Lead development initiatives to enhance healthcare data platforms and operations by adopting the latest technologies, including Azure, Fabric, Databrick ensuring alignment with BC health authority standards and priorities.
• Collaborate with the team for Healthcare Solutions: Collaborate with programs and maintain flexibility on domain ownership as business priorities evolve.
• Collaborate Across Teams and Adapt to Evolving Needs: Work with other data teams within Island Health on understanding data products and providing guidance and support during implementation and onboarding.

Specific Qualifications or Experience Required:

• Minimum bachelor’s degree in computer science, Data Engineering, or a related field.
• Extensive experience Microsoft Azure, Data lakes, Microsoft Fabric and Data Bricks architecture particularly within healthcare and public sector environments.
• 2+ years of professional experience in working with data, focusing on data transformation and modelling.
• Hands-on experience working with Azure, Data Bricks, and Microsoft Fabric.
• Strong proficiency in building ETL/ELT pipelines and working with large healthcare datasets.
• Expertise in SQL and at least one programming language such as Python or Scala.
• Familiarity with data modelling techniques and validation processes.
• Experience in cloud architecture design and data migration to platforms like Azure.
• Knowledge of healthcare regulatory standards (e.g., HITRUST, FHIR) and experience ensuring data governance compliance.
• Practical knowledge of Microsoft Purview for data security and privacy management.

Constraints and Special Considerations:

• Consultant must be available for the entire term
• Consultant must be based in Canada and available to work in a hybrid environment (remote with office days when required).