"Alerted.org

Job Description:

Job Summary:

Responsible for managing the finances for the Medicare Part D Pharmacy contracts with PBMs and insurance companies.

**Business Partnering:** This role will collaborate with Pharmacy business unit partners including Contracting, Underwriting, Compliance, Insights, Data Analytics, Government Relations, and Health Care Segment Development to quantify and project the financial impact of contract renewals, network access shifts, compliance reconciliations, and upcoming changes in the macro and micro business environment.

**Financial Planning:** This role will support the monthly close, monthly forecast, quarterly earnings, annual budget, and annual 3YP process for the Medicare reimbursement area: one of the primary sources of revenue for the organization.

**Financial Analysis:** This role will provided financial analysis support for business cases and opportunities headed to governance. In addition, the role will help quantify the financial impact from changes in federal legislation.

**Financial Reporting:** This role will develop, manage, and present weekly, monthly, and quarterly reporting for the Medicare business segment. This role will create weekly reporting for VP of Pharmacy finance related to on-going contract negotiations.

**Financial Modeling:** This role will develop, enhance, and create financial models to project future Medicare reimbursement or understand recent trends.

**Data Analytics and Management:** This role will utilize snowflake, databricks, Tableau, and other software to extract relevant pharmacy information from databases. This role will also work with the systems team to resolve any mapping issues in the data sources.

**Power BI Dashboards:** This role will help create relevant Power BI dashboards to help summarize Medicare Part D reimbursement performance.

Job Responsibilities:

+ Develops complex financial models to support management decision-making related to new product development, product portfolio analysis, profitability of new opportunities, capital investments, revenue models, profit margin analysis, and impact of regulatory changes. Defines financial requirements for new products and features. Analyzes and summarizes the division’s financial statements, expenses, and records.

+ Develops recommendations for management decision-making.

+ Performs moderate to complex financial analysis including conducting research and identifying, designing and implementing applications and tools to fulfill reporting and analysis needs. Runs various scenarios through models and interprets financial impact. Measures financial results against budget and forecast.

+ Assists in the development of the long-range financial plans and continuously analyzes operating financial results. Works closely with other departments within Walgreens to ensure that strategic initiatives are achieved.

+ May assist in the development of the annual budget and analyzes actual and budgeted figures on an ongoing basis. Creates and maintains detailed budgeting templates.

+ With minimal guidance from management, assesses analytical tools and various formats of data availability and researches and builds new programs that allow for various lines of data to be incorporated so financial modeling analysis of multiple program impact becomes more efficient and allows for more in depth analysis and review resulting in improved recommendations and solutions for the business. Where standard tools are insufficient, utilizes statistical analysis software (SAS) to model and analyze data as requested.

+ Reviews monthly financial operating results for each assigned business unit, identifying key trends, variances, and areas of improved performance. Works with other departments in Walgreens for account reconciliation.

+ Provides information and assistance to management regarding expenditures, purchases and other costs of doing business.

+ As requested, answers complex request for proposal (RFP) questions related to new business and client renewals for a variety of different programs. Responsible for ensuring data integrity and accuracy of information provided to RFP questions.

+ Performs ad hoc analysis and forecasts for internal management team and external customers.

+ Provides guidance and training to associate analysts and analysts on financial modeling, data extraction techniques, budgetary considerations, and recommends best practices on pulling and refining data. As needed provides explanation to team regarding intricate web of data and how assumptions on one program or project may impact other programs or projects that are not specifically in scope during an analysis.

About Walgreens

Founded in 1901, Walgreens (www.walgreens.com) has a storied heritage of caring for communities for generations and proudly serves nearly 9 million customers and patients each day across its approximately 8,500 stores throughout the U.S. and Puerto Rico, and leading omni channel platforms. Walgreens has approximately 220,000 team members, including nearly 90,000 healthcare service providers, and is committed to being the first choice for retail pharmacy and health services, building trusted relationships that create healthier futures for customers, patients, team members and communities.

Walgreens is the flagship U.S. brand of Walgreens Boots Alliance, Inc. (Nasdaq: WBA), an integrated healthcare, pharmacy and retail leader. Its retail locations are a critical point of access and convenience in thousands of communities, with Walgreens pharmacists playing a greater role as part of the healthcare system and patients care teams than ever before. Walgreens Specialty Pharmacy provides critical care and pharmacy services to millions of patients with rare disease states and complex, chronic conditions.

The actual salary an employee can expect to receive, plus bonus pursuant to the terms of any bonus plan if applicable, will depend on experience, seniority, geographic location, and other factors permitted by law. To review benefits, please visit jobs.walgreens.com/benefits More Company information is available at www.walgreensbootsalliance.com .

**Job ID:** 1580256BR

**Title:** Senior Financial Analyst – Pharmacy Reimbursement

**Company Indicator:** Walgreens

Employment Type:

**Job Function:** Finance/Accounting

**Full Store Address:** 200 WILMOT RD,DEERFIELD,IL 60015

**Full District Office Address:** 108 WILMOT RD,DEERFIELD,IL,60015-05145-01108-2

External Basic Qualifications:

+ Bachelor’s degree and at least 1 year of experience in an analytical role in finance, accounting, business management, quantitative analysis or economics or High School Diploma/GED and at least 4 years of experience in an analytical role in finance, accounting, business management, quantitative analysis or economics.

+ Experience with financial analysis, financial modeling, profitability analysis and/or auditing techniques.

+ Experience using time management skills such as prioritizing/organizing and tracking details and meeting aggressive deadlines of multiple projects with varying completion dates.

+ Experience with analyzing and reporting data in order to identify issues, trends, or exceptions to drive improvement of results and find solutions.

+ 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 Word (for example: inserting headers, page breaks, page numbers and tables and/or adjusting table columns).

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

+ Willing to travel up to 10% of the time for business purposes (within state and out of state).

Preferred Qualifications:

+ Master’s Degree or MBA

We will consider employment of qualified applicants with arrest and conviction records.

Shift:

Store: