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…
As our Senior Business Analytics Specialist, you will develop and manage processes and procedures that support data-driven initiatives, with a strong emphasis on data management, including data collection, mining, standardization, and advanced analytics. You will be responsible for selecting the appropriate analytic tools and properly using such tools to execute data management and analytic processes. You will partner with Business Intelligence teams to define and support functional and/or architectural requirements of information delivery to ensure the integrity of project data, including extraction, storage, manipulation, processing, and analysis. You will verify completeness, timeliness, and accuracy of data warehouse information. Additionally, you will translate business requirements to design conceptual, logical, and physical data models and dashboards.
The fundamentals for the job…
- Create dashboards and presentation materials that convey complex information clearly to various audiences and monitor rate performance and rebate performance.
- Analyze and report on ad-hoc requests including market trends, sales, under/over performance, and store specific analyses to provide information efficiently and promptly.
- Design, develop and implement scalable big data models and predictive models using multiple statistical techniques to uncover patterns and correlations in complex data to help predict likely future outcomes.
- Develop processes for data collection, data mining, data standardization and analytics; initiate data management and identify use of analytics tools.
- Partner with business owners and technical resources to identify and address data quality issues when they arise.
- Partner with the business intelligence team to determine appropriate data warehouse architecture and data modeling designs to maximize benefits.
- Effectively communicate results to clients and staff through well-organized presentations that reflect analytic methods used and key decision points with sufficient detail to support comprehension of the analysis.
- Lead planning, design, and creation of both standard and ad-hoc reports, dashboards, and scorecards.
- Act as project leader providing the direction required for meeting the project objectives. Collaborate closely with project stakeholders in the development of key decision support initiatives.
What we expect of you
The bold requirements…
- Bachelor’s Degree or Master’s Degree in Analytics, Data Science, Health Informatics, or related field (In lieu of a degree, equivalent relevant experience may be considered.)
- 6+ years of experience in data analytics, preferably within healthcare or managed care space.
- Strong SQL proficiency and experience writing complex queries, optimizing performance and building views/stored procedures for large‐scale claims and membership databases
- Advanced Tableau/ Power BI skills and experience designing interactive dashboards, data visualization best practices, parameterized filters.
- Experience with Excel and Qlikview.
- Experience with root cause analysis and process improvement.
- Experience developing dashboards, presentations, and contextualizing findings for different audiences (executive leadership, internal teams, clients, and prospective clients, etc.)
- Deep understanding of managed‐care/health‐plan operations—including pharmacy benefit management (PBM) workflows, formulary design, and utilization trends
- Familiarity with PBM-specific data structures (e.g., NDCs, GPI/GCN hierarchies, rebate/pass‐through models, medical‐pharmacy linkage)
- Experience building KPI reports for PMPM, PUPM, drug‐trend analyses, and clinical metrics (HEDIS, Star Ratings)
- Ability to translate business requirements into analytics solutions, partnering with actuarial, clinical, and finance teams to drive actionable insights. Excellent oral and written communication skills.
- We are proud to offer a flexible hybrid work model which will require certain on-site workdays (Puerto Rico Location Only)
- This position requires availability to work in a specified time zone or working schedule, accommodating the business needs of our clients and team members.
- This position may require availability for on-call hours, including evenings, weekends, and holidays, to promptly address emergent issues or provide necessary support as dictated by operational demands (if applicable).
Nice to haves…
- Experience with prescription drugs, pharmaceutical manufacturers, drug rebates, and contract negotiations.
- Health Care Quality and Management (CHCQM), Professional in Business Analysis (PBA) or similar certifications.
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.
#LI-REMOTE #LI-MH1
