Software QA

Insight Global; Vancouver; On-site; CAD 90,000 - 120,000; Full time

Job summary

Insight Global is seeking an experienced Software QA Analyst to join our Data Platform and Governance Team in Vancouver, BC. You will specialize in Snowflake data warehousing, leading complex Snowflake testing initiatives to ensure data integrity and system reliability across the enterprise data platform.

You will design and execute test plans, perform functional/integration/regression testing, and collaborate with upstream/downstream QA teams while driving migration testing and automation

Qualifications

• 5+ years of software quality assurance experience.
• Expert-level SQL with complex queries and data comparisons.
• Experience with database migration testing and platform upgrades.
• Proficiency in Python and Shell for test automation.
• Strong cross-team communication.
• Experience with ETL/ELT testing and data pipeline validation.
• Familiarity with Azure and AWS; Power BI knowledge.
• Experience with Snowflake migrations and platform upgrades.

Responsibilities

• Design, develop, and execute test plans for Snowflake data pipelines.
• Perform functional, integration, and regression testing across Snowflake environments.
• Identify and track defects through resolution.
• Translate system requirements into testing strategies.
• Lead end-to-end Snowflake migration testing.
• Develop SQL scripts for data validation and quality assessment.
• Establish test data management for Snowflake environments.

Skills

SQL

Python

Shell scripting

ETL testing

CI/CD

QA methodologies

Azure

AWS

Power BI

JIRA

Snowflake testing

Data warehousing

Tools

TestRail

Job description

Job Description

Insight Global is seeking an experienced Software QA Analyst to join one of the largest Retail Clients in Vancouver BC. This person will be joining the Data Platform and Governance Team. We are seeking candidates with specialized expertise in Snowflake data warehousing. This role is critical to ensuring data integrity and system reliability across our enterprise data platform. The successful candidate will work collaboratively within a multi-tiered QA ecosystem, interfacing with upstream and downstream QA teams while leading complex Snowflake testing initiatives.

Principal Duties and Responsibilities

Design, develop, and execute comprehensive test plans and test cases for Snowflake-based data pipelines.

Perform functional, integration, and regression testing across multiple Snowflake environments.

Identify, document, and track defects through resolution using established defect management processes.

Collaborate with development teams to understand system requirements and translate them into effective testing strategies.

Provide quality-focused feedback on database schemas and data transformation logic.

Snowflake Migration Testing

Lead end-to-end testing efforts for Snowflake version migrations and platform upgrades.

Develop and maintain automated scripts to validate data consistency, schema integrity, and functional equivalence between Snowflake versions.

Create database comparison utilities to identify discrepancies in data, metadata, and performance characteristics.

Execute pre-migration, migration, and post-migration validation processes.

Document migration testing procedures and maintain testing artifacts for future upgrades.

Database Testing & Validation

Develop and maintain SQL scripts for data validation, comparison, and quality assessment.

Perform comprehensive database testing including data integrity checks, and referential integrity validation.

Establish and maintain test data management processes for Snowflake environments.

Testing Expertise

Solid understanding of software testing methodologies, SDLC, test design techniques, and QA best practices.

Experience with test management tools (JIRA, TestRail, or similar).

Knowledge of CI/CD processes and integration testing within DevOps environments.

Experience with automated testing frameworks and tools.

Understanding of data warehousing concepts.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf) .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Skills and Requirements

5+ years of experience in software quality assurance and a strong understanding of software testing methodologies

Expert-level SQL skills with proven ability to write complex queries, and database comparison scripts.

Strong experience in database migration testing including version upgrades and platform transitions.

Proficiency in scripting languages (Python, Shell scripting) for test automation.

Strong communication skills with ability to work effectively across multiple teams.

Experience with ETL/ELT testing and data pipeline validation.

Experience with Microsoft Azure and Amazon Basic understanding of PowerBI

Experience with testing snowflake migrations and platform upgrades

Familiarity with Salesforce is an advantage