QA Analyst - Intermediate

ICBC (Insurance Corporation of British Columbia); North Vancouver; Híbrido; CAD 84.000 - 91.000; Jornada completa

Descripción de la vacante

ICBC Information Services Division is seeking an Intermediate QA Analyst to join the Information Management - Customer team in North Vancouver. You will perform data quality testing on data pipelines and enhance automated testing solutions using a mix of testing approaches and technologies to ensure ICBC's data products meet quality standards.

The role uses Apache Spark, Scala, SQL, and Tableau for data preparation, transformation, and reporting.

Formación

• 3-5 years of hands-on experience in software testing, data engineering, or analytics.
• Strong SQL and database skills, especially with Big Data and AWS.
• Experience with AWS cloud data pipelines and data quality testing.
• Knowledge of Python/Scala/Java and data visualization tools.

Responsabilidades

• Create manual & automated test plans, schedules and strategies; develop test scripts and data requirements; use modern test tools to run validation (integration, performance, regression).
• Document test results, objectives, data sets and status reports.
• Provide technical guidance and assistance to team members.
• Clearly communicate business requirements and defects to stakeholders.
• Conduct walkthrough of test results to data engineers and stakeholders.
• Create and execute automated acceptance tests leveraging appropriate tools.

Conocimientos

SQL Skills

OO Languages

Automation Testing

Big Data AWS

Agile

Herramientas

Apache Spark

Tableau

AWS QuickSight

Jenkins

MAPR Hadoop

StreamSets

Descripción del empleo

Reference Number: 5367

Posted Date: Nov 11, 2026

Employment Type: Permanent Full Time

Hours of Work: 7.5 hours per day - 5 day week (M-F)

Work Arrangement: Hybrid 8

Salary Range: $84193.20 - $90945.40 Annually

Location: North Vancouver, British Columbia, Canada

We welcome applications from all qualified job seekers. Should you require any accommodations, including alternative interview formats, assistance with online assessments, or an ASL interpreter, throughout the application or hiring process, please email your request to [e-mail] – we are committed to ensuring an accessible experience for all candidates.

At ICBC, we strive to build diverse teams which reflect the communities we serve. To support this, we’ve created two talent communities for Indigenous Peoples and People with Disabilities. By joining one of these communities, you’ll connect with our recruitment team who will guide you through the application process and help you explore opportunities at ICBC. Of course, you’re welcome to apply for jobs at ICBC whether or not you join a talent community.

We look forward to hearing from you!

Information Services Division is currently looking for QA Analyst - Intermediate to join our Information Management - Customer team. In this role, you will be responsible for performing data quality tests on developed data pipelines, along with maintaining and enhancing automated testing solutions using a mix of testing approaches and technologies to ensure the quality of ICBC’s various data products.

We use Apache Spark, Scala and SQL to perform “Data Preparation & transformation” and Tableau to create self-service reports & data visualizations. The team is using the latest Big Data technologies such as MAPR Hadoop, Scala, Apache Spark, Streamsets, Jenkins, Tableau and AWS big data technologies (Glue, S3, Lambda, Step Functions, Data Zone, QuickSight).

Specifically, You Will

• Create manual & automated test plans, schedules and strategies; developing test scripts and test data requirements; use modern test tools to execute validation techniques such as integration, performance and regression test cases.
• Document test results, objectives, data sets and status reports.
• Provide technical guidance and assistance to team members.
• Clearly communicate business requirements and defects to stakeholders.
• Conduct walkthrough of test results to data engineers and business stakeholders.
• Create and execute automated acceptance tests leveraging appropriate tools.

Position Requirements

This position will require someone who has 3-5 years of relevant hands-on experience in the domain of software testing, Data Engineering, Data Analytics, or a combination of relevant post-secondary education and related business experience.

The Ideal Candidate Will Possess The Following Qualifications

• Strong Database & SQL skills preferably in Big Data and AWS
• Understanding of object-oriented programming such as Python, Scala, or Java.
• Working experience in building complex SQL queries.
• Familiarity with Tableau, AWS Quicksight and/or similar data visualization tools.
• Understanding of Agile methodologies.
• Ability to design and create test cases that can be used for automation utilizing Big Data technologies.
• Demonstrated experience of creating and executing manual test cases as well as exploratory functional testing.
• Experience testing functional/non-functional requirements.
• Experience performing production support including incident, problem and change management.
• Effective written and oral communication skills.
• Ability to work without supervision and in a cross-functional team environment.
• Good communication, interpersonal, time management and collaboration skills.
• Ability to plan, prioritize and complete multiple concurrent tasks in an environment of changing deadlines, priorities and requirements.
• Demonstrated critical thinking, problem solving and learning agility.
• Hands-on experience testing AWS cloud-based data pipelines and services, including data quality, integration, regression and performance testing.

About Us

At ICBC, it’s our job to make sure the car insurance system works for all British Columbians, today and in the future. Check out our ICBC Year in Review 2025 to learn more about what we've accomplished! If you want to make the most of your skills and expertise while growing your career, we want you. 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 Defined

• Hybrid 8 – you will work a minimum of 2 days per week at your primary office headquarters, subject to operational requirements. The remaining days will be remote within British Columbia.

Only candidates legally entitled to work in Canada will be considered for this position.

Job Segment: Testing, Cloud, Database, Quality Assurance, SQL, Technology