Data Integration Manager

Abarca Health; San Juan; Presencial; ARS 181.337.000 - 272.006.000; Jornada completa

Descripción de la vacante

Abarca Health is seeking a Data Integration Manager who will own the end-to-end client data exchange lifecycle and ensure high-quality, timely data solutions for healthcare data needs.

The role combines data architecture, ETL, and SQL development with strong client-facing skills to deliver scalable integrations and drive continuous improvement across completeness, timeliness, and accuracy.

Formación

• Bachelor’s or Master’s degree in a quantitative or analytical discipline.
• 8+ years of healthcare data integration experience.
• Proven expertise in SQL and relational databases.
• Experience with dashboarding tools or Python for data analysis.
• Hybrid work model with on-site days for Puerto Rico location.

Responsabilidades

• Own the end-to-end client data exchange lifecycle: discovery, mapping, testing, cutover, steady state, and optimization for recurring feeds.
• Define data quality standards across completeness, timeliness, and accuracy; monitor adherence.
• Lead client technical workshops and translate outcomes into requirements and tests.
• Design and maintain source-to-target mappings with clear rules and error handling.
• Build and monitor controls; create SLAs dashboards and remediate risks proactively.
• Serve as the primary client-facing owner for data integration performance and escalations.
• Provide strategic consultation leveraging risk and value considerations.
• Apply product delivery framework for deployments and client-driven enhancements.
• Author and optimize advanced SQL for validation, reconciliation, sampling, and anomaly detection.
• Partner with Product and Engineering on enhancements and enablement.
• Forecast delivery progress, risks, and dependencies; maintain transparency.
• Mentor team members on standards and operational excellence.

Conocimientos

SQL

Relational databases

Data integration

Client facing

Project coordination

Educación

Bachelor's or Master’s degree in quantitative/analytical discipline

Herramientas

Python

Dashboard tools

Descripción del empleo

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,accuratedata 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\u2019s degree or master\u2019s 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
• We are proud to offer a flexible hybrid work model which will require certain on-site workdays (Puerto Rico Location Only)
• 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\u2019s 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\u2019s 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.