← Back to jobsJob ID col-cmv8vpqb907oamd018r58n38n

Abarca HealthPosted 30+ days ago

Data Integration Analyst

Full-time
Hybrid
3+ years
Competitive
Posted 30+ days ago

Responsibilities 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 repor

Posted
30+ Days Ago
Source
ziprecruiter.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • 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

Qualifications

  • 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
  • Abarca Health LLC does not sponsor employment visas at this time

Preferred

  • 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)

Required skills

SQLPBM Data Exchange (EDI/ETL)PBM Data DomainsRelational Database ArchitectureData StandardsDarwinPythonMedicare Part DCMS Regulatory Frameworks

Full job description

Responsibilities

  • 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

Preferred

  • 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)

Benefits

  • Flexible hybrid work model requiring certain on-site workdays (Puerto Rico location only).

Qualifications

  • 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
  • Abarca Health LLC does not sponsor employment visas at this time
  • 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)
  • 3+ years of experience with PBM or health plan data exchange (EDI/ETL) functions.

Required skills

  • SQL, PBM Data Exchange (EDI/ETL), PBM Data Domains, Relational Database Architecture, Data Standards, Darwin, Python, Medicare Part D, CMS Regulatory Frameworks

Experience

  • 3+ years

Company

  • Abarca Health is an information technology company that offers healthcare IT services.
  • San Juan Capistrano, California, USA
  • http://abarcahealth.com

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Oct 14, 2026

Work mode

Hybrid

Job source

ziprecruiter.com

Company

Abarca Health

Information Technology & AI

Abarca Health is an information technology company that offers healthcare IT services.

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Analyst jobs in San Juan Capistrano

NVIDIA

1d ago

New

Senior Data Analyst, Capacity Management - DGX Cloud

Full-timeOn-siteSanta Clara, CA$128K – $213K/yr

NVIDIA is hiring a Senior Data Analyst for its DGX Data team. The role develops capacity models, forecasts, dashboards, and recommendations to support DGX Cloud planning, infrastructure readiness, and operational decision-making.

Why similarSame rolePythonSanta Clara

Solstice Advanced Materials

1d ago

New

Sr Advanced Data Analyst

Full-timeHybridSpokane, WA$113K – $142K/yr

Solstice Advanced Materials is seeking a Senior Manufacturing Data Analyst to build and scale analytics capabilities across its manufacturing network, initially supporting the Copperfield expansion in Spokane.

Why similarSame rolePythonSQL

Dice

1d ago

New

Data Analyst

TemporaryHybridTrenton, NJCompetitive

Sunrise is recruiting a Data Analyst to support a client’s enterprise data requests and modernization initiatives.

Why similarSame rolePythonSQL

Get new Data Analyst jobs in San Juan Capistrano by email

Create job alert

Data Integration Analyst

Abarca Health · Competitive

Apply on company site