Data Analyst

BCSC Inquiries Group; Vancouver; Hybrid; CAD 86,000 - 138,000; Full time

Benefits offered by this job

Defined benefit pension plan

Medical and dental coverage

Wellness and Health Spending Account

4 weeks of annual vacation

Job summary

The British Columbia Securities Commission (BCSC) in downtown Vancouver is seeking a Data Analyst to join the Technology and Projects Services division as a full-time, permanent role.

The successful candidate will analyze, prepare, and model data, develop dashboards, and support BI initiatives using SQL, Power BI, Python/R, and Azure cloud services. Collaboration across teams is essential.

Qualifications

• 3+ years of experience with SQL and data analytics.
• Strong SQL, data modeling, and reporting skills.
• Experience with BI dashboards and data governance.

Responsibilities

• Collect, clean, transform, and analyze data to support reporting.
• Develop and optimize SQL queries, stored procedures, and data models.
• Create Power BI dashboards and reports with clear visuals.
• Work with Azure cloud services for data processing and automation.
• Apply data governance using Microsoft Purview.
• Ensure data classification, lineage, and security.
• Integrate data with Microsoft Fabric for ETL/ELT workflows.
• Develop ETL/ELT pipelines using SSIS, Synapse, ADF.
• Perform statistical analysis in Python or R as needed.
• Troubleshoot database performance and data quality issues.
• Collaborate with stakeholders to translate business needs into data solutions.
• Present findings to technical and non-technical audiences.

Skills

SQL

Power BI

Python

R

Data analysis

Communication

Education

Bachelor's degree in CS/MIS

Tools

SQL Server

SSIS

SSRS

Azure Synapse

Azure Data Factory

Microsoft Purview

Microsoft Fabric

Power Query

Job description

Employment Duration Permanent - Full Time

Centrally located in downtown Vancouver, the British Columbia Securities Commission (BCSC) strives to make the investment markets benefit the public – enabling people to achieve their financial goals, enterprises to grow, and British Columbia to thrive.

Through smart rules, diligent oversight, strong enforcement and reliable guidance, we act as guardians of the province’s investment marketplace, striving to make BC a place where people can invest with confidence and companies can flourish. We are an independent agency accountable to the provincial legislature and the public through the Minister of Finance.

Data Analyst

Technology and Projects Services

(Competition 26:31)

Position Overview

BCSC is currently seeking a full-time innovative, technically advanced, and detail-orientated Data Analyst 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 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 Information 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 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

• 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
• Beautiful downtown office
• Work life balance
• A professional and collaborative team to work with!

Salary Range

The salary range for this position is $ 86,097 (minimum) - $ 111.814 (midpoint) - $ 137,531 (maximum).

The starting salary for this position will bedeterminedconsidering 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.

Please visit our Careers page tosubmityour cover letter and resume for this position, quoting competition 26:31 by September 11, 2026.

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 mustbe authorized towork in Canada.Investment restrictions apply.