The Role
The Senior QA Engineer will design and execute testing strategies for reporting systems, data extracts, and business intelligence outputs. Responsibilities include writing and reviewing complex SQL, tracing data lineage across source systems and ETL pipelines, validating calculations and metrics, investigating discrepancies, documenting defects, and maintaining test documentation and version-controlled scripts. The role collaborates with data engineers, reporting teams, and business stakeholders to improve data quality and ensure accurate, reliable reporting.
Summary Generated by Built In
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.
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.
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.
Skills Required
- Strong experience writing, optimizing, and reviewing complex SQL queries
- Experience tracing data lineage from source systems through transformations to reporting layers
- Hands-on experience designing, documenting, and executing comprehensive test plans and test cases
- Experience validating data extracts, aggregations, calculations, and formatting against backend data sources
- Ability to investigate raw data, ETL pipelines, and SQL queries to identify root causes of discrepancies
- Experience debugging complex SQL queries
- Ability to identify edge cases, data anomalies, and potential reporting failures
- Experience using Git for SQL scripts, test code, documentation, branching, and pull requests
- Experience documenting, tracking, and reporting defects with reproduction steps and root-cause findings
- Ability to translate business requirements into testing criteria and validate reporting logic against business metrics
- Ability to document test cases, QA processes, validation results, and data dictionaries
- Proactive problem-solving and ability to independently investigate complex data-quality issues
- Strong communication and collaboration skills with data engineering, reporting, and business teams
- SaaS experience
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Newfire Global Partners is a technology and advisory firm founded in 2016. They specialize in software development, staff augmentation, and strategic advisory services, helping organizations navigate digital transformation. Their work spans high-impact industries, with a particular emphasis on digital healthcare, fintech, and cybersecurity. They focus on solving complex challenges through product-led thinking, business strategy, and the practical application of AI to drive measurable growth and operational success.
