Newfire Global Partners
Quick Facts
- Work Policy: Fully remote (US)
- Job Type: Part Time (the application form describes the role as part-time and temporary)
- Salary Range: $103,853 – $145,650
- Department: Engineering
- Core Skills: Advanced SQL, data lineage, ETL validation, Git
About Newfire Global Partners
Newfire Global Partners is a custom software development firm that focuses on complex problems. It pairs clients with local leaders and remote teams for IT services and software development, with expertise in Data & Analytics, AI/ML, Software Engineering, Product Management, and Marketing. It also offers advisory services for transformations and risk reduction, plus talent augmentation from multidisciplinary teams, and serves VC and PE firms, established businesses, and startups in healthcare, enterprise, and fintech.
About the Project
Newfire builds software in digital healthcare, AI-driven analytics, and enterprise technology. It is working with a healthcare client on a unified clinical technology platform that will hold all clinical data and operations across the client’s lines of business, supporting care management, utilization management, and data-driven decisions. The Senior QA will help modernize and lead development of that platform.
What You’ll Do
- Design, develop, and run test plans to validate reporting systems, data extracts, and BI outputs
- Write, optimize, and peer-review complex SQL to verify 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 requirements
- Investigate discrepancies by analyzing datasets, SQL logic, and ETL pipelines to find root causes
- Identify edge cases, unusual data patterns, and risks to reporting quality
- Document and track defects with reproduction steps, findings, and fix recommendations
- Work with data engineers, reporting teams, and business stakeholders to clarify requirements and set validation criteria
- Maintain SQL scripts, test cases, and documentation in Git and standard version control practices
- Write and maintain documentation on test scenarios, QA procedures, validation results, and data definitions
- Proactively find ways to improve data quality, testing efficiency, and QA processes
- Own assigned testing work and make sure reporting deliverables are accurate and reliable
You’re a Perfect Match If You Have
- Advanced SQL skills, including writing, optimizing, and reviewing complex queries for accuracy, logic, and performance
- Data lineage analysis skills, tracing data from source systems through transformations to reporting layers
- Experience designing, documenting, and running test plans and test cases from scratch
- Experience validating data extracts, aggregations, calculations, and formatting against backend sources
- Root cause analysis skills for data discrepancies across raw data, ETL pipelines, and SQL
- Experience debugging complex SQL by breaking down logic and finding inconsistencies
- Edge case testing skills for non-obvious scenarios, anomalies, and failures that affect reporting
- Git experience, including branching and pull requests, for SQL scripts, test code, and documentation
- Defect management skills: documenting and tracking defects with reproduction steps, evidence, and root causes
- Ability to translate business requirements into testing criteria and validate reports against business definitions and KPIs
- Technical documentation skills for test cases, QA processes, results, and data dictionaries
- Ownership and problem-solving: spotting data quality risks, improving QA processes, and investigating issues independently
- Communication and collaboration skills with data engineering, reporting, and business teams
The Offer
- Market-driven total compensation, with a salary range of $103,853 to $145,650; final base pay depends on skills, expertise, and experience
- Newfire aims for consistent compensation practices across the organization
- Offers depend on a successful background screening, conducted in line with applicable law and only with the candidate’s consent
- Newfire is an equal opportunity employer and considers applicants without regard to protected characteristics
Hiring Process
The process has 11 stages: applied, shortlist, interview, review, technical interview, CSM interview, client interview, verbal offer, offer letter, background check, and hired. The application asks about your years of experience, US work authorization and any visa needs, your country of residence, and any referral.
To apply for this job please visit newfireglobal.pinpointhq.com.