QA Analyst

We look forward to hearing from you

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.

Accountabilities will include:

- 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’s our job to make sure the car insurance system works for all British Columbians, today and in the future. 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 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