Specialist Data Integration Data Analytics, Reporting & Evaluation

Specialist Data Integration Data Analytics, Reporting & Evaluation

Decision Support Services

Vancouver, BC

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.

What you'll do

• 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.

What you bring

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.

Skills & Knowledge

• Commitment to upholding the shared responsibility of creating lasting and meaningful reconciliation in Canada as per TRC (2015) and BC's Declaration on the Rights of Indigenous Peoples Act (2019).
• As a strong asset for consideration, we are looking for our successful candidate to have: Knowledge 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.).

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: $74,618 - $107,264 /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: 0900-1700 (Monday to Friday)
Requisition # 177088E

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.

ATTN: PHSA Employees:

To be considered as a PHSA employee (internal applicant) for this position, you must apply online via your internal profile at http://internaljobs.phsa.ca

Please note the internal job posting will no longer be accessible after the expiry date of December 20, 2024. If the internal job posting has expired, please contact the Internal Jobs Help Desk and advise that you would like to be considered as a late internal applicant for this position. Please do not apply for the external job posting.

If you have not registered your internal profile, a password is required to log in for the first time. To obtain your password, please contact the Internal Jobs Help Desk at 604-875-7264 or 1-855-875-7264. Please note regular business hours are Monday - Friday (excluding stats), 8:30am to 4:30pm. For inquiries outside of regular business hours, please email the Internal Jobs Help Desk at internaljobshelpu@phsa.ca and a Help Desk Representative will contact you the next business day.