Data Analyst

British Columbia Securities Commission; Vancouver; Hybrid; CAD 83,000 - 135,000; Full time

Job summary

Join the British Columbia Securities Commission as a Data Analyst for a temporary role in the Technology and Projects Services division. This position involves collecting and analyzing data from multiple sources, creating user dashboards, and supporting business intelligence initiatives. The ideal candidate will have a degree in Computer Science, at least 3 years of relevant experience, and expertise in SQL, Power BI, Azure tools, and data governance. Enjoy a rewarding work environment with a comprehensive benefits package and a hybrid work model.

Benefits

Extensive benefit package including pension plan

Medical and dental coverage

Wellness and Health Spending Account

4 weeks of annual vacation

Professional development opportunities

Qualifications

• Minimum of 3 years experience with SQL and data analytics.
• Hands-on experience with Power BI, Azure cloud analytics tools, and data transformation.
• Strong verbal and written communication skills.

Responsibilities

• Collect, clean, transform, and analyze data from multiple sources.
• Develop and maintain SQL queries and data models.
• Create and optimize Power BI dashboards and reports.

Skills

Data Analysis

SQL

Business Intelligence

Data Visualization

Statistical Computing

Education

Technical diploma or university degree in Computer Science

Tools

Power BI

Azure

SQL Server

Microsoft Purview

Microsoft Fabric

Job description

Data Analyst

Technology and Projects Services

Temporary Term – End Date March 31, 2026

(Competition 25:16)

Position Overview:

BCSC is currently seeking a temporary, full-time, innovative, technically advanced and detail orientated Data Analyst and to join our dynamic team in our Technology and Projects Services (TAPS) Division.

The Data Analyst is a technology expert who specializes in analyzing, collecting, preparing, storing and creating electronic data. The successful candidate will participate in all day-to-day data support functions including: Business Intelligence (BI) support, governance, ad-hoc reporting requests, developing user dashboards, and in projects. In addition, you will work with internal and external data sources for the purpose of analyzing, cleaning, answering questions on results of analysis, and preparing data based on defined use cases to be used in advanced analytics. .

Key responsibilities:

• Collect, clean, transform, and analyze data from multiple sources to support business reporting and decision-making.

• Develop and maintain complex SQL queries, stored procedures, and data models for analytics and reporting purposes.

• Create and optimize Power BI dashboards, reports, and data visualizations to present meaningful insights and support BI tools and platforms, ensuring data accuracy, integrity, and accessibility.

• Work with Azure cloud services and advanced analytics tools for data processing and automation.

• Implement and maintain data management policies using Microsoft Purview.

• Ensure proper data classification, lineage, and security through governance best practices.

• Utilize Microsoft Fabric for data integration, transformation, and orchestration.

• Develop and maintain ETL and ELT pipelines using SQL Server Integration Services (SSIS), Azure Synapse, Azure Data Factory, and other tools.

• Perform statistical analysis using Python, R, or other programming languages as needed.

• Troubleshoot and optimize database performance, ensuring efficient data processing.

• Collaborate with stakeholders to understand business requirements and translate them into data solutions.

• Communicate complex technical solutions to non-technical audiences.

• Partner with the Economic Analysis Data Science and TAPS Operations and Data Management teams to drive data related initiatives.

Qualifications:

• A technical diploma or university degree in Computer Science, Management Information Systems, or similar field and a minimum of 3 years of experience working with SQL and data analytics required. An equivalent combination of education and experience is considered.

• Hands on experience and working knowledge of the following systems, tools and platforms is preferred:

  • T-SQL programming and JSON

  • Power Query and Power BI

  • SQL Server, including SSIS, SSAS and SSRS as well as Azure cloud analytics tools (e.g., Azure Synapse, Azure Data Factory, Azure SQL).

  • Microsoft Purview and Microsoft Fabric

• Experience supporting data governance and data quality initiatives, including maintaining data dictionaries, lineage, and business rules and demonstrated expertise in ELT and ETL principles, including data transformation and pipeline optimization.

• Sound understanding of statistical computing programming languages (R, Python), data modeling, data warehousing, and data mining techniques.

• Strong analytics skills, with a proven ability to solve logical challenges and synthesize data to develop meaningful insight.

• Excellent verbal and written communication skills, with the ability to present findings to both technical and non-technical audiences.

• Able to drive results, meet deadlines, and prioritize tasks with minimal supervision.

What we offer:

We offer a challenging and rewarding work environment which includes:

• Extensive benefit package including a defined benefit pension plan, medical and dental coverage, Wellness and Health Spending Account benefits, and 4 weeks of annual vacation

• Hybrid work model

• Beautiful downtown office

• Work life balance

• Professional development opportunities

• A professional and collaborative team to work with!

Salary Range:

The annual salary range for this position is $83,997 (minimum) - $109,087 (midpoint) - $134,177 (maximum).

The starting salary for this position will be determined considering the successful candidate’s relevant experience and education, salaries of other employees in the same salary range, market conditions and other relevant factors. Starting salaries are normally below the salary band midpoint .

Application Details:

This temporary, full time position is on a fixed term with an end date of March 31, 2026.

Please visit our Careers page to submit your cover letter and resume for this position, quoting competition 25:16 by June 23, 2025.

The BC Securities Commission embraces diversity and is committed to building an inclusive workforce that celebrates the richness of our community. We aim to ensure every job applicant is treated fairly and with respect and encourage applications from all candidates, including those with diverse abilities. We welcome you to inform us in confidence by emailing [e-mail] if you may require any support or accommodations during the application process, including disability accommodation, in order to participate fully in our recruitment experience.

Candidates must be authorized to work in Canada. Investment restrictions apply.