Software QA

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.

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

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

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

• Solid understanding of software testing methodologies, SDLC, test design techniques, and QA best practices.
• Experience with test management tools (JIRA, Test Rail, or similar).
• Knowledge of CI/CD processes and integration testing within Dev Ops environments.
• Experience with automated testing frameworks and tools.
• Understanding of data warehousing concepts.

• 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 (). The EEOC "Know Your Rights" Poster is available here (https://(Use the "Apply for this Job" box below). Your Rights
6.).

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:  .