Data Integration Analyst

Abarca Health LLC.; San Juan (PR); Hybrid; USD 70,000 - 95,000; Full time

Job summary

Abarca Health LLC in Puerto Rico is seeking a Data Integration Analyst to manage day-to-day client data operations, monitor file exchanges, and resolve load issues with accuracy and timeliness.

You will use SQL and other analytic tools to analyze PBM data, interpret eligibility/accumulator/claims feeds, and coordinate with internal teams on client implementations and testing. A hybrid on-site/remote schedule is available in PR.

Qualifications

• 3+ years of PBM or health plan data exchange experience.
• Experience developing SQL queries for data analysis and validation.
• Solid knowledge of PBM data domains: eligibility, accumulators, claims.

Responsibilities

• Monitor inbound/outbound data exchanges and investigate load issues.
• Ensure client eligibility, accumulators, and claims data flow on time.
• Read flat-file layouts to identify mapping gaps and integration issues.
• Document findings and actions in ADO, CRM, or Confluence.
• Collaborate with internal teams on client implementations and testing.
• Identify improvements to data exchange processes.

Skills

SQL

Data Analysis

EDI/ETL

Healthcare data

Communication

Education

Bachelor's or Master's in related field

Tools

Darwin PBM

Python

Dashboarding tools

Job description

What you’ll do

In a few words… Abarca is igniting a revolution in healthcare. We built our company on the belief that with smarter technology we are redefining pharmacy benefits, but this is just the beginning…

As a Data Integration Analyst, you are the day-to-day engine of our client data operations. You independently monitor inbound and outbound data exchanges, investigate file load issues, and ensure that client eligibility, accumulator, and claims data flows accurately and on time. Your analytical skills and keen attention to detail are critical to identifying root causes, communicating impacts, and driving resolution — all while building your expertise in PBM data systems and client integrations.

The fundamentals for the job…

• Assess file load rejects and threshold limit conditions, identify root causes, and take action to remediate issues independently.
• Act on file alert conditions (e.g., missing or delayed files) and drive timely remediation.
• Monitor and track file processing to ensure adherence to client schedules and service level agreements.
• Perform quality assurance reviews of data loads — including review of load reports and data sampling — and take corrective action when data issues are identified.
• Manage Accumulator and Eligibility review and reconciliation processes to ensure alignment between Abarca and client systems.
• Complete analysis and provide findings for assigned client data requests within SLA response timeframes.
• Use SQL and other analytical tools to conduct data analysis, respond to client requests, and identify client‑specific solutions.
• Read and interpret flat-file layouts (eligibility, accumulators, claims) to identify mapping gaps and integration issues.
• Ensure adherence to existing controls around data exchange.
• Document investigation steps, findings, and resolution actions in ADO, CRM, or Confluence to ensure traceability.
• Identify improvements to existing client data exchange processes and communicate those solutions to technical and non‑technical audiences.
• Collaborate with internal teams on client implementations, including testing file loads and extracts, reviewing load reports, and sharing results.
• Perform any additional tasks or special projects as assigned.

What we expect of you

The bold requirements…

• Bachelor's Degree or Master's Degree in a related area. (In lieu of a degree, equivalent relevant work experience may be considered.)
• 3+ years of experience with PBM or health plan data exchange (EDI/ETL) functions.
• Experience developing SQL queries for data analysis and validation. Experience related to relational database architecture and data standards.
• Solid working knowledge of PBM data domains including eligibility, accumulators, benefit groups, and claims.
• Experience with Darwin or comparable PBM system platforms.
• Excellent oral and written communication skills.
• We are proud to offer a flexible hybrid work model which will require certain on‑site work‑days (Puerto Rico Location Only)
• This position requires availability to work in a specified time zone or working schedule, accommodating the business needs of our clients and team members.
• This position may require availability for on‑call hours, including evenings, weekends, and holidays, to promptly address emergent issues or provide necessary support as dictated by operational demands (if applicable).

Nice to haves...

• Experience with dashboarding tools or Python for data validation and reconciliation.
• Familiarity with healthcare industry data standards and PBM regulatory frameworks (e.g., Medicare Part D, CMS).

Physical Requirements

• Must be able to access and navigate each department at the organization’s facilities.
• Sedentary work that primarily involves sitting/standing.

At Abarca we value and celebrate diversity. Diversity, equity, inclusion, and belonging are guiding principles of Abarca and ensure Abarca’s workforce reflects the communities it serves. We are proud to provide equal employment opportunities to all employees and applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, medical condition, genetic information, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

Abarca Health LLC is an equal employment opportunity employer and participates in E‑Verify. Abarca Health LLC does not sponsor employment visas at this time.

The above description is not intended to limit the scope of the job or to exclude other duties not mentioned. It is not a final set of specifications for the position. It’s simply meant to give readers an idea of what the role entails.