Requisition number
204059E
Date posted
09/14/2026
Specialist, Data Integration Data Analytics, Reporting & EvaluationData Analytics
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 Data Analytics 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:30 (Monday to Friday)
Requisition #: 204059E
Attention current employees of PHSA: You must apply via your internal profile at http://internaljobs.phsa.ca 
