Vancouver, Canada
Regular,Full-Time
Program
Share on social media
Category
Clerical/Secretarial Administrative/Administrative Resource Team
Requisition number
204462E
Date posted
09/25/2026
Job Summary
Reporting to the Decision Support Consultant, Information Integration, the Data Integration Specialist provides integrated healthcare data analysis and interpretation to senior leadership, agency committees, departments and external consultants. This role is responsible for opportunity identification, business requirements analysis, design and development of data marts and business intelligence solutions and extension of the Enterprise Data Warehouse. The Data Integration Specialist provides assistance to Performance Measurement & Reporting staff and to data/information creators in other departments with data quality, data manipulation and reporting, data integration (ETL), and data conversion.
Duties/Accountabilities
- Supports Performance Measurement and Reporting services in the development and distribution of healthcare data via business intelligence tools. Serves as a technical expert to program managers, physicians and the executive on accessing patient specific data and provides orientation to the tool as required for staff and clients.
- Develops data warehousing infrastructure to enable distribution of complex reports in a more robust way.
- Participates in the development, definition and reporting of patient specific data based performance indicators as related to agency operations, access and throughput, for use at the program director and executive level. Liaises on behalf of the agency with external consultants on the provisioning of patient specific data, as well as providing education on analysis and interpretation.
- Performs database administration tasks including database creation, database tuning, security administration, file management and data replication.
- Performs data administration tasks including the maintenance and integrity of patient specific data infrastructure, modelling the conceptual, logical and physical data architecture, creating value added data elements, and reporting of complex integrated information. Leads the identification of new data sources and implements data extraction routines from departmental feeder systems. Provides advice and direction on patient specific data availability and quality. Consults and problem-solves with feeder departments regarding periodic downloads.
- Oversees routine processing activities within the Performance Measurement and Reporting department related to key decision support applications. Develops and executes detailed, complex database scripts with regard to extraction, transformation, loading and analysis of patient specific data.
- Represents Performance Measurement and Reporting on committees at various levels with regard to data standards, appropriate usage, availability and quality.
Qualifications
A level of education, training, and experience equivalent to a Bachelor’s degree in Computer Science or Health Information Science/Management from a recognized school plus a minimum of three (3) to five (5) years recent related work experience.
Ability to apply in-depth subject matter knowledge in a healthcare, science or business discipline to the design of a business intelligence solution. Superior analytical and problem solving skills including the ability to comprehend complex large scale health care environment operational issues and related data/information and present information in concise meaningful ways. Ability to understand and explain complicated technical issues in non-technical terms.
Advanced knowledge, and experience in application of best practices of data standards, database design, data architecture and modeling. Expertise in developing ETL solutions using SQL Server Integration Services (2008). Superior database querying skills using Structured Query Language -preferably T-SQL. Understanding of report writing tools such as Crystal Reports and SQL Server Reporting Services. Ability and experience in developing technical documentation. Customer focused with ability to facilitate and encourage cooperation between professionals from other disciplines. Ability to educate and lead management staff on the importance of using high quality data for decision making, via business intelligence tools and other means. Demonstrated administrative, organizational, work planning and control skills. Ability to communicate effectively both verbally and in writing. Ability to work under pressure and multi-task with little direct supervision. Persistence and a positive attitude are essential given the iterative development cycle and sometimes problematic data integration issues.
Apply Save job
Back to search result
SVG
Internal job portal
Current employees must apply through the internal job portal (link is external) .
If the internal job posting has expired, please e-mail internaljobshelpu@phsa.ca (link sends email) with the six-digit job requisition number and your PHSA employee ID number to be considered as a late internal applicant. Please do not apply for the external job posting.
SVG
PHSA’s values and Coast Salish Teachings
PHSA embodies values that reflect a commitment to excellence. PHSA’s values are: Compassion, Respect, Equity, Courage, Innovation. In addition, PHSA accepted six Coast Salish Teachings from Coast Salish Knowledge Keeper Shane Pointe, Siem Te’ta-in.
Learn more about PHSA’s values and teachings
Back to top
Sign up for job alerts
SVG
Learn about new career opportunities
Be the first to know about new jobs at PHSA with recent postings sent straight to you!
Email Address
Job Categories
Call Taker / DispatcherClerical/Secretarial Administrative/Administrative Resource TeamCommunicationsCommunity Health ServicesData AnalyticsDentalDentistryFinance / PayrollHealth Information ManagementHuman Resources/ OH&S / EducationIndigenous HealthInformation TechnologyLab PathologyLegal, Privacy, and RiskManagementMedical ImagingMedical LeadershipMedical Staff - OtherMental HealthMental Health Support ServicesMolecular Imaging and TherapyNew Grad NurseNursing/Licensed Practical NurseNutritionOperations & Strategy ManagementParamedicPatient Care Support ServicesPharmacyPhysiciansProject ManagementPsychiatryPsychologyQuality and SafetyRadiation TherapyResearchRespiratory TherapyRespiratory Therapy Social WorkSonographySupply Chain/Purchasing/LogisticsSupport ServicesTherapy ServicesTrades
Call Taker / Dispatcher
Clerical/Secretarial Administrative/Administrative Resource Team
Communications
Community Health Services
Data Analytics
Dental
Dentistry
Finance / Payroll
Health Information Management
Human Resources/ OH&S / Education
Indigenous Health
Information Technology
Lab Pathology
Legal, Privacy, and Risk
Management
Medical Imaging
Medical Leadership
Medical Staff - Other
Mental Health
Mental Health Support Services
Molecular Imaging and Therapy
New Grad Nurse
Nursing/Licensed Practical Nurse
Nutrition
Operations & Strategy Management
Paramedic
Patient Care Support Services
Pharmacy
Physicians
Project Management
Psychiatry
Psychology
Quality and Safety
Radiation Therapy
Research
Respiratory Therapy
Respiratory Therapy
Social Work
Sonography
Supply Chain/Purchasing/Logistics
Support Services
Therapy Services
Trades
Select the job categories you want to be notified for. You can optionally select one or more locations as well to limit the alerts you receive to jobs in those locations.
Locations
AbbotsfordBurnabyCampbell RiverChilliwackCoquitlamCourtenayCranbrookDawson CreekDuncanFernieFort St. JohnHopeKamloopsKelownaLadnerLangleyMaple RidgeMissionNanaimoNelsonNew WestminsterNorth VancouverNorthern BcOliverParksvillePembertonPentictonPort CoquitlalmPort CoquitlamPort MoodyPowell RiverPrince GeorgeRichmondSaanichtonSalmon ArmSecheltSquamishSurreyVancouverVernonVictoriaWhistlerWhite Rock
Abbotsford
Burnaby
Campbell River
Chilliwack
Coquitlam
Courtenay
Cranbrook
Dawson Creek
Duncan
Fernie
Fort St. John
Hope
Kamloops
Kelowna
Ladner
Langley
Maple Ridge
Mission
Nanaimo
Nelson
New Westminster
Northern Bc
North Vancouver
Oliver
Parksville
Pemberton
Penticton
Port Coquitlalm
Port Coquitlam
Port Moody
Powell River
Prince George
Richmond
Saanichton
Salmon Arm
Sechelt
Squamish
Surrey
Vancouver
Vernon
Victoria
Whistler
White Rock
Your personal information is collected, used, and disclosed only for the purposes of delivering updates to you about career opportunities. Provincial Health Services Authority collects your information as authorized under section 26 (c) of the British Columbia Freedom of Information and Protection of Privacy Act (FIPPA). By submitting your information, you acknowledge that you have read our privacy policy and consent to receive email communication from PHSA. You may unsubscribe at any time.
I accept terms of service
Current employees must apply through the internal job portal (link is external) .
If the internal job posting has expired, please e-mail internaljobshelpu@phsa.ca (link sends email) with the six-digit job requisition number and your PHSA employee ID number to be considered as a late internal applicant. Please do not apply for the external job posting.
PHSA embodies values that reflect a commitment to excellence. PHSA’s values are: Compassion, Respect, Equity, Courage, Innovation. In addition, PHSA accepted six Coast Salish Teachings from Coast Salish Knowledge Keeper Shane Pointe, Siem Te’ta-in.
