Senior Business Analytics Specialist

Abarca Health LLC.; San Juan (PR); Hybrid; USD 100,000 - 140,000; Full time

Benefits offered by this job

Hybrid work on-site in Puerto Rico

Job summary

Abarca Health LLC is hiring a Senior Business Analytics Specialist to lead data-driven initiatives, manage data collection, mining, and modeling, and develop dashboards for clients and internal stakeholders.

You will partner with BI teams to ensure data integrity and design data models, while translating business needs into actionable insights and scalable analytics solutions. Hybrid work with on-site Puerto Rico days.

Qualifications

• Degree in analytics, data science, health informatics, or related field; equivalent experience considered.
• 6+ years of data analytics experience, ideally in healthcare/managed care.
• Strong SQL, complex queries, and data warehouse skills.
• Advanced Tableau/Power BI skills for interactive dashboards.
• Experience with Excel and Qlikview.
• Ability to translate business needs into analytics solutions.
• Excellent oral and written communication skills.

Responsibilities

• Create dashboards and materials to convey complex data clearly to diverse audiences.
• Analyze ad-hoc requests: market trends, sales, and store-level performance.
• Design scalable big data and predictive models to uncover patterns and forecast outcomes.
• Develop data collection, mining, standardization, and analytics processes.
• Identify data quality issues with business and technical teams.
• Collaborate with BI to optimize data warehouse architecture and modeling.
• Communicate results through organized presentations with clear methodology.
• Lead planning and creation of standard/ad-hoc reports, dashboards, and scorecards.
• Act as project lead to guide key decision-support initiatives.

Skills

Data analytics

SQL

Tableau

Power BI

Excel

QlikView

Data visualization

KPI reporting

Communication

Project leadership

Education

Bachelor’s or Master’s in Analytics/Data Science/Health Informatics

Tools

SQL

Tableau

Power BI

Excel

QlikView

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.


• Excellent oral and written communication skills.


• We are proud to offer a flexible hybrid work model which will require certain on-site work-days (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 reflect 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.