Senior ETL Quality Assurance Engineer

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.

Responsibilities

• Lead end-to-end testing of ETL and data pipelines across multiple processing stages.
• Review requirements, file layouts, data dictionaries, mappings, transformation rules, and data lineage.
• Develop test strategies, test cases, validation queries, and traceable QA evidence.
• Perform source-to-target, file-to-table, table-to-table, and table-to-file reconciliation.
• Validate record counts, field-level values, aggregates, calculations, transformations, filtering, enrichment, standardization, and default values.
• Test null handling, duplicates, data loss, referential integrity, matching, de-duplication, mastering, and survivorship rules.
• Validate inbound and outbound files for structure, headers, delimiters, data types, field lengths, required fields, encoding, and naming conventions.
• Create controlled test files and synthetic data to validate business and transformation rules.
• Design positive, negative, boundary, edge-case, regression, reload, and recovery scenarios.
• Investigate data-quality issues and identify root causes across source data, requirements, mappings, configurations, transformations, and downstream processing.
• Develop reusable SQL queries, scripts, reconciliation checks, and automated data-quality validations.
• Investigate production data issues and support post-deployment validation and regression testing.
• Collaborate with Data Engineering, Business Analysis, Product, Operations, and other technical teams to improve pipeline testability and diagnostics.
• Participate in client and data-vendor onboarding by reviewing specifications, sample files, mappings, and expected outputs.
• Identify requirements gaps, data-quality risks, ambiguities, and testability concerns during onboarding.
• Communicate testing status, defects, risks, blockers, and production-readiness findings to technical and non-technical stakeholders.
• Document and manage defects in Jira with supporting SQL, test evidence, and sample records.
• Lead complex ETL QA initiatives independently, defining testing strategy, scope, approach, and quality standards for critical data pipelines.
• Mentor and provide technical guidance to QA engineers on SQL validation, data reconciliation, test design, defect investigation, and ETL best practices.
• Drive continuous improvement of ETL QA processes by identifying automation opportunities, improving reusable validation frameworks, and strengthening data-quality and production-readiness checks.

Qualifications and Skills

• 7+ years of hands-on experience in ETL testing, data pipeline testing, database testing, data warehouse testing, or data-feed validation.
• Advanced SQL skills with the ability to write complex queries for reconciliation, transformation validation, and root-cause analysis.
• Strong understanding of ETL architecture and data flow across multiple processing stages.
• Experience testing CSV, TXT, delimited, fixed-width, and similar data files.
• Experience translating requirements, mappings, file layouts, and transformation rules into comprehensive test scenarios.
• Strong experience with source-to-target validation and data reconciliation.
• Ability to identify and troubleshoot missing records, duplicates, count mismatches, mapping defects, transformation errors, and data-quality issues.
• Experience creating synthetic test data and controlled inbound files.
• Experience developing reusable SQL validations, scripts, and automated data-quality checks.
• Strong understanding of functional, integration, regression, negative, boundary, and end-to-end testing.
• Experience with Jira or similar defect-management tools.
• Strong analytical, problem-solving, documentation, and communication skills.
• Ability to explain complex technical findings clearly to both technical and non-technical stakeholders.
• Ability to work independently and collaborate effectively with Data Engineering, Business Analysts, Product, Operations, clients, and data vendors.

Preferred Skills

• Healthcare, life-sciences, clinical, claims, real-world evidence, or patient-level data.
• AWS Glue, S3, Redshift, Snowflake, PySpark, or similar data-processing technologies.
• Python or other scripting languages for test automation and data validation.
• Data matching, entity resolution, de-duplication, mastering, and survivorship testing.
• Data governance and data-quality principles.
• CI/CD and automated testing within data-engineering environments.
• Experience working with clients, data vendors, or external data providers.
• Experience with large-scale data warehouses and analytics platforms.

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.