ETL Quality Assurance Analyst

Who are we and why should you join us?

ConcertAI is building the future of precision medicine. We use advanced artificial intelligence and real-world data to transform how healthcare and life sciences generate evidence, make decisions, and improve patient outcomes—starting in oncology and rapidly expanding across therapeutic areas. Our teams partner with the world’s leading pharmaceutical companies, providers, and research organizations to solve some of healthcare’s most complex challenges.

At the core of our innovation is Cara, our next-generation AI platform that unlocks powerful insights from complex clinical, imaging, and molecular data. Combined with our Precision Suite—which unifies real-world data, advanced analytics, and scalable evidence generation—these solutions are transforming how clinical development, regulatory, and commercialization decisions are made.

ConcertAI brings together a portfolio of purpose-built solutions, including TeraRecon, an industry leader in advanced imaging and AI-driven visualization, and CancerLinQ, the ASCO-originated oncology platform advancing care quality and large-scale discovery.

Joining ConcertAI means working alongside bold thinkers, builders, and healthcare experts on innovative, high-impact products that directly improve patient lives. You’ll be part of a fast-growing, mission-driven organization at the forefront of AI-enabled healthcare, with meaningful opportunities for growth and leadership.

Role Summary

We are hiring QA Analysts to support end-to-end testing of healthcare data pipeline projects. This is a hands-on technical QA role focused on validating data movement from inbound files through staging databases, Cloud Publish, Data Aggregation, outbound files, and Analytics Database loads.

This role is not UI testing. It is focused on SQL, file validation, data reconciliation, test data creation, and technical data quality validation.

Key Responsibilities

• Review inbound layouts, outbound layouts, requirements, mappings, and data lineage.
• Create technical QA test cases for file ingestion, database validation, transformations, reconciliation, and outbound file testing.
• Design positive, negative, edge-case, duplicate, reload/resend, and regression test scenarios.
• Create synthetic test data and inbound files for controlled QA validation.
• Validate data across SPARQ, DI, Cloud Publish, Data Aggregation, mastering tables, outbound files, and Analytics DB.
• Write and execute SQL queries to compare source files, staging tables, intermediate tables, outbound files, and expected results.
• Identify missing records, duplicate records, transformation issues, null/default handling issues, and count mismatches.
• Log clear defects in Jira and support triage with QA, BA, PM, development, and data teams.
• Retest fixes and help identify reusable validation checks for post-production regression.
• Support automation of data validation and reconciliation using AWS Glue, SQL, or similar tools.
• Use AI tools such as ChatGPT or Claude Code where appropriate to draft test cases, test data, SQL, or scripts, with QA review before use.

Required Skills

• Strong SQL skills.
• Experience testing ETL, data pipelines, databases, data warehouses, or data feeds.
• Experience validating CSV, TXT, delimited, fixed-width, or extract files.
• Ability to compare inbound files, database tables, outbound files, and expected results.
• Experience creating test cases from requirements, layouts, mappings, or source-to-target documents.
• Strong understanding of positive, negative, edge-case, regression, and end-to-end testing.
• Experience with Jira or similar defect tracking tools.
• Strong analytical skills and attention to detail.
• Ability to work with PMs, BAs, developers, QA, data analysts, and vendor-facing teams.
• Clear written communication for documenting defects, test results, and risks.

Preferred Skills

• Healthcare data testing experience.
• Experience working with PHI, de-identified data, or healthcare compliance constraints.
• AWS Glue, PySpark, SQL Developer, GitHub, or cloud data platform experience.
• Experience with data lineage, source-to-target mapping, transformation validation, and reconciliation.
• Experience testing de-duplication, matching logic, mastering, survivorship rules, or entity resolution.
• Experience creating synthetic test data and reusable regression checks.

Success Criteria

A successful candidate can turn requirements and layouts into strong technical test cases, create controlled test data, validate data directly across multiple database stages, identify root causes of data issues, support end-to-end inbound-to-outbound testing, and produce clear QA evidence for technical validation signoff.

Learn More About ConcertAI

Our team at ConcertAI is dedicated to transforming healthcare decision-making through the application of RWE and AI to improve patient outcomes. We work in a fast-paced, dynamic, high-performing culture where diversity, collaboration, and innovation are valued. Join us on our quest to create a world free of disease. Learn more about ConcertAI at www.concertai.com , or follow us on LinkedIn. Serving 1,300 clinical sites globally, TeraRecon - a ConcertAI company - is a Best in KLAS solution provider for AI-empowered radiology, oncology, cardiology, neurology, and vascular surgery. In the future, the combination with ConcertAI could bring a single, advanced AI-augmented diagnosis and interpretation capability from clinical trials to patient care. 

EEO & ADA Statement

ConcertAI provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. We are dedicated to providing reasonable accommodations throughout the application and hiring process, as well as during employment, in accordance with applicable federal, state, and local laws. Requests for accommodation will be handled confidentially and in accordance with applicable law.