Senior QA Engineer(BI focus)

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

About
Newfire Global Partners is a leading custom software development company that specializes in working on complex problems. With a strong focus on meeting the unique needs of each organization, they connect clients with local leaders and trusted remote teams to deliver exceptional IT services and software development solutions. Their range of expertise spans various domains, including Data & Analytics, AI/ML, Software Engineering, Product Management, and Marketing. By leveraging recent innovations in artificial intelligence, Newfire Global Partners ensures that their clients can transform the new normal into a competitive advantage. Through their advisory services, experienced leaders guide businesses through transformations and de-risk operations throughout the entire lifecycle. They also offer talent augmentation, bringing together highly skilled professionals from multi-disciplinary teams to support software, product, and marketing needs. Newfire Global Partners is committed to providing excellent service and driving client growth. Their team of industry experts works closely with organizations, whether it's driving transformation, building from scratch, or getting things done efficiently. Trusted by VC & PE firms, established businesses, and startups, Newfire Global Partners is proud to be a reliable partner in various industries, including healthcare, enterprise, and fintech. Partner with Newfire Global Partners today and unlock the expertise that accelerates success.