Data Analyst

BC Securities Commission; Vancouver; On-site; CAD 86,000 - 138,000; Full time

Benefits offered by this job

Pension plan

Medical & dental

Wellness benefits

Vacation 4 weeks

Downtown office

Work-life balance

Collaborative team

Job summary

BC Securities Commission in downtown Vancouver is seeking a full-time Data Analyst in the Technology and Projects Services (TAPS) Division to analyze, collect, prepare, store, and transform data for BI and analytics.

You will develop SQL queries, build Power BI dashboards, work with Azure data services and Microsoft Purview, ensure data governance, and collaborate with stakeholders to translate business needs into data solutions.

Qualifications

• Three years of experience with SQL and data analytics required.
• Experience with SQL Server tools (SSIS/SSRS) and Azure data services.
• Strong ability to communicate findings to technical and non-technical audiences.

Responsibilities

• Collect, clean, transform, and analyze data from multiple sources.
• Develop and maintain SQL queries, data models, and ETL/ELT pipelines.
• Create Power BI dashboards and data visualizations for decision-making.

Skills

SQL

Power BI

Data analytics

Python

R

Education

Bachelor's degree in Computer Science or MIS

Tools

SSIS

SSRS

Azure Synapse

Azure Data Factory

Azure SQL

Purview

Fabric

JSON

Job description

Centrally located in downtown Vancouver, the BC 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.

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:

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

Please visit our Careers page to submit your 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 must be authorized to work in Canada. Investment restrictions apply.