Senior QA Engineer

Role & responsibilities

• Design, develop, and execute comprehensive test plans to validate reporting systems, data extracts, and business intelligence outputs.
• Write, optimize, and peer-review complex SQL queries to verify data accuracy, transformations, and reporting logic.
• Trace data lineage across source systems, ETL processes, and reporting layers to identify inconsistencies and ensure data integrity.
• Validate calculations, aggregations, formatting, and business metrics against backend data and established requirements.
• Investigate data discrepancies by analyzing raw datasets, SQL logic, and ETL pipelines to identify root causes.
• Identify edge cases, unexpected data patterns, and potential risks that could affect reporting quality.
• Document and track defects, providing clear reproduction steps, technical findings, and recommendations for resolution.
• Collaborate with data engineers, reporting teams, and business stakeholders to clarify requirements and establish effective validation criteria.
• Maintain SQL scripts, test cases, and technical documentation using Git and established version control practices.
• Develop and maintain documentation covering test scenarios, QA procedures, validation results, and data definitions.
• Proactively identify opportunities to improve data quality, testing efficiency, and overall QA processes.
• Take ownership of assigned testing activities, ensuring accurate and reliable reporting deliverables.
  
  

You’re a Perfect Match If You Have:

• Advanced SQL & Code Review: Strong experience writing, optimizing, and reviewing complex SQL queries to ensure data accuracy, logical correctness, and performance.
• Data Lineage Analysis: Proven ability to trace data from source systems through transformation processes to reporting layers, ensuring consistency and integrity.
• Test Design & Execution: Hands-on experience designing, documenting, and executing comprehensive test plans and test cases from scratch.
• Data Validation: Strong experience validating data extracts, aggregations, calculations, and formatting against backend data sources.
• Root Cause Analysis: Ability to investigate raw data, ETL pipelines, and SQL queries to identify the underlying causes of data discrepancies and recommend effective solutions.
• Complex Query Debugging: Experience isolating issues in complex SQL queries by breaking down logic and identifying inconsistencies.
• Edge Case Testing: Ability to identify non-obvious scenarios, data anomalies, and potential failures that may affect reporting accuracy.
• Version Control: Experience using Git to manage SQL scripts, test code, and technical documentation, including branching and pull requests.
• Defect Management: Experience documenting, tracking, and reporting defects with clear reproduction steps, supporting evidence, and root cause findings.
• Business Requirements & Metrics: Ability to translate business requirements into actionable testing criteria and validate reporting logic against established business definitions and KPIs.
• Technical Documentation: Strong ability to document test cases, QA processes, validation results, and data dictionaries for technical and business stakeholders.
• Ownership & Problem-Solving: Proactive approach to identifying data quality risks, improving QA processes, and independently investigating complex issues.
• Communication & Collaboration: Strong communication skills and the ability to work effectively with data engineering, reporting, and business teams.
  
  

The Offer