Senior PBM Data Integration Lead — Stock Options

Prescryptive Health; United States; On-site; USD 148,000 - 205,000; Full time

Benefits offered by this job

Flexible time off

12 paid holidays

401k match

Employer-provided health, dental, and视

Health Savings Account contribution

Stock options

Job summary

Prescryptive Health is seeking a hands-on PBM data integration expert who will profile, map, and validate claims, eligibility, and accumulator data across multiple sources. You will write advanced SQL, resolve production discrepancies, and drive end-to-end delivery of benefit data integrations with cross-functional teams.

You will lead integration architecture discussions with engineering, manage timelines and risks, and coordinate with external vendors.

Qualifications

• Bachelor's degree in a quantitative field.
• 10+ years of hands-on technical data experience with SQL and integrations.
• 6+ years in PBM or pharmacy claims processing.
• Advanced SQL proficiency for complex queries.
• Experience with ETL and secure file transfer and job scheduling.

Responsibilities

• Profile, map, and validate claims, eligibility, accumulator, and encounter data across sources; resolve daily discrepancies.
• Write and execute advanced SQL for investigations, validation, and data loads.
• Lead root-cause investigations and remediation of production issues.
• Partner with engineering to design scalable, compliant integration architecture for claims and eligibility.
• Own end-to-end delivery of benefit data integrations with timelines and risks.

Skills

SQL

Data profiling

Data mapping

ETL

Pharmacy data

Analytical thinking

Communication

Problem solving

Education

Bachelor's degree in Statistics/Mathematics/Engineering/CS

Tools

SFTP/PGP

Job scheduling tools

SQL tooling

Job description

Prescryptive Health is seeking a hands-on PBM data integration expert who will profile, map, and validate claims, eligibility, and accumulator data across multiple sources. You will write advanced SQL, resolve production discrepancies, and drive end-to-end delivery of benefit data integrations with cross-functional teams.

You will lead integration architecture discussions with engineering, manage timelines and risks, and coordinate with external vendors.