Program Technical Manager - Hybrid (PA/NJ/DE)

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

Employer: Independence Blue Cross, LLC

Position: Program Technical Manager

Office Location: Philadelphia, PA

Duties: Own the end-to-end QA strategy for data ingestion, transformation, curation, and consumption layers across cloud and on-prem platforms. Design reusable data validation frameworks (schema, constraints, referential integrity, reconciliation, sampling/stratification, and anomaly detection) for largescale, partitioned, and clustered datasets. Author complex SQL for validation and reconciliation (e.g., window functions, CTEs, MERGE, EXCEPT, QUALIFY, SCD/CDC verification, surrogate key logic, survivorship rules). Validate ETL/ELT pipelines (batch and streaming), including orchestration, dependencies, idempotency, late-arriving data handling, and error recovery. Conduct performance and cost optimization testing (e.g., query execution plans, BigQuery slots/reservations, partition pruning, clustering, statistics, materialized views). Implement data quality monitors and SLAs/SLOs (freshness, completeness, accuracy, timeliness, uniqueness, conformity) with automated alerting and lineage/impact assessment. Verify semantic layer and reporting correctness (KPIs, dimensional/fact integrity, grain, hierarchies, and metric governance). Validate healthcare file formats and standards: X12 837/835/834, NCPDP, HL7 v2/v3, FHIR (Resources, Profiles, Terminologies), and code sets (ICD-10, CPT/HCPCS, LOINC, SNOMED CT, RxNorm). Test patient/member entity resolution (EMPI) including deterministic/probabilistic matching, survivorship, and de-duplication logic. Execute and govern defect triage, RCA, and release readiness; manage risk, traceability (requirements <-> test cases <-> defects), and post-deployment validation. May work hybrid (home/office) within normal commuting distance of Philadelphia, PA.

Requirements: bachelor's degree in computer science, information systems, or a related field plus 10 years of postbachelor data engineering experience. Experience must include Advanced SQL, Testing Leadership and Cloud/Data Warehouse. The required skills do not need to be maintained over the full term of required experience.

IBX is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to their age, race, color, religion, sex, national origin, sexual orientation, protected veteran status, or disability.

Must have an Android or iOS device which is compatible with the free Microsoft Authenticator app.