Business Analytics Specialist

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...

The Data Analytics team leads the creation and management of standard reports for all Abarcans and clients to use. They review the raw data to supply updates for audits, create predictive models, and identify potential operational and clinical opportunities.

As our Business Analytics Specialist you will be playing a key role across the full project lifecycle for Health Analytics projects; from analyzing business requirements, up to developing, testing, deploying, training, and supporting users on analytics solutions that meet those requirements, you get to analyze it all to your heart’s content. Other duties will include the analysis of data to provide insight and recommendations for business decisions and the performance of data validation to ensure accuracy and appropriateness of analytic models. You will be integral component of the organization's Health Intelligence department, delivering valuable information by way of Intelligence and Informatics, and providing direct support to diverse internal departments such as Client & Pharmacy Partnerships, Clinical, Finance and Members.

The fundamentals for the job…

• 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.
• 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.
• 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.

What you’re made of

The bold requirements…

• 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.)
• 3+ years experience in a role requiring information analysis and various forms of report deliverables.
• Experience with healthcare utilization reporting, claims, membership, provider data, and standard Healthcare metrics.
• Experience with Business Intelligence tools (i.e., Microsoft BI, QlikView, Tableau); including designing, reporting, and delivering analytical solutions.
• Experience with Snowflake.
• 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 work days (Puerto Rico Location Only)

Nice to haves…

• 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.

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.