Data Specialist

Alberta Securities Commission; Calgary; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

The Alberta Securities Commission is seeking a Data Specialist to support data management and analytics within their ARKM division. The role involves working closely with data teams, ensuring data quality, and automating processes. Ideal candidates will have significant experience in SQL and Python, coupled with a relevant degree. This hybrid position offers a competitive benefits package and promotes a diverse and inclusive work culture.

Benefits

100% employer-paid benefits

Comprehensive health and dental

Professional development allowances

Flexible spending account

Employee family assistance program

Qualifications

• Six years of experience collecting, cleansing and preparing data.
• Ongoing education in preparing datasets and automating processes.
• Expertise with SQL databases and DataOps methodology.

Responsibilities

• Profiling and monitoring data quality metrics.
• Gathering, transforming, and cleansing datasets.
• Automating and optimizing data processes.

Skills

Data Management

SQL

Python

Data Cleansing

Data Automation

Education

Undergraduate degree in computer sciences or engineering or a quantitative field

Tools

Git

Job description

The Alberta Securities Commission (ASC) is the industry-funded regulator responsible for administering the province's securities laws. It is entrusted with fostering a fair and efficient capital market in Alberta and with protecting investors. As a member of the Canadian Securities Administrators, the ASC works to improve, coordinate and harmonize the regulation of Canada's capital markets.

The Advanced Research and Knowledge Management (ARKM) division leads a data and analytics program that supports data-driven, evidence-based, policy, operational, and business decisions. ARKM also leads the development of an education and training program that is unique to the ASC, focused on the skills and knowledge needed in a securities regulatory environment. It also serves as an expert internal resource for updates, research, and analysis on existing, increasing and emerging risks that require regulatory responses, and considers the impact of innovation in capital markets through technology testing.

The opportunity

Reporting to the Manager, Data and Analytics, the Data Specialist will work closely with data scientists, data analysts, and other ASC colleagues to understand the requirements for the datasets being prepared. You will provide support in the areas of data acquisition and management of data assets. You will have the opportunity to design and optimize databases for use within the data and analytics team, measure and report on data quality, create and automate ETL processes, and document your work. There is also an opportunity to prototype and automate data solutions for other divisions.

Key Responsibilities Include

• Profiling data by measuring and monitoring and preparing metrics.
• Preparing datasets by gathering and combining, transforming and cleansing, and creating databases or file storage.
• Automating and optimizing data related processes.
• Documenting data and data processes.
• Participating in CSA and Heads of Agencies (HOA) groups.
• Acting as a local steward for national systems, supporting governance programs.
  
  

The ideal candidate will possess

• An undergraduate degree in computer sciences or engineering, or a quantitative field.
• Six years of experience collecting, cleansing and preparing data for use by others.
• Ongoing education in preparing datasets and automating processes to maintain data.
• Expertise with SQL databases, including schema design and optimization and automating data flows.
• Experience developing reliable, well-documented tools and processes in Python, Git for version control and DataOps methodology
  
  

To apply

Click the Apply For This Job Online button to submit your resume, cover letter and salary expectations by June 16, 2025. This position will work out of the ASC office located in Calgary, Alberta. You will be contacted if you are selected for an interview. More information about working at the ASC including our comprehensive Total Rewards package can be found on our website at www.asc.ca.

We offer a hybrid work environment and flexibility, a competitive total rewards package consisting of 100 per cent employer-paid benefits, comprehensive health and dental, employee life insurance, short-term and long-term disability; retirement benefits; travel insurance; paid vacation time, flex and sick days; an employee family assistance program; transportation allowance, generous flexible spending account and professional development through subsidized courses, conference, workshops, seminars and in-house training. We also encourage fun and giving back to the community with initiatives offered through our ASC Social Club and annual United Way Campaign.

The ASC is an equal opportunity employer and encourages applications from all qualified individuals. We celebrate diversity and are committed to providing an inclusive work environment where every employee feels valued and respected.