QA Analyst - Intermediate

ICBC (Insurance Corporation of British Columbia); North Vancouver; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading insurance company is seeking an Intermediate Quality Assurance (QA) Analyst to join its Data Management team. The role involves assuring data quality within Big Data and Data Warehouse environments, utilizing tools like SQL and Python. Candidates should have 3-5 years of experience in software quality assurance and strong analytical skills. This position offers a hybrid work model with a competitive salary and comprehensive benefits.

Benefits

Competitive salary

Comprehensive benefits

Collaborative work environment

Qualifications

• 3-5 years of experience in software quality assurance, preferably in a data-focused or analytics environment.
• Strong analytical skills and attention to detail to identify data anomalies.
• Excellent communication skills to collaborate with cross-functional teams.

Responsibilities

• Create test plans, schedules and strategies; develop test scripts.
• Document test results, objectives, and status reports.
• Provide technical guidance and assist test teams.

Skills

SQL

Data validation

Test automation

Data governance

Object oriented programming

Agile methodology

Tools

Tableau

Hadoop

Spark

Python

PySpark

Job description

Overview

Overview

Join to apply for the QA Analyst - Intermediate role at ICBC (Insurance Corporation of British Columbia) .

We are seeking an Intermediate Quality Assurance (QA) Analyst to join our Data Management and Operations team in the 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 welcome applications from all qualified job seekers. If you require accommodations during the application or hiring process, please email [e-mail].

About ICBC

At ICBC, we strive to build diverse teams which reflect the communities we serve. 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.

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.

Responsibilities

• 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

Qualifications

• 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

Work Arrangements

• Hybrid : minimum of 8 days in a 4-week period at the primary office (typically 2 days per week); remaining days may be remote within British Columbia

Employment Details

• Seniority level : Mid-Senior level
• Employment type : Full-time
• Job function : Quality Assurance
• Industries : Insurance

We look forward to hearing from you!