Analyst, Pharmacy Pricing & Underwriting

Job Description
Job Summary
Responsible for conducting financial modeling by collecting and analyzing data to make underwriting and pricing recommendations. Additionally, this position will lead the data analytics, collaborate with internal business partners to develop financial forecast models and supporting documentation, and communicate the end result of such analysis to internal leadership.
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 received from pharmacy benefit managers, health plans and/or health care consultants.
• Utilizes advanced level skill Microsoft Excel to create and maintain advanced forecasting and underwriting models (for example: creating a pivot table, creating Macros, using VLOOKUP, INDEX + MATCH, SUMIFS, Troubleshooting Formula Errors, and Formula Auditing).
• Utilizes intermediate level skill of Microsoft Access, SAS, and SQL to query and analyze large and complex data sets. (For example: creating parameter and action queries, joining tables, creating cross-tab queries, and using Macros to provide user interaction and automate tasks).
• Responsible for tracking, analysis, reporting, automation efforts, and recommendation of process improvements in order to support and enhance current pricing mechanisms.
• Identifies and solves pricing problems by performing analysis that involves retrieving and analyzing both internal data and data received from a third party.
• Analyzes data and sets of data so that you become accountable for the results portrayed by that analysis
• Utilizes standard operating procedures to investigate and respond to inquiries from internal business partners regarding pricing for various lines of business including retail, specialty, immunizations, and clinics.
• Provides reimbursement rate recommendations based on complex pricing models for multimillion dollar opportunities
• Communicates and collaborates with business partners (at all levels of the organization) in other functional areas, including finance, reporting, operations, business development, and sales.
• Presents pricing proposal recommendations, data analysis, and financial models to management and leadership on a regular basis.
• Prepares Senior level executive documentation of pricing proposal financial metric recommendations (Executive Governance Memos).

An Equal Opportunity Employer, including disability/veterans
About Walgreens and WBA
Walgreens (www.walgreens.com) is included in the U.S. Retail Pharmacy and U.S. Healthcare segments of Walgreens Boots Alliance, Inc. (Nasdaq: WBA), an integrated healthcare, pharmacy and retail leader with a 170 year heritage of caring for communities. WBA's purpose is to create more joyful lives through better health. Operating nearly 9,000 retail locations across America, Puerto Rico and the U.S. Virgin Islands, Walgreens is proud to be a neighborhood health destination serving nearly 10 million customers each day. Walgreens pharmacists play a critical role in the U.S. healthcare system by providing a wide range of pharmacy and healthcare services, including those that drive equitable access to care for the nation's medically underserved populations. To best meet the needs of customers and patients, Walgreens offers a true omnichannel experience, with fully integrated physical and digital platforms supported by the latest technology to deliver high quality products and services in communities nationwide.
#LI-TO1
External Basic Qualifications

• Bachelor's Degree in Finance, Economics, Accounting, Math, Business, Actuarial Science, or Pharmacoeconomics, OR High School Diploma/GED and at least 3 years of experience in Pharmacy Benefit Management (PBM), Contracting, Finance, Account Management, or Pricing; or any combination of education and experience, which would provide an equivalent background.
• Knowledge and understanding of data, business metrics and operational processes.
• Strong critical thinking skills and experience with analyzing and reporting data in order to identify issues, trends, or exceptions to drive improvement of results and find solutions. Ability to project results, deal with ambiguity, solve problems, make decisions, see trends/patters within data sets, identify root causes.
• Excellent verbal and written communication skills necessary to present information to executives and leaders throughout the organization.
• Strong organizational skills and ability to multi-task concurrent assignments while meeting deadlines with a quality product.
• Experience providing customer service to internal and external customers, including meeting quality standards.
• Intermediate level skill in Microsoft PowerPoint (for example: applying a theme, formatting character spacing, inserting a picture, changing slide layout and theme colors, adding transitions, customizing slide numbers, changing chart style and/or formatting font).
• Intermediate level skill in Microsoft Excel (for example: using SUM function, setting borders, setting column width, inserting charts, using text wrap, sorting, setting headers and footers and/or print scaling).
• Intermediate level skill in Microsoft Word (for example: inserting 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 to be used as a guide for accomplishing Company and department objectives, and only covers the primary functions and responsibilities of the position. It is in no way to be construed as an all encompassing list of duties.