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…

Safeguarding the financial health of our clients and Abarca is of the upmost importance! Our Finance team ensures that our financial systems are managed and running smoothly. Our rebates teams lead the way in all aspects of the manufacturer’s rebates contract interpretation, formulary compliance, system capabilities, billing, reconciliation, and allocation of payments for Medicare, Commercial, and Medicaid clients. In this role, you will focus on maintaining in-depth knowledge of our rebate processes, system improvements and compliance with contractual terms and regulations.

As Rebates Data & Reporting Analyst Lead you will analyze rebates invoices for manufacturing companies, contractual terms for billing, generate reconciliations and help designing tools to ensure the accuracy and completeness of data related to rebates billing cycle. The process will include reporting for external or internal users. You will also be supporting and collaborating in the new data management in a new repository. This role will also be providing full support of data element maintenance in the new reporting and analytics repository and help define new policies and procedures related to the collection and data accuracy, transformation of data to keep track of all rebates data flow in Abarca.

The fundamentals for the job…

  • Continually collaborates with business and technology stakeholders to identify needs and opportunities for improved data and analytics solutions and delivery, business processes and tasks that can be automated, and to understand the underlying data resources and their relationship to deliver actionable data driven insights and decision support.
  • Generate, review, analyze, and send out rebates reporting to external stakeholders, internal clients, manufacturer companies related to pharmacy and medical rebates for Commercial, Medicare and Medicaid line of business.
  • Provide analytical support for rebates process management for all lines of business (3rd party aggregator, In-House, MDRP and ASES).
  • Ability to do research, investigate discrepancies, and propose as well as develop solutions.
  • Perform complex root-cause analysis of issues identified in rebates reports. Gather necessary data to pinpoint problem areas on which to focus, validating that the analysis is data driven, recommending, and implementing solutions and evaluating those results, and implementing controls to monitor consistent use of the solution.
  • Perform assessment and communicate critical information gathered by the reporting tools.
  • Identify, analyze, and interpret trends or patterns in complex data sets.
  • Assist in preparation of monthly management reports, accompanying schedules, worksheets and narratives, and quarterly and annual regulatory filings.
  • Leads the development, construction, testing and maintenance of data architecture, extract, load, transform (ELT) processes, logical and physical data models, data marts, meta data repositories and database designs in alignment with business requirement.
  • Fully support data modeling for new rebate data design in Snowflake.
  • Identify manual processes that can be automated and take a lead role in developing processes to eliminate manual dependencies and incorporate necessary QA steps to minimize and identify errors.
  • Participates in initiatives or projects that support process improvements, leveraging new system capabilities or the integration of data/other applications into existing systems.
  • Support rebate information or modeling requests from clients; ad-hoc financial reports for clients and partners, as needed.
  • Provide reporting as well as perform querying, testing, development, and validation of data.
  • Provide full support to business and technical users regarding rebates process and develop complex QA processes to ensure data compliance with established procedures.
  • Collaborates with rebates team and technical resources to identify and address data quality issues when they arise. Provide necessary supporting documentation of findings.
  • Serve as liaison with technical area involved in the rebates processes to understand back-end process and how to apply it to data model and/or reporting.
  • Support data integrity process, including data extraction, storage, manipulation, processing, and analysis; verify the completeness, timeliness, and accuracy of data; work with a variety of data files to ensure all rebate data is accurately loaded to the systems with proper support documentation.
  • Track and document all requests, issues, deliverables to provide reporting and updates on a weekly basis to your manager and team.
  • Interacts with internal and external members to accomplish goals. Communicate complex findings and conclusions in an easy-to-understand way, as well as ability to manage tight deadlines and competing priorities to ensure timely deliveries.
  • Perform other duties and special projects as assigned. For example: support data modeling for new rebate data design in Snowflake and identifying trends and anomalies in loaded rebates data.
  • May be responsible for training new team members as needed.

What we expect of you

The bold requirements… 

  • Bachelor’s degree in computer science, engineering, or a related field. If you don’t have a degree, but you have the experience, we’ll consider you anyway.
  • 5+ years of relevant work experience in PBM or pharmaceutical rebate management.
  • 4+ years of professional experience with SQL and reporting tools (i.e., Snowflake, Microsoft BI, Tableau, QlikView).
  • Experience in designing, reporting, and delivering analytical solutions.
  • Experience managing complex reconciliation processes within financial and rebates areas.
  • Experience leveraging tools for reporting and analytics (e.g. Excel, SSRS, PowerBI).
  • Excellent oral and written communication skills, bilingual fluency in Spanish and English required.
  • Must be located in Puerto Rico
  • We are proud to offer a flexible hybrid work model which will require certain on-site work days (Puerto Rico Location Only)

Nice to haves…

  • 2+ years of experience in a role within a financial field.
  • Experience in healthcare industry, claims processing, Commercial, Medicare and Medicaid line of business and Pharmacy rebates, claims processing and data interchange.

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.  “Applicant must be a United States’ citizen. 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.

#LI-NS1 #LI-REMOTE

 

Apply for this Job

* Required
resume chosen  
Dropbox Google Drive
(File types: pdf, doc, docx, txt, rtf)
Cancel
cover_letter chosen  
Dropbox Google Drive
(File types: pdf, doc, docx, txt, rtf)
Cancel
When autocomplete results are available use up and down arrows to review
+ Add another education
U.S. Standard Demographic Questions We invite applicants to share their demographic background. If you choose to complete this survey, your responses may be used to identify areas of improvement in our hiring process.
How would you describe your gender identity? (mark all that apply)





How would you describe your racial/ethnic background? (mark all that apply)











How would you describe your sexual orientation? (mark all that apply)








Do you identify as transgender? (Select one)




Do you have a disability or chronic condition (physical, visual, auditory, cognitive, mental, emotional, or other) that substantially limits one or more of your major life activities, including mobility, communication (seeing, hearing, speaking), and learning? (Select one)




Are you a veteran or active member of the United States Armed Forces? (Select one)




Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Abarca Health’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

Our system has flagged this application as potentially being associated with bot traffic. Please turn off any VPNs, clear your browser cache and cookies, or try submitting your application in a different browser. If this issue persists, please reach out to our support team via our help center.
Please complete the reCAPTCHA above.