Data Integration Manager

abarca; Puerto Rico; Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

Hybrid work model (Puerto Rico on-site

Job summary

Abarca Health LLC is seeking a Data Integration Manager to lead the end-to-end client data exchange lifecycle, ensuring high-quality, timely data movements and robust data quality controls. You will drive risk mitigation, client workshops, and cross-functional collaboration with Product and Engineering.

The role emphasizes SQL/pipeline leadership, on-call capability, and a flexible hybrid work model with Puerto Rico on-site requirements.

Qualifications

• Bachelor's or master's degree in a quantitative or analytical discipline.
• 8+ years of experience in healthcare data integration or related role.
• Proven expertise in SQL and relational databases.

Responsibilities

• Own end-to-end client data exchange lifecycle, including discovery, mapping, testing, cutover, steady state, and optimization.
• Define and enforce data quality standards across completeness, timeliness, and accuracy for all clients.
• Lead client workshops to elicit requirements and translate outcomes into user stories and specs.
• Design and maintain source-to-target mappings with transformation rules and error handling.

Skills

SQL

Python

Stakeholder management

Client-facing

On-call rotations

Time zone coordination

Education

Bachelor's degree in quantitative field

Master's degree in quantitative field

Tools

Dashboarding tools

Relational databases

ETL 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. ..

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 d egree 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 role s
• 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'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 emp