**Job Summary:**
arenaflex is a leading healthcare, pharmacy, and retail company with a 170-year history of caring for communities. As part of the U.S. Retail Pharmacy and U.S. Healthcare segments of arenaflex Boots Alliance, Inc., we strive to create happier lives through better health. With almost 9,000 retail locations across the United States, Puerto Rico, and the U.S. Virgin Islands, arenaflex is proud to be a community health destination serving nearly 10 million customers every day. Our pharmacists play a vital role in the U.S. healthcare system by providing a wide range of pharmacy and healthcare services, including those that promote equitable access to care for the nation's medically underserved populations.
We are seeking an experienced Full Stack Data Entry Specialist to join our team in a remote work-from-home setting in California. As a key member of our Pricing & Underwriting Analytics team, you will be responsible for undertaking monetary modeling, analyzing data, and making underwriting and pricing suggestions. If you have a passion for data analysis, excellent communication skills, and a strong understanding of financial metrics and operational processes, we encourage you to apply for this exciting opportunity.
**Job Responsibilities:**
* Queries, reviews, and analyzes data and prepares analytics, including pricing and financial models, leveraging advanced Microsoft Excel, Microsoft Access, SQL techniques, for opportunities obtained from pharmacy benefit managers, health plans, and/or healthcare consultants.
* Utilizes advanced-level skills in Microsoft Excel to create and maintain advanced forecasting and underwriting models (e.g., developing a pivot table, developing Macros, using VLOOKUP, INDEX MATCH, SUMIFS, troubleshooting formula errors, and formula auditing).
* Utilizes intermediate-level skills in Microsoft Access, SAS, and SQL to query and analyze large and complex data sets (e.g., developing parameter and action queries, joining tables, developing cross-tab queries, and using Macros to provide user interaction and automate tasks).
* Responsible for tracking, evaluating, reporting, and automating efforts to advise process upgrades in order to guide and enhance current pricing mechanisms.
* Identifies and solves pricing issues through acting evaluation that involves retrieving and analyzing both internal data and data obtained from a third party.
* Analyzes data and units of data so that you become responsible for the results portrayed by that evaluation.
* Utilizes standard working procedures to analyze and respond to inquiries from internal business partners concerning pricing for various lines of business, including retail, specialty, immunizations, and clinics.
* Provides compensation charge suggestions based on complex pricing models for multimillion-dollar opportunities.
* Communicates and collaborates with business partners (at all levels of the organization) in different functional areas, including finance, reporting, operations, business development, and sales.
* Presents pricing theory suggestions, data analysis, and financial models to management and leadership on a daily basis.
* Prepares senior-level executive documentation of pricing theory financial metric suggestions (Executive Governance Memos).
**Essential Qualifications:**
* Bachelor's Degree in Finance, Economics, Accounting, Math, Business, Actuarial Science, or Pharmacoeconomics, OR High School Diploma/GED and at least three years of experience in Pharmacy Benefit Management (PBM), Contracting, Finance, Account Management, or Pricing; or any combination of education and experience that would provide an equivalent background.
* Knowledge and understanding of data, business metrics, and operational processes.
* Strong fundamental questioning skills and experience with reading and reporting data in order to identify issues, trends, or exceptions to drive development of results and discover solutions. Ability to challenge results, address ambiguity, resolve issues, make decisions, see trends/patterns within data sets, and understand root causes.
* Excellent verbal and written communication skills essential to provide data to executives and leaders within the organization.
* Strong organizational skills and ability to multi-project concurrent assignments while meeting deadlines with a high-quality product.
* Experience providing customer service to internal and external clients, including meeting high-quality standards.
* Intermediate-level skills in Microsoft PowerPoint (e.g., using a template, formatting individual spacing, placing a picture, converting slide format and template colors, adding transitions, customizing slide numbers, converting chart format and/or formatting font).
* Intermediate-level skills in Microsoft Excel (e.g., using the SUM function, placing borders, placing column width, placing charts, using text wrap, sorting, placing headers and footers, and/or print scaling).
* Intermediate-level skills in Microsoft Word (e.g., placing headers, page breaks, page numbers, and tables, and/or adjusting table columns).
* Willing to travel up to 10% of the time for business purposes (within state and out of state).
**Preferred Qualifications:**
This job description is intended to serve as a guide for performing Company and branch objectives, and only covers the primary features and responsibilities of the position. It is not to be construed as an all-encompassing list of duties.
**Benefits:**
* Company-Paid Life Insurance
* Medical, Prescription Drugs, Dental, and Vision
* Retirement Savings Plan – 401(k)
* Employee Stock Purchase Plan
* Paid Time Off (PTO)
* Holidays
* Paid Parental Leave (PPL)
* Transportation Benefit Plan
* Employee Store Discount
* Voluntary Life & Personal Accident Insurance
If you are a motivated and detail-oriented individual with a passion for data analysis and excellent communication skills, we encourage you to apply for this exciting opportunity to join our team at arenaflex.
Apply for this job