Data Integration Manager

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

Job summary

Abarca Health LLC is seeking a Data Integration Manager to act as primary SME for client data exchange, ensuring seamless integration between client systems and internal platforms. You will own data quality, define controls, and lead workshops to convert needs into requirements and implementations.

The role combines data architecture, ETL, SQL development, and strong client communication to deliver accurate data movement, rapid issue resolution, and continuous improvement across healthcare data

Qualifications

• Bachelor’s or master’s in a quantitative/analytical field; or equivalent experience.
• 8+ years in healthcare data integration, PBM data exchange, or related roles.
• Proven SQL and relational database expertise.
• Experience with dashboarding tools or Python for data analysis.
• Willingness to support on-call rotations and time-critical deliverables.
• Strong client-facing communication and stakeholder management skills.
• Ability to work in time zones aligned with client needs.

Responsibilities

• Own end-to-end client data exchange lifecycle from discovery to optimization.
• Define and monitor data quality standards across completeness, timeliness, and accuracy.
• Lead client workshops to elicit requirements and translate to user stories.
• Design source-to-target mappings with transformation rules and error handling.
• Build and monitor controls and SLA dashboards; remediate risks proactively.
• Serve as primary client-facing owner for data integration performance.
• Provide strategic risk/value guidance to clients.
• Apply product delivery and change-management frameworks for integrations.
• Author and optimize SQL for data validation and anomaly detection.
• Partner with Product and Engineering on releases and enablement.
• Forecast delivery progress, risks, and dependencies; report transparently.
• Mentor teammates on standards and operational excellence.

Skills

SQL

Relational databases

Data integration

Client-facing communication

Education

Bachelor's degree in quantitative discipline

Master's degree in quantitative discipline

Tools

Python

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…

The Data Integration Manager serves as the primary subject matter expert for client data exchange processes, ensuring seamless integration between client systems and internal platforms. This role combines technical expertise in data architecture, ETL processes, and SQL development with strong client-facing communication skills to deliver high-quality, timely solutions for complex healthcare data needs. This role formally owns data quality for the clients supported, including defining, enforcing, and continuously improving data quality standards across completeness, timeliness, and accuracy. This role proactively manages data anomalies, validates end-to-end flows, and ensures all client deliverables meet contractual and operational expectations, providing strong risk and value-based consultation to clients; effective escalation and relationship management; predictable, accurate data movement, rapid issue resolution, and continuous improvement.

The fundamentals for the job…

• Own the end-to-end client data exchange lifecycle: discovery, mapping, testing, cutover, steady state, and optimization for recurring eligibility, claims, accumulators, and related feeds.
• Formally own data quality standards across completeness, timeliness, and accuracy for all assigned clients; define controls and continuously monitor adherence
• Lead client technical workshops to elicit requirements, clarify business rules and use cases, and align acceptance criteria; convert outcomes into user stories, acceptance tests, and implementation plans. Translate client needs into functional requirements and design specifications.
• Design and maintain source-to-target mappings with clear transformation rules, value sets, and error handling; track data lineage and maintain version control of layouts/specs.
• Build, monitor, and continuously improve controls (file/record counts, totals/hashes, tolerance bands, reject thresholds) and SLA dashboards; proactively remediate risks before SLAs are impacted.
• Serve as the primary client-facing owner for data integration performance, ensuring proactive communication, risk mitigation, and timely resolution of issues, including structured management of escalations when necessary.
• Provide strategic consultation leveraging business sense—framing issues and recommendations through risk (frequency, financial impact) and value (ROI) considerations.
• Apply a product delivery and change-management framework to ensure seamless deployment and adoption of new integrations, file layouts, or client-driven enhancements
• Author and optimize advanced SQL for data validation, reconciliation (e.g., member counts, coverage spans, accumulator rollups), sampling, and anomaly detection.
• Partner cross-functionally with Product and Engineering on enhancements, release readiness, and client enablement.
• Forecast and track delivery progress, risks, and dependencies; maintain transparent reporting.
• Mentor team members on standards, best practices, and operational excellence.

What we expect of you

The bold requirements…

• Bachelor’s degree or master’s degree in a quantitative or analytical discipline. In lieu of a degree, equivalent relevant work experience may be considered.
• 8+ years of experience in healthcare data integration, PBM/health plan data exchange, or related roles
• Proven expertise in SQL and relational databases
• Experience with dashboarding tools or Python for data analysis (e.g., validation frameworks, reconciliation scripts, data quality checks, file parsing)
• Flexibility to support on-call rotations and time-critical deliverables when required.
• Strong client-facing communication and stakeholder management skills.
• Availability for on-call rotation for time-critical deliverables.
• Ability to work in required time zones aligned with client operational needs.

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.