Newfire Global Partners is a leading technology firm that specializes in building transformative software solutions for some of the world’s most innovative companies. With a presence across four continents, Newfire Global brings deep expertise in digital healthcare, AI-driven analytics, and enterprise technology. The firm’s track record of delivering scalable, high-impact solutions has made it a trusted partner for organizations seeking to drive meaningful change through technology.We are passionate about the purpose-driven mission to help improve the quality of care for patients and are building a collaborative, innovative, and inclusive culture. We are a fully funded company founded by serial entrepreneurs with a stable client base. Opportunity for impact Newfire Global Partners, a leader in developing disruptive healthcare technology, collaborates with Fortune 500 companies and start-ups to drive transformation. Newfire is seeking a Senior QA with SaaS experience to drive the modernization and spearhead the development of a unified, next-generation clinical technology platform for a current healthcare client. This new platform will serve as the foundation for all clinical data and operations across every line of business. By creating a robust and innovative solution, this leader will enable enhanced care management, utilization management, and data-driven decision-making—ultimately working to improve healthcare outcomes for millions of Americans. Role & responsibilities The Senior QA on this transformative project is responsible for building and leading a team of collaborative In this role, you'll be responsible for designing and executing comprehensive data validation strategies, investigating discrepancies, and ensuring that reports and data extracts accurately reflect underlying business data and requirements. You'll work closely with technical and business stakeholders to translate complex requirements into effective testing approaches. • 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 Newfire Global is committed to consistent compensation practices across our organization. Total compensation for this role is market driven, with a salary of $103,853 - $145.650. Base pay is ultimately determined based on a candidate's skills, expertise, and experience. Offers are contingent upon successful completion of a background screening. Background screenings will be conducted in compliance with applicable laws and will not be initiated without your consent. Newfire Global is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law. Originally posted on Himalayas