Data Analyst, Business Intelligence

Status: Temporary Full-Time; term ends Dec31 2026
Number of Positions:1
Work Location: Vancouver BC - Hybrid (a combination of in-office and remote work)

Who we are

The British Columbia College of Nurses & Midwives (BCCNM) is the college empowered under the Health Professions Act to regulate the practice of all licensed practical nurses nurse practitioners registered midwives registered nurses andregistered psychiatric nurses in British Columbia. Regulation helps to protect the public by ensuring that professional care or service received by the public is competent ethical and meets the standards that society views as acceptable.

BCCNMs commitment to Indigenous Specific Anti-Racism

BCCNM is committed to working with Indigenous Peoples and health system partners to support Indigenous-specific anti-racist practices in the health system. As the largest health regulator in Western Canada BCCNM has the opportunity to influence the health professionals we regulate as well as the broader health-care system to break the cycle of racism and improve health outcomes for Indigenous Peoples. BCCNM has pledged to become culturally safe and anti-racist and to support the health professionals we regulate to do the same.

What we offer you

We promise to provide you with rewarding work that challenges you. You will be part of a passionate team contributing to our important mandate of protecting the public. As a member of the team you can expect to be working in a collaborative team-based environment and treated in a respectful and professional manner.

The expected starting base salary for this position is $83528 - 88336 annually depending on a variety of factors including qualifications and experience. Once hired you will progress through a wider salary range over time as you continue to develop job knowledge skills and competencies for the role.

In addition to base salary the college offers a generous vacation and extended benefits package. As an employee you receive 100% employer-paid health and dental benefits. And we contribute to B.C.s Municipal Pension Plan to help you secure your retirement your career with us you will engage in a variety of learning and development. We will support your professional development and cover your professional membership costs. To support you in work and life we provide an employee assistance program and fitness allowance perk. Working with us allows you to enjoy flexible hybrid work. This position is located in Vancouver but youll be able to work remotely up to 3 days a week. Our office is closed for the 11 statutory holidays in B.C. as well as Easter Monday and Boxing Day.

What youll be doing

The DA is responsible for analyzing and interpreting complex datasets to provide actionable insights to the business. This includes redesigning and rebuilding existing reports developing new analytical tools and supporting the data team in operational tasks. The DA works closely with data engineers business analysts and business stakeholders to ensure the successful delivery of reporting and analytics solutions.

The DA also supports the data governance and data quality strategies by maintaining artifacts such as data dictionaries lineage and business rules. This role requires a strong understanding of SQL Power BI and Microsoft Fabric along with the ability to adapt to new technologies and processes.

Internally the DA works closely with the Operations Department and other business users within BCCNM.

Externally the DA works with external stakeholders of the College which may include other consulting firms Health Regulators the Ministry of Health and other agencies or bodies in the health care industry.

Together with Data Team the work of the Data Analyst helps to promote organizational and operational effectiveness and promotes BCCNMs information governance by ensuring data accuracy quality and integrity.

Key Responsibilities include:

1. In consultation with the Manager Business Intelligence and Data contributes to and advocates for the management of data as a key strategic asset.
2. Work together with data engineers data analysts business analysts business SMEs records analysts and privacy analysts to understand data needs and create effective secure data workflows.
3. Participate in reporting requirements sessions with product owners data stewards and SMEs to gather and document business needs.
4. Contribute to design activities including identifying data attributes in source systems defining transformation rules and supporting data modeling efforts.
5. Collaborate with the data team to ensure the designed solutions align with the overall data architecture and business goals.
6. Support the design implementation and maintenance of data pipelines for data ingestion processing and transformation in Microsoft Azure Cloud.
7. Utilize Azure Data Factory SSIS or comparable technologies to create and maintain ETL (Extract Transform Load) operations.
8. Assist in creating and maintaining data storage solutions including Azure SQL Database Azure Data Lake and/or Azure Blob Storage.
9. Develop new reports and dashboards to meet business requirements ensuring they are optimized for performance usability and scalability.
10. Support the data team in operational tasks including monitoring and troubleshooting data pipelines and reports built in Power BI.
11. Assist in maintaining and updating Power BI workspaces roles and access permissions.
12. Collaborate with the data team to implement and enforce data governance policies.
13. Perform data quality checks build data quality dashboards and ensure data integrity across systems.
14. Document data processes report logic and data lineage.
15. Implement data validation and cleansing procedures to ensure the quality integrity and dependability of the data.
16. Monitor and resolve data pipeline problems to ensure consistency and availability of the data.
17. Identify opportunities to improve data processes reporting tools and analytical capabilities.
18. Stay updated on industry trends and best practices in data analysis and visualization.
19. Ensure compliance with data governance privacy and security policies.
20. Demonstrate a commitment to ongoing learning related to Indigenous cultural safety and humility to constructively disrupt Indigenous-specific racism in BCs healthcare system.
21. Foster and maintain an organizational culture that promotes equity diversity inclusion mutual respect teamwork and service excellence.

Your education & skills

• A bachelors degree in computer science Information Systems Data Analytics or another quantitative field plus relevant experience.
• Minimum 3 to 5 years of experience working with relational databases query authoring (SQL) and familiarity with a variety of databases.
• Proven experience in report development using Power BI SSRS and Excel.
• Advanced knowledge of SQL for data querying manipulation and analysis.
• Proficiency in Power BI (DAX data modeling visualization best practices) and experience in setting up and managing Power BI workspaces and access controls.
• Familiarity with data visualization best practices and design principles.
• Experience with ETL (Extract Transform Load) processes using Azure Data platform Microsoft Fabric or similar technologies.
• Knowledge of data warehouse and data mart design implementation and maintenance using Microsoft Azure Data Platform (e.g. Azure Synapse Azure SQL Database Azure Data Lake).
• Experience with Microsoft Dynamics 365 (D365) is considered a nice-to-have.
• Strong analytical skills related to working with structured and unstructured datasets.
• Experience performing root cause analysis on internal and external data to answer specific business questions and identify opportunities for improvement.
• A successful history of manipulating processing and extracting value from large disconnected datasets.
• Demonstrated knowledge and application of relevant legislation ethical and legal obligations and guidelines relating to privacy confidentiality and security of information.
• Experience supporting data governance and data quality initiatives including maintaining data dictionaries lineage and business rules.
• Excellent oral written and interpersonal communication skills. Ability to use audience-appropriate communication and language to present information analyze results and convey concepts.
• Ability to collaborate effectively with cross-functional teams including data engineers business analysts and business stakeholders.
• Ability to plan prioritize and manage workload within a time-sensitive environment.
• Ability to work outside of regular work hours on occasion to ensure the smooth functioning of related systems and deliverables.
• Knowledge of Canadian colonial impacts on Indigenous people in social and health contexts including social economic political and historical realities impacting Indigenous communities.
• Familiarity with Indigenous-specific anti-racism and accompanying reports (e.g. The Truth & Reconciliation Commissions 94 Calls to Action (2015) the In Plain Sight Report (2020) and Reclaiming Power and Places Calls for Justice (2019)) is an asset.
• Demonstrated understanding of equity diversity inclusion and cultural humility as they apply to healthcare is an asset.

How to Apply

If you are interested in this position please apply online by 11:59pm on July15 2025. This opportunity will remain posted until filled; however priority consideration will be given to those who apply by the deadline. To see a full list of our current opportunities or to learn more about working at the BC College of Nurses & Midwives please visit our website atCareers at BCCNM.

Collection Notice

To apply to a job posting you need to create an online account with BCCNM. To create an online account as well apply for a job posting youll be asked to provide personal information.

The BC College of Nurses and Midwives (BCCNM) collects your personal information for the purposes of creating your online account as well as for recruiting evaluating and selecting employees. The legal authority for collecting this information is under section 26 British Columbias Freedom of Information and Protection of Privacy Act. If you have any questions please contact .

Please note:BCCNM no longer requires staff contractors board and committee members and volunteers to provide an attestation of vaccination related to the Covid-19 pandemic.

In the event of a Public Health Order being issued the College is committed to full compliance with all directives and guidelines set forth by the Provincial Health Officer (PHO) to ensure the safety and well-being of our employees and the community partners we work with consistent with the duty of the College to serve and protect the public.