Senior QA Engineer

This is a fully remote position, open to applicants in Massachusetts.

📋 Description

• Build and manage a collaborative team.

• Design, develop, and implement test plans for reporting systems, data extracts, and business intelligence outputs.

• Write, optimize, and conduct peer reviews of complex SQL queries to ensure data accuracy, transformations, and reporting logic.

• Trace data lineage across source systems, ETL processes, and reporting layers.

• Validate calculations, aggregations, formatting, and business metrics against backend data and specified requirements.

• Investigate data discrepancies by analyzing raw datasets, SQL logic, and ETL pipelines.

• Identify edge cases, unexpected data patterns, and risks that may impact reporting quality.

• Document and track defects, including reproduction steps, technical findings, and recommendations for resolution.

• Collaborate with data engineers, reporting teams, and business stakeholders to clarify requirements and validation criteria.

• Maintain SQL scripts, test cases, and technical documentation utilizing Git and version control practices.

• Develop documentation that encompasses test scenarios, QA procedures, validation results, and data definitions.

• Enhance data quality, testing efficiency, and QA processes.

• Take ownership of assigned testing activities to ensure dependable reporting deliverables.

• Report directly to Jakub Chabik.

⛳️ Requirements

• Experience in SaaS environments.

• Advanced proficiency in writing, optimizing, and conducting peer reviews of complex SQL queries.

• Demonstrated ability to trace data lineage from source systems through ETL processes to reporting layers.

• Practical experience in designing, documenting, and executing comprehensive test plans and test cases from the ground up.

• Experience in validating data extracts, aggregations, calculations, and formatting against backend data sources.

• Ability to investigate raw data, ETL pipelines, and SQL queries to determine the root causes of discrepancies.

• Experience in debugging complex SQL queries.

• Ability to identify edge cases, data anomalies, and potential failures in reporting.

• Familiarity with using Git, including branching and pull requests, to manage SQL scripts, test code, and technical documentation.

• Experience in documenting, tracking, and reporting defects with clear reproduction steps and supporting evidence.

• Ability to translate business requirements into testing criteria and validate reporting logic against business definitions and KPIs.

• Capacity to document test cases, QA processes, validation results, and data dictionaries.

• Strong communication and collaboration skills with data engineering, reporting, and business teams.

🏝️ Benefits

• Base salary ranging from $103,853 to $145,650 (the posting's compensation fields indicate $103.85 - $145.65 per year).

• Offers contingent upon the successful completion of a background screening, conducted with consent and in compliance with applicable laws.

• Equal Employment Opportunity employer.