QA Analyst

Insurance Corporation of British Columbia; Vancouver; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

A leading insurance company in Vancouver is seeking an Intermediate Quality Assurance Analyst to ensure data accuracy in Big Data environments. You'll develop test plans and validate data quality with tools like SQL and Python, collaborating in a hybrid work setting. Ideal candidates have 3-5 years in QA with strong analytical skills and a focus on data-driven solutions.

Benefits

Competitive salary

Comprehensive benefits

Collaborative work environment

Qualifications

• 3-5 years of experience in software quality assurance, preferably in a data-focused environment.
• Strong knowledge of SQL for complex queries and data reconciliation.
• Hands-on experience with testing data pipelines and ETL processes.
• Ability to design and execute test plans and regression suites for data validation.
• Familiarity with data warehouses and large datasets.

Responsibilities

• Create test plans, schedules, and strategies.
• Understand system architecture and perform intermediate-level testing.
• Document test results and provide guidance to teams.
• Communicate requirements and defects to stakeholders.
• Conduct walkthroughs of test artifacts.

Tools

SQL

Python

Hadoop

Spark

Tableau

Scala

PySpark

Job description

Overview

We are seeking an Intermediate Quality Assurance (QA) Analyst to join our Data Management and Operations team in Information Management department. You will play a key role in ensuring data accuracy and quality within our Big Data and Data Warehouse environments. Our team leverages Scala, SQL, Tableau, StreamSets, Hadoop, and Spark to deliver trusted data solutions across the organization.

We look forward to hearing from you

Accessibility and inclusion: We welcome applications from all qualified job seekers. If you require accommodations, including alternative interview formats, assistance with online assessments, or an ASL interpreter, please email your request to – we are committed to ensuring an accessible experience for all candidates.

Accountabilities

• Creating test plans, schedules and strategies; developing test scripts and test data requirements; use modern test tools to execute tests
• Understanding of system architecture, test automation and performance testing at an intermediate level
• Document test results, objectives, data sets and status reports
• Provide technical guidance and assistance to test teams
• Clearly communicate business requirements and defects to stakeholders
• Conduct walkthrough of test artifacts to various stakeholders
• Create and execute automated acceptance tests leveraging appropriate tools.

Position Requirements

To make an immediate contribution in this role, you will bring demonstrated experience in the above mentioned activities, as well as :

• 3-5 years of experience in software quality assurance, preferably in a data-focused or analytics environment.
• Strong knowledge of SQL (writing complex queries, validating datasets, performing joins, aggregations, and data reconciliation).
• Hands-on experience with testing data pipelines, ETL processes, and reporting systems.
• Ability to design and execute test plans, test cases, and regression suites for data validation and functional testing.
• Familiarity with data warehouses, relational databases, and large datasets.
• Experience with test automation for data validation (e.g., Python, PySpark, or automation frameworks is an asset).
• Understanding of data governance, data quality, and controls in financial or enterprise reporting contexts.
• Strong analytical skills and attention to detail to identify data anomalies, inconsistencies, and edge cases.
• Excellent communication skills to collaborate with business analysts, data engineers, and visualization / reporting teams.
• Experience with Agile / Scrum methodology and working in cross-functional teams
• Understanding of object oriented programming such as Java, Scala, Python.
• Knowledge of AWS will be an asset.

About us

At ICBC, it is our job to make sure the car insurance system works for all British Columbians, today and in the future. A career at ICBC is an opportunity to be part of a talented, diverse and inclusive team that is driven to serve its customers and community. You can expect a competitive salary, comprehensive benefits and a collaborative work environment. If you are reliable and dependable, contact us today to be part of our talented and diverse team as we work together to create an insurance system we can all be proud of.

Our values guide how we interact with customers, partners, and each other. They shape our decisions and create a culture where employees feel inspired and empowered to do their best work.

• Collaborative : We include different perspectives to reach our common goals.
• Supportive : We seek to understand to meet diverse and evolving needs.
• Straightforward : We simplify the complex to make things easier.
• Knowledgeable : We gain knowledge through experience and learning to make informed decisions.

Work arrangements

• Hybrid 8 – you will work a minimum of 8 days in a 4-week period at your primary office headquarters (typically 2 days per week). The remaining days will be remote within British Columbia.

IND1