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 145 test cases 145 defects), and post-deployment validation. May work hybrid (home/office) within normal commuting distance of Philadelphia, PA.
Requirements: bachelors degree in computer science, information systems, or a related field plus 10 years of post-bachelor 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.
Must have an Android or iOS device which is compatible with the free Microsoft Authenticator app.
