Senior Data Quality & ETL Validation Program Manager

Independence Blue Cross, LLC; Philadelphia (Philadelphia County); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Independence Blue Cross, LLC in Philadelphia, PA seeks a Program Technical Manager to own the end-to-end QA strategy across data ingestion, transformation, and consumption layers. Design reusable validation frameworks, author advanced SQL, and validate ETL/ELT pipelines with an emphasis on performance, cost optimization, and data quality monitors.

Experience with healthcare data formats is required. The role may be hybrid (home/office) within commuting distance of Philadelphia, addressing

Qualifications

• Bachelor's degree in computer science, information systems, or related field.
• 10+ years of post-bachelor data engineering experience.
• Proficiency in advanced SQL, testing leadership, and cloud/data warehouse concepts.

Responsibilities

• Own end-to-end QA strategy for data ingestion, transformation, and consumption layers.
• Design reusable data validation frameworks for large-scale datasets.
• Author complex SQL for validation and reconciliation (window functions, MERGE, SCD/CDC).
• Validate ETL/ELT pipelines (batch and streaming) and ensure idempotency.
• Conduct performance and cost optimization testing (BigQuery, partitioning, clustering).
• Implement data quality monitors, SLAs/SLOs, alerting, and lineage assessment.
• Verify semantic layer and reporting correctness (KPIs, grain, hierarchies).
• Validate healthcare formats: X12, HL7, FHIR, ICD-10, CPT, LOINC, SNOMED CT, RxNorm.
• Test patient/member resolution and survivorship logic; manage defect triage and releases.
• May work hybrid (home/office) within commuting distance of Philadelphia.

Skills

Advanced SQL

Testing leadership

Data engineering

Cloud / Data Warehouse

Validation frameworks

Education

Bachelor's degree in Computer Science or Information Systems

Tools

BigQuery

Job description

Independence Blue Cross, LLC in Philadelphia, PA seeks a Program Technical Manager to own the end-to-end QA strategy across data ingestion, transformation, and consumption layers. Design reusable validation frameworks, author advanced SQL, and validate ETL/ELT pipelines with an emphasis on performance, cost optimization, and data quality monitors.

Experience with healthcare data formats is required. The role may be hybrid (home/office) within commuting distance of Philadelphia, addressing