Software QA

Insight Global; Vancouver; On-site; CAD 80,000 - 100,000; Full time

Job summary

A prominent staffing agency in Vancouver seeks an experienced Software QA Analyst to join a retail client's Data Platform and Governance Team. The ideal candidate will have expertise in Snowflake, strong SQL skills, and a focus on database migration testing. Responsibilities include leading testing initiatives and collaborating with development teams to ensure data integrity across platforms. This role emphasizes quality assurance within a multi-tiered QA ecosystem.

Qualifications

• 5+ years of experience in software quality assurance.
• Strong understanding of software testing methodologies.
• Experience with database migration testing and version upgrades.

Responsibilities

• Design and execute test plans for Snowflake data pipelines.
• Lead end-to-end testing for Snowflake version migrations.
• Develop SQL scripts for data validation.

Skills

Software testing methodologies

Expert-level SQL skills

Database migration testing

Scripting languages (Python, Shell)

Communication skills

ETL/ELT testing

Experience with Snowflake

Tools

JIRA

TestRail

Microsoft Azure

Amazon

PowerBI

Salesforce

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.

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

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/ .