Specialist Data Integration Data Analytics, Reporting & Evaluation

 

Decision Support Services

Vancouver, BC

 

Reporting to the Lead, Data Architecture and Business Intelligence, the Specialist, Data Integration is responsible for the planning, design, development and management of new and existing data warehouse and analytics solutions related to various PHSA programs and services. Applying a broad range of information technology experience, Data Warehousing (DW), Business Intelligence (BI), and clinical and operational knowledge, the Business Intelligence Specialist works with stakeholders to develop analytical products that meet their analytical, reporting, monitoring, surveillance and evaluation needs.  This position plans, designs, and develops BI and analytical solutions, including data Extract, Transform, Load (ETL) processes, data marts, reports and dashboards as part of the overall PHSA Enterprise Data Warehouse.  This position ensures the integrity and quality of the data accessible through these solutions, and also manages and maintains the metadata and other product documentations.

What you’ll do

• Architect and implement analytics solutions to develop, enhance and improve analytics and use of data at various PHSA programs and external stakeholders. This includes leading the design, development, documentation and implementation of complex data marts, multidimensional cubes or other semantic models, reports, dashboards and other front-end interfaces.
• Architect and implement optimal database schemas and ETL solutions to integrate data from various source systems into integrated linked data marts. Collaborate with other members of the team on conceptual design, development, and implementation of the Enterprise Data Warehouse.
• Lead the identification of new data sources and implements data extraction routines from departmental feeder systems. Provide advice and direction on data availability and quality. Consult and problem-solves with feeder departments regarding routine data extracts.
• Participate in the development, definition and reporting of performance indicators as related to program operations, access and throughput, for use at the program director and executive level. Liaise on behalf of the agency with external consultants on the provisioning of patient specific data, as well as providing education on analysis and interpretation.
• Provide technical expertise in the development of Analytics and Business Intelligence solutions by assessing client needs and requirements, reviewing technical options, determining the design and architecture and leading all levels of the solution development and deployment. 
• Ensure the designed solutions meet the established architectural, security, and quality standards set by the department by actively engaging peers and lead in design and review processes. Maintain current metadata, definitions and documentation of the solutions.
• Maintain familiarity with the latest on-premises and cloud analytics technologies, and an awareness of current clinical and business information system trends and issues. Evaluate and recommend products or methods to deliver analytics and Business Intelligence in an accurate, timely and user friendly manner.
• Mentor other developers and team members and provides technical and educational support to end users by developing training materials, delivering training sessions and training trainers.   
• Represent DARE on committees at various levels with regard to data standards, appropriate usage, availability and quality.

What you bring

 

Qualifications

• A level of education, training, and experience equivalent to a Bachelor’s degree in Computer Science, Information Technology, Health Information Science, Management Information Systems or a related field, plus 3 to 5 years of recent BI, data warehousing, data modelling or analytics experience. Strong understanding of health care system operations and public and population health concepts is definite asset.
• Demonstrated knowledge of the historic and ongoing impacts of settler colonialism on Indigenous Peoples in social and health contexts, including supported by significant knowledge of Indigenous-specific mandates, including clear understanding of and commitment to eradicate Indigenous-specific racism and discrimination and embed Indigenous Cultural Safety and Humility.
• Demonstrate comprehensive knowledge of the historic and ongoing impacts of settler colonialism and systemic racism on Indigenous Peoples within social and health contexts. This includes understanding how these factors contribute to current health disparities and barriers to care. Show a clear commitment to identifying, challenging, and eradicating Indigenous-specific racism and all forms of discrimination impacting equity-deserving groups within health care settings. This involves familiarity and understanding Indigenous Cultural Safety and Humility recognizing personal biases, institutional barriers, engaging in anti-racism education and training and advocating for systemic change.
• Demonstrated knowledge and understanding of legislative obligations and provincial commitments within Decision Support Services contexts found in the foundational documents including Truth & Reconciliation Commission’s Calls to Action (2015), In Plain Sight (2020), BC's Declaration on the Rights of Indigenous Peoples Act (2019), United Nations Declaration on the Rights of Indigenous Peoples (UNDRIP), Reclaiming Power and Place Missing and Murdered Indigenous Women & Girls Calls for Justice (2019), the Declaration Act Action Plan and Remembering Keegan: A First Nations Case Study - BC Human Rights Code, BC Anti-racism Act and how they intersect across the health care system.

Core Competencies

• Brings an understanding of the Indigenous specific racism and the broader systemic racism that exists in the colonial health care structure, and has demonstrated initiatives in breaking down barriers and ensuring a safe environment ensuring a sense of belonging to all and informed by Indigenous Cultural Safety.
• Awareness of social, economic, political and historical realities of settler colonialism on Indigenous Peoples and familiarity with addressing Indigenous-specific anti-racism, anti-racism and Indigenous Cultural Safety and foundational documents and legislative commitments (the Declaration Act, the Declaration Action Plan, TRC, IPS, Remembering Keegan, etc.).

Skills & Knowledge

• Advanced knowledge, and experience in application of best practices of data standards, database design, data architecture and modelling. Expertise in developing ETL solutions, relational and multi-dimensional databases and data marts. Superior database querying, and query optimization skills using Structured Query Language -preferably T-SQL, MDX or DAX or equivalents. Knowledge of experience with BI and visualizations tools such as Microsoft Power BI, and Tableau, and collaboration solutions such as SharePoint. Proven hands-on experience with standard data warehousing and Business Intelligence tools such as Microsoft SQL Server, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), and related development tools and version control tools, or comparable technologies from other vendors. Working knowledge of big data technologies, data science methods and languages such as (Python, R) and Windows and web application development tools and languages is an asset. High level of expertise in Microsoft Office suite of applications.
• Excellent interpersonal, oral and written communication skills with the ability to communicate complex ideas in simple terminology with internal and external contacts. Demonstrated ability to analyze operational problems and recommend innovative solutions. Strong analytical, problem solving and system analysis 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. Customer focused with ability to facilitate and encourage cooperation between professionals from other disciplines. Ability to understand management reporting and statistical concepts.  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.  Self-directed and motivated to learn new tools and technology. Ability to work independently with little direct supervision and as a member of a multi-disciplinary team. Excellent time management skills with the ability to organize and prioritize work. Physical ability to perform the duties of the job. Persistence and a positive attitude are essential given the iterative development cycle and sometimes problematic data integration issues.
• Demonstrates a commitment to beginning and/or continuing their personal learning journey related to Indigenous-specific racism and dismantling systems of oppression, as well as addressing racism more broadly. Shows willingness to articulate and share their learning experiences to contribute to a culture of motivation and inspiration among peers.
• Demonstrates foundational knowledge of the social, economic, and political realities of settler-colonialism and its impacts on Indigenous peoples and equity-deserving groups within social and health contexts. Understands the impact of social determinants of health-on-health outcomes. Shows a commitment to learning about and upholding legislative obligations and provincial commitments outlined in foundational documents such as the Truth & Reconciliation Commission’s Calls to Action (2015), In Plain Sight (2020), BC's Declaration on the Rights of Indigenous Peoples Act (2019), United Nations Declaration on the Rights of Indigenous Peoples (UNDRIP), Reclaiming Power and Place: Missing and Murdered Indigenous Women & Girls Calls for Justice (2019), the Declaration Act Action Plan, Remembering Keegan: A First Nations Case Study, the BC Human Rights Code, Anti-Racism Data Act, and the Distinctions Based Approach.

What we bring

 

Every PHSA employee enables the best possible patient care for our patients and their families. Whether you are providing direct care, conducting research, or making it possible for others to do their work, you impact the lives of British Columbians today and in the future. That’s why we’re focused on your care too – offering health, wellness, development programs to support you – at work and at home.

• Join one of BC’s largest employers with province-wide programs, services and operations – offering vast opportunities for growth, development, and recognition programs that honour the commitment and contribution of all employees.
• Access to professional development opportunities through our in-house training programs, including +2,000 courses, such as our San’yas Indigenous Cultural Safety Training course, or Core Linx for Leadership roles.
• Enjoy a comprehensive benefits package, including municipal pension plan, and psychological health & safety programs and holistic wellness resources.
• Annual statutory holidays (13) with generous vacation entitlement and accruement.
• PHSA is a remote work friendly employer, welcoming flexible work options to support our people (eligibility may vary, depending on position).
• Access to WorkPerks, a premium discount program offering a wide range of local and national discounts on electronics, entertainment, dining, travel, wellness, apparel, and more.

Job Type: Regular, Full-Time

Salary Range: $76,111 - $109,409/year. The starting salary for this position would be determined with consideration of the successful candidate’s relevant education and experience, and would be in alignment with the provincial compensation reference plan. Salary will be prorated accordingly for part time roles.
Location: 1333 W Broadway, Vancouver, BC V6H 1G9
Closing date: Applications accepted until position is filled
Hours of Work: 08:00-16:00 (Monday to Friday)
Requisition #: 197028E

 

What we do

 

The Provincial Health Services Authority (PHSA) plans, manages and evaluates specialized health services with the BC health authorities to provide equitable and cost-effective health care for people throughout the province. Our values reflect our commitment to excellence and include: Respect people – Be compassionate – Dare to innovate – Cultivate partnerships – Serve with purpose.

 

Learn more about PHSA and our programs: jobs.phsa.ca/programs-and-services

 

PHSA is committed to equity in our hiring and employment practices. With learning and compassion, we are addressing existing inequities and barriers throughout our systems. PHSA is seeking to create a diverse workforce and to establish an inclusive and culturally safe environment. We invite applications and enquiries from all people, particularly those belonging to the historically, systemically, and/or persistently marginalized groups identified under the B.C. Human Rights Code.

 

One of PHSA’s North Star priorities is to eradicate Indigenous-specific racism, which includes dismantling barriers to health care employment at every level. We welcome Indigenous individuals to apply and/or contact the Sanya'kula Team (Indigenous Recruitment & Employee Experience) for support at indigenous.employment@phsa.ca.

 

Indigenous-specific anti-racism initiatives are rooted in addressing the unique forms of discrimination, historical and ongoing injustices, and marginalization faced by Indigenous peoples. These initiatives align with an Indigenous rights-based approach, recognizing the inherent rights and self-determination of Indigenous communities. PHSA must uphold legislative obligations and provincial commitments found in the foundational documents such as including Truth & Reconciliation Commission’s Calls to Action (2015), In Plain Sight (2020), BC's Declaration on the Rights of Indigenous Peoples Act (2019), United Nations Declaration on the Rights of Indigenous Peoples (UNDRIP), Reclaiming Power and Place Missing and Murdered Indigenous Women & Girls Calls for Justice (2019), the Declaration Act Action Plan and Remembering Keegan: A First Nations Case Study.

 

Attention current employees of PHSA:

 

You must apply via your internal profile at http://internaljobs.phsa.ca.

 

The internal job posting expires on April 10, 2026 and will no longer be accessible. If the internal job posting has expired, please e-mail internaljobshelpu@phsa.ca 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.

 

If you have not yet set up an internal profile, please e-mail internaljobshelpu@phsa.ca with your PHSA employee ID number to obtain your temporary password. Our business hours are Monday-Friday 8:30am-4:30pm, excluding Statutory Holidays and a Help Desk Representative will respond to you with 1-2 business days.

 

If you are not a current employee of PHSA and require assistance with your application, please contact the External Careers team at careers@phsa.ca.