Sr Data Analytics Consultant

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! Our Drug Pricing & Underwriting Strategy folks participate in client negotiations to establish rebates with key industry players while also creating attractive and lucrative pricing strategies and formulary recommendations for potential clients.

 In this key role as a Sr Data Analytics Consultant, you will develop and maintain pricing procedures for underwriting RFP processes, specifically all procedures around data management (data collection, data mining, data standardization and analytics). You will be responsible for selecting the appropriate analytic tools and properly using such tools to execute data management and analytic processes.You will partner with Business Intelligence teams to define and support functional and/or architectural requirements of information delivery to ensure the integrity of project data, including extraction, storage, manipulation, processing and analysis. You will verify completeness, timeliness and accuracy of data warehouse information. Additionally, you will translate business requirements to design logical and physical data models and dashboards to monitor SLA rate performance.

The fundamentals for the job…

• Ownership of data modeling in support of our underwriting and sales process, including repricing of historical claims data for prospective clients.
• Create new dashboards to monitor SLA rate performance and rebate performance.
• Translate business requirements into conceptual, logical, and physical data models. Design and implement scalable data models. Big data Modeling.
• Develop predictive models using multiple statistical techniques to uncover patterns and correlations in complex data to help predict likely future outcomes.
• Act as project leader providing the direction required for meeting the project objectives (when required).
• Effectively communicate results to clients and staff. Communication of results include well-organized presentations, both oral and written, to reflect analytic methods used and key decision points with sufficient detail to support comprehension of the analysis.
• 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.
• Combine business knowledge and technical expertise to assist customers when 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 and sometimes lead 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.
• Work closely with the BI team to determine appropriate data warehouse architecture and data modeling designs to maximize benefits.
• You will create dashboards and presentation materials that convey complex information clearly to various audiences.
• Work across departments to define streamlined processes.
• You’ll also analyze and report on various ad-hoc requests including market trends, sales, under/over performance and store specific analyses to provide information efficiently and promptly.

What we expect of you

The bold requirements…

• Bachelor’s degree in Computer Science, Business, Statistical Analysis, Healthcare Management, or a related field. (In lieu of a degree, equivalent relevant experience may be considered.)
• 3+ years of experience in a role requiring information analysis and various forms of report deliverables.
• Experience working in collaborative environment with a wide variety of developers and analysts.
• Experience working independently and participate as a member of a cross-functional team.
• Excellent oral and written communications 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 business intelligence tools (i.e. Tableau, Qlikview, Microsoft BI, Business Objects); designing, reporting and delivering analytical solutions is a plus.
• Experience with Data Warehouse methodologies including relational and dimensional modeling, SQL querying, data profiling, and ETL design, and development.
• Experience with at least one tool of the Microsoft Business Intelligence stack, would be a plus: relational SQL engine, Integration Services, Analysis Services, Reporting Services, and MS Excel PowerPivot.
• Experience in PBM, Healthcare, and Insurance is a great big plus.

Physical requirements…

• Must be able to access and navigate each department at the organization’s facilities.
• Sedentary work that primarily involves sitting/standing.

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.

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”

All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of gender, race/ethnicity, gender identity, sexual orientation, protected veteran status, disability, or other protected group status.

#LI-REMOTE #LI-JD1