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

From managing day-to-day pharmacy network operations, developing standard reporting, to crafting pricing and underwriting strategies, our Drug Value Strategy team has us going! Within it, the Data Analytics team spearheads the creation and management of standard reports for all Abarcans and clients to use! They dig in through the raw data to supply updates for audits, create predictive models, and identify potential operational and clinical opportunities.

As our Business Analytics Lead, you'll play a key role across the full lifecycle of analytics projects, from analyzing business requirements to developing, testing, deploying, training, and supporting users on analytics solutions that meet those requirements. Other duties will include the performance of data validation to ensure accuracy and appropriateness of the information provided. This role will be an integral component of the organization's Analytics department delivering valuable Information through intelligence and informatics, providing direct support to diverse internal departments.

The fundamentals for the job...

• Translate requirements into reporting deliverables.
• Examine and evaluate the purpose and content of business reports to develop new or improve existing formats.
• Report/query testing and development.
• Create and analyze reports, create custom reporting software, and share findings with end users.
• Analyze healthcare claims data to assess trend performance, as well as investigate potential operational and clinical opportunities.
• Recommend the establishment of new or modified reporting methods and procedures that improve report content and completeness of information.
• Conduct training for team members.
• Collaborate closely with all facets of the project's stakeholders (business analysts, business subject matter experts, and all levels of clients) in the development of 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.
• Ability to work in a collaborative environment with a wide variety of developers and analysts.
• Combine business knowledge and technical expertise to assist customers in evaluating or addressing business issues through use of data.
• Partner with BI team to define and support functional and/or architectural requirements of information delivery; participate in the planning, design, and creation of both standard and ad-hoc reports, dashboards, and scorecards.
• Assure the integrity of project data, 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 address data quality issues when they arise.
• Provide production support to the end users in a timely fashion.
• Work closely with the BI team to determine appropriate data warehouse architecture and data modeling designs in order to maximize benefits.

What you're made of

The bold requirements...

• Bachelor's Degree or Master's Degree Computer Science, Business, Statistical Analysis, Healthcare Management or a closely related field. (In lieu of a degree, equivalent relevant experience may be considered.)
• 6+ years of experience in a role requiring information analysis & various forms of report deliverables.
• Experience in healthcare utilization reporting, claims, membership, provider data, and standard healthcare metrics.
• Experience with business intelligence tools (i.e. Microsoft BI, Tableau, Qlikview); designing, reporting, and delivering analytical solutions.
• 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 have...

• Experience with Microsoft Business Intelligence stack: relational SQL engine, Integration Services, Analysis Services, Reporting Services, and MS Excel PowerPivot.
• Experience developing KPI's, dashboards, and departmental scorecards.
• Experience with Data Warehouse methodologies including relational and dimensional modeling, SQL querying, data profiling, and ETL design and development.

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.

#LI-AMBT #LI-HYBRID