The Senior Pricing Analyst will conduct complex financial modeling by collecting and analyzing data to make underwriting and pricing recommendations. This position will provide consultation and analytic insight to other pricing analysts as well as internal and external stakeholders. Additionally, this position will lead the data analytics, collaborate with internal business partner 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. Assist other Pricing & Finance Analysts with the preparation of analysis.
- 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 leading consistent tracking, analysis, reporting, automation efforts, and implementing 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 answerable for the results portrayed by that analysis.
- Utilizes and creates 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.
- Utilizes knowledge of healthcare industry, managed care or prescription drug industry to provide reimbursement rate recommendations based on complex pricing models for billion 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).
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
- Bachelor’s degree in Finance, Economics, Accounting, Math, Business, Actuarial Science, or Pharmacoeconomics and 1 year of work experience in Pharmacy Benefit Mangement (PBM), Contracting, Finance, Account Management or Pricing, OR high school diploma/GED and at least 4 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.
- 1+ years of pricing/financial analysis or related experience, including- 1+ years of experience using Excel for financial data analysis and/or financial modeling.
- 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).
- Advanced level skill in Microsoft Excel (for example: using AVERAGE function, merging and centering cells, printing centered page and/or creating a pivot table).
- 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).
Advanced pricing and profitability modeling experience preferred.
An employee in this position can expect a salary rate between $79,300 and $127,000 plus bonus pursuant to the terms of any bonus plan if applicable. The actual salary will depend on experience, seniority, geographic location, and other factors permitted by law. This job posting will remain open for 5 days from the job posting date. To review benefits, please click here jobs.walgreens.com/benefits. If you are applying on a job board or unable to click on the link, please copy and paste this URL into your browser jobs.walgreens.com/benefits.