Senior Pharmacy Business Analytics Specialist
Abarca Health
- San Juan, PR
- Permanent
- Full-time
- Analyze data from healthcare claims to assess trend performance and investigate potential operational and clinical opportunities.
- Perform root-cause analysis of issues identified in reports; this will require a comprehensive understanding of overall business.
- Communicate results to clients and staff; communication of results includes well-organized presentations reflecting analytic methods used, key decision points and sufficient detail to support comprehension of the analysis.
- Report/Query testing and development. Ensuring quality and alignment with standards and best practices
- Collaborate closely in all aspects of projects with stakeholders (business analysts, subject matter experts, and all client levels) to develop key Decision Support initiatives.
- Develop proper processes for data collection, data mining, data standardization and analytics; initiate data management and identify proper use of analytics tools.
- You combine business knowledge and technical expertise to assist customers and evaluate or manage business issues through data.
- Partner with BI team to define and support functional and/or architectural requirements for information delivery: participate and sometimes lead the planning, design, and creation of both, standard and ad-hoc reports, Dashboards and Scorecards.
- Ensure projects' data integrity, including data extraction, storage, manipulation, processing, and analysis. Verify the completeness, timeliness, and accuracy of data warehouse information.
- Mentor and coach junior business analysts.
- Work with business owners and technical resources to identify and handle any quality issues that may arise.
- Provide production support to end users based on the timeless fashion of timeliness.
- Work closely with the BI team to determine appropriate data warehouse architecture and data modeling designs to maximize benefits.
- Facilitate workshops and meetings.
- Bachelor's Degree or Master's Degree in Computer Science, Business, Statistical Analysis, Healthcare Management, or a related field (In lieu of a degree, equivalent relevant work experience may be considered.)
- 6+ years'experience in a role requiring information analysis and various forms of report deliverables.
- Experience with healthcare utilization reporting, pharmacy claims, membership, provider data, and standard Healthcare metrics.
- Experience with Business Intelligence tools (i.e., Microsoft PowerBI, Tableau); including designing, reporting, and delivering analytical solutions.
- Experience with development of KPIs, dashboards and departmental scorecards.
- 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)
- Experience with Data Warehouse methodologies, including relational and dimensional modeling, SQL querying, data profiling, and ETL design and development.
- Experience with at least one of the Microsoft Business Intelligence stack tools: relational SQL engine, Integration Services, Analysis Services, Reporting Services, and MS Excel PowerPivot.
- Must be able to access and navigate each department at the organization's facilities.
- Sedentary work that primarily involves sitting/standing.