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…

Our Drug Value Strategy team manages day-to-day pharmacy network operations, developing standard reporting, crafting pricing and underwriting strategies. The Data Analytics teams drive the creation and management of standard reports for all Abarcans and clients to use! They work with raw data to supply updates for audits, create predictive models, and identify potential operational and clinical opportunities.

As our SQL Reporting Specialist you will analyze and report on all data lakes, files and tasks received. Reporting will be data-driven, and you'll have the chance to present and collaborate with other departments for their needs by analyzing findings, troubleshooting developing, and guiding reporting storage. We'll also rely on you to influence how we collect data, the design and layout of reporting, and recommendations on quality assurance management. Using that critical thinking and attention to detail will be important to ensure the accuracy and completeness of our data as well as proper use of associated analytics tools.

The fundamentals for the job…

• Translate requirements into reporting deliverables while also handling report and query development and testing.
• Create and analyze reports and share findings with end-users.
• Develop recommendations for modifications of existing reports or creation of new reports while also brainstorming processes for data collection, mining, standardization of reporting and analytics.
• Support implementations by handling the report side on the following areas: impact analysis reports, platform change monitoring reports, mitigation, and other related areas.
• Handle data management and support from the Analytics' team while ensuring proper use of analytics tools.
• Combine business knowledge and technical expertise to assist customers in evaluating or addressing business issues through data.
• Assure project data integrity, including data extraction, storage, manipulation, processing, and analysis.
• Verify the completeness, timeliness, and accuracy of the output data.
• Work with business owners and technical resources to identify and address data quality issues as they arise.

What we expect of you

The bold requirements…

• Bachelor's Degree or Master's Degree in Computer Science, Engineering, or a related field. (In lieu of a degree, equivalent relevant work experience may be considered.)
• 1+ years of professional experience with SQL.
• Experience with designing, reporting, and delivering analytical solutions.
• Experience with business intelligence tools (i.e., Microsoft BI, Tableau, QlikView among others)
• Excellent oral and written communication skills, bilingual Fluency in Spanish and English is required for this role.
• 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 healthcare utilization reporting, claims, membership, provider data, and standard Healthcare metrics.
• Proficiency with Reporting Services.

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-NO1 #LI-REMOTE