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. The EEOC "Know Your Rights" Poster is available
here.
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/ .
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
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.