Education

• Bachelor’s degree in Computer Science (or related field) plus 3+ years of experience in data modeling, ETL, Microsoft BI tools (SSAS, SSRS, SSIS, Power BI), advanced T-SQL, and business requirements analysis, or an equivalent combination of education and experience.
• Recent experience coordinating and documenting change management processes for complex information systems.
• Strong business analysis, project management, and relationship-building skills, with excellent interpersonal communication.

Skills and Abilities

• Strong experience with Microsoft BI stack (SSIS, SSAS, SSRS) and Power BI for dashboard design.

• 3+ years of T-SQL development and database querying.

• 3+ years of programming experience (e.g., C#, VB.NET, Java) plus scripting (Python or similar).

• Hands-on experience in ETL environments and data integration across multiple platforms.

• Solid understanding of data architecture, data quality, data mapping, and data structures.

• Knowledge of OLAP technologies and dimensional modeling.

• Ability to translate business needs into technical solutions, including scoping and troubleshooting.

• Experience with HIM business processes and healthcare data systems is an asset.

• Strong documentation, communication, and stakeholder engagement skills, including simplifying complex concepts.

• Proven project management, problem-solving, and teamwork skills, with the ability to work independently and mentor others.

A competitive salary: The salary range for this position is $38.88 - $55.89 per hour, depending on experience.

Growth opportunities: We welcome individuals at all stages of their career, offering opportunities for professional development and growth.

State-of-the-art facilities:  The new St. Paul’s Hospital and health campus will be the most innovative approach to the delivery of integrated care in B.C. and Canada, designed to appropriately address the future health needs of patients, families, and our communities. From hospital care to primary and community health solutions, the new St. Paul’s Hospital and health campus will continue to lead innovations in care, research, and teaching. The new St. Paul’s Hospital is expected to open in 2027.

Inclusive culture: We respect the diversity, dignity and interdependence of all persons. We value the cultural richness that our diverse workforce brings to the care of our equally diverse population of patients and residents.

Your Day to Day:

• Participate in the full development lifecycle of the HIM Data Management Platform (planning, development, testing, deployment, and support).
• Contribute to data model design in collaboration with BI Architect Lead.
• Gather requirements and develop ETL processes, reports, and data integration solutions.
• Validate end-to-end business logic, data mappings, and data quality.
• Deliver ad-hoc and scheduled reports, dashboards, and management tools.
• Maintain and enhance ETL workflows, adapting to changing data sources and business needs.
• Support data migration and ongoing data management within the platform.
• Monitor, troubleshoot, and resolve technical and production issues.
• Collaborate with IMITS and business users to resolve system issues and ensure data integrity.
• Provide user support, training, documentation, and technical guidance to team members.

Who We Are:

Providence Health Care is one of the largest faith-based health care organizations in Canada. For the people at Providence, living our Mission, Vision and Values means providing British Columbians with compassionate, socially just, exceptional and innovative care every day.

From our humble roots 129 years ago, Providence has grown into globally renowned research, teaching, and care organization. As individuals within a mission-driven organization, we choose to be part of Providence Health Care because we value the organization’s long commitment to social justice and compassionate care, and its commitment to the process of Truth and Reconciliation with Indigenous Peoples.

We acknowledge that Providence Health Care and the new St. Paul’s Hospital site is located on the traditional, ancestral, and unceded territory of the Coast Salish Peoples, including the territories of the xʷməθkwəy̓əm (Musqueam), Skwxwú7mesh (Squamish), and Səl̓ílwətaʔ/Selilwitulh (Tsleil-Waututh) Nations.