Senior Data Integration Lead — Hybrid Work

Abarca Health LLC.; San Juan, Northern (PR, KY); Híbrido; USD 110.000 - 160.000; Jornada completa

Descripción de la vacante

Abarca Health LLC is seeking a Senior Data Integration Analyst in a hybrid Puerto Rico setting to lead end-to-end data integration projects. You will craft complex SQL queries, interpret PBM data layouts, and serve as a Darwin system specialist for beneficiary and claims research.

You will mentor teammates, drive data quality initiatives, and collaborate with stakeholders to define clear integration requirements and SLA monitoring across schedules.

Formación

• Bachelor’s or Master’s degree in a related area (or equivalent experience).
• 5+ years of experience with PBM or health plan data exchange (EDI/ETL).
• Proficient in developing SQL queries with joins, aggregations, and reconciliation logic.
• Deep working knowledge of PBM data domains (eligibility, accumulators, benefit groups, claims, MOOP).
• Advanced Darwin system or similar PBM platforms for multi-module navigation and issue research.
• Proven ability to independently lead complex integration investigations and drive resolution.
• Experience with relational database architecture and data standards.

Responsabilidades

• Lead end-to-end management of complex data integration issues from triage to resolution and documentation.
• Author and optimize advanced SQL queries for data validation, reconciliation, sampling, and anomaly detection.
• Interpret and apply complex flat-file layouts to identify mapping gaps and integration issues.
• Serve as a technical resource on Darwin system modules for client benefit setups and searches.
• Design and execute UAT and data integration test strategies with QA checks and data quality gates.
• Partner with stakeholders to clarify requirements and translate needs into integration specs.
• Monitor file schedules and SLAs; flag risks before service levels are affected.
• Ensure data quality across completeness, timeliness, and accuracy of end-to-end flows.
• Lead technical discussions and align solutions across cross-functional teams.

Conocimientos

SQL queries

PBM data

Data quality

Documentation

Communication

Independent investigations

Leadership

Relational DB

Educación

Bachelor's/Master's in related field

Herramientas

Darwin system

Python

Dashboarding tools

Descripción del empleo

Abarca Health LLC is seeking a Senior Data Integration Analyst in a hybrid Puerto Rico setting to lead end-to-end data integration projects. You will craft complex SQL queries, interpret PBM data layouts, and serve as a Darwin system specialist for beneficiary and claims research.

You will mentor teammates, drive data quality initiatives, and collaborate with stakeholders to define clear integration requirements and SLA monitoring across schedules.