Data Developer, Business Intelligence

 

Data Management

Burnaby, BC

Note: There are 2 positions available

 

In accordance with the Mission, Vision and Values, and strategic directions of PHSA safety, including both patient and employee safety, is a priority and a responsibility shared by everyone at PHSA’s Agencies/Divisions/Services, and as such, the requirement to continuously improve quality and safety is inherent in all aspects of this position.

Reporting to the Manager, Supply Chain Performance, the Data Developer develops and maintains various complex data solutions, tools, and automations which impact several functional areas throughout PHSA. The Data Developer is responsible for building reports or dashboards, performing data analytics, writing programming codes to develop data ETL (extraction, transform, load) pipelines for data integration, and building small applications with GUI (Graphical User Interface) to gather business data and develop data visualization. The Data Developer designs, builds, and implements data system and infrastructure to support machine learning and AI analytics. The Data Developer works with internal or external stakeholders to translate business requirements into technical specification, and is responsible for implementing software or infrastructure upgrades, developing strategies for data security, and ensuring compliance with pertinent PHSA IT security and privacy policies. The Data Developer works primarily with Microsoft solutions such as SQL Server, SSRS, Power BI, SSAS, SSIS, TSQL, DAX, C#, Python, Power Platform, Azure Functions, and multiple Azure data-related services in the cloud, and manages and supports the servers and infrastructure used as the hosting environment.

What you’ll do

• Design, develop, and maintain reports and complex analytical solutions by gathering business requirements, translating requirements into technical specifications and logical data model, developing corresponding database, troubleshooting errors, and deploying solutions. Write ad-hoc queries and reports to support staff and leaders in data analysis, when required.
• Resolve data-related technical challenges and performs root-cause analysis to answer specific business questions by tracing data transformation through different stages in the automated data pipeline, troubleshooting programming errors, investigating the impact of business process / application configuration changes to the data automation, researching industry best practices for design and programming, developing programming solutions to fix problems, and working with IMITS and external vendors to deploy application patches.
• Design, develop, and support the automated data ETL (extraction, transform and load) processes by automating data gathering from on-premise applications or cloud sources on the internet, troubleshooting programming errors, developing and deploying solutions to fix errors. Develop programming scripts to automatically monitor ETL environment security.
• Develop technical requirement and implementation plan, coordinate with stakeholders to execute technical implementation plan, and escalates to project sponsor(s) when required.
• Develop small applications with GUI (Graphical User Interface) to gather business data, troubleshoots application programming errors, and develop / deploy solutions to fix errors.
• Write programming codes to develop data pipelines using data engineering or data science techniques, and transform data by utilizing machine learning or Artificial Intelligence algorithms. Automate processes to cleanse and enhance business data to bring out insights or data patterns. Facilitate or automatesbusiness decision making with the enhanced data. Design, build, and implement data system and infrastructure to support the machine learning and AI analytics.
• Sustain application access and security, perform system inspections, develop automated scripts for application / database functional testing or unit testing, recommend improvements to ensure effectiveness of programming development processes or system performance.
• Draft standard procedures, write comprehensive system and operating documents, prepare system documents for review and approval and develop backup/recovery.
• Provide training on applications and reporting, coach and support staff by hosting presentations, or writing users manuals.
• Perform other related duties as assigned.

What you bring

Qualifications

• Graduation from a recognized degree or diploma program in Computer Science, three (3) years of recent related experience or an equivalent combination of education, training and experience.
• 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 Management 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

• Ability to communicate effectively both verbally and in writing.
• Ability to deal with others effectively.
• Physical ability to carry out the duties of the position.
• Ability to write programs in a variety of program languages
• Ability to organize work.
• Ability to operate related equipment.
• 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
Wage: $49.03 / hour
Location: 1795 Willingdon Ave, Burnaby, BC V5C 6E3
Closing Date: Applicants accepted until position is filled
Hours of Work: Monday-Friday 09:00-17:00
Requisition #: 202440E, 202441E

2 positions available

 

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 – Create equity – Be courageous.

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

PHSA is committed to anti-racism and 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 excluded groups identified under the B.C. Human Rights Code.

One of PHSA’s North Star priorities is to eradicate Indigenous-specific racism, which includes ongoing commitments to Indigenous recruitment and employee experience as well as dismantling barriers to health care employment at every level. We welcome Indigenous individuals to apply and/or contact the Sanya’k̓ula Team (Indigenous Recruitment & Employee Experience) for support at ***@phsa.ca 🔒 Premium.

Indigenous-specific anti-racism initiatives are rooted in addressing the unique forms of discrimination, historical and ongoing injustices, and exclusion faced by Indigenous peoples. These initiatives align with an Indigenous rights-based approach, recognizing the inherent rights and title of BC First Nations and self-determination of all First Nations, Inuit and Métis communities. PHSA is mandated to uphold legislative obligations and provincial commitments found in the foundational documents including 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 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 August 25, 2026 and will no longer be accessible. If the internal job posting has expired, please e-mail ***@phsa.ca 🔒 Premium 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 ***@phsa.ca 🔒 Premium 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 ***@phsa.ca 🔒 Premium.