Senior Business Analytics Specialist

Abarca Health
Summary
Join Abarca as a Senior Business Analytics Specialist and revolutionize healthcare through data-driven initiatives. Develop and manage processes supporting data management, including collection, mining, standardization, and advanced analytics. Select and utilize appropriate analytic tools for data management and analytic processes. Partner with Business Intelligence teams to define and support functional and architectural requirements for information delivery. Verify data warehouse information completeness, timeliness, and accuracy. Translate business requirements to design data models and dashboards. Create dashboards and presentations conveying complex information. Analyze and report on ad-hoc requests, including market trends and sales performance. Design, develop, and implement scalable big data and predictive models. Develop data collection, mining, standardization, and analytics processes. Partner with business owners and technical resources to address data quality issues. Collaborate with the business intelligence team to determine data warehouse architecture and data modeling designs. Effectively communicate results to clients and staff.
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
- Must be able to access and navigate each department at the organization’s facilities
- Sedentary work that primarily involves sitting/standing
- 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)
Responsibilities
- 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
Preferred Qualifications
- 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
Benefits
We are proud to offer a flexible hybrid work model which will require certain on-site workdays (Puerto Rico Location Only)