Job added in hotlist
Applied job
Contract job
Recruiter job
Employer job
Expanded search
Apply online not available
Similar Jobs
EPL Underwriter
Great American Insurance Company
Schaumburg, IL
Apply Now >
Senior Analyst, Rx Pricing \u0026 Underwriting
Walgreen Company
Deerfield, IL
Apply Now >
Vice President, Regional Underwriting Manager
The Chubb Corporation
Chicago, IL
Apply Now >
Chicago, IL
Apply Now >
Management Liability (D&O) Underwriter
Chicago, IL
Apply Now >
View more jobs in Deerfield, IL
View more jobs in Illinois

Job Details

Senior Analyst Rx Pricing amp Underwriting

Deerfield, IL

Apply for this job


Senior Analyst, Rx Pricing & Underwriting
Show me jobs like this one
Job Ref:
Illinois (IL)
Position type:
Job Summary
The Senior Analyst, Rx Pricing & Underwriting will be responsible for conducting complex and high-value financial modeling through data collection and analysis to make pricing and underwriting recommendations. This position will provide consultation and analytic insight to other pricing analysts as well as internal and external stakeholders. Additionally, this position will take a lead role for data analytics and discovery on the team, collaborate with internal business partners to develop financial forecast models and supporting documentation, mentor and coach other pricing analysts, 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).

Walgreens, one of the nation's largest drugstore chains, is included in the Retail Pharmacy USA Division of Walgreens Boots Alliance, Inc., the first global pharmacy-led, health and wellbeing enterprise. More than 10 million customers interact with Walgreens each day in communities across America, using the most convenient, multichannel access to consumer goods and services and trusted, cost-effective pharmacy, health and wellness services and advice. Walgreens operates 8,175 drugstores with a presence in all 50 states, the District of Columbia, Puerto Rico and the U.S. Virgin Islands. Walgreens omnichannel business includes Approximately 400 Walgreens stores offer Healthcare Clinic or other provider retail clinic services.

As the neighborhood drugstore and retailer, our goal is to make health and happiness simpler, easier and within reach. And we remain a trusted wellness provider offering convenient access to important health services, such as immunizations and an array of pharmacy services that can help patients improve their health. To our team members, Walgreens represents a unique opportunity to excel in their careers in a welcoming and inclusive environment. We offer the chance to work in a truly supportive environment, and be a part of a progressive organization dedicated to the well-being of our customers, team members and the communities we all call home.

Basic Qualifications
Bachelor's Degree in Finance, Economics, Accounting, Math, Business, Actuarial Science, or Pharmacoeconomics and 1 year of work experience in Pharmacy Benefit Management (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).
Preferred Qualifications
Advanced pricing and profitability modeling experience preferred
Experience analyzing and manipulating Pharmacy and/or Medical datasets and trend forecasting specific to Specialty Pharmacy
Strong pharmaceutical and healthcare acumen with specialty pharmacy experience

Company info

Sign Up Now -

Similar Jobs:
Primary Job Duties & Responsibilities General Responsibilities: Underwriting new and renewal business. Building and maintaining productive relationships with agents and brokers. Consistently achieving budgeted financial results...
77 West Wacker Dr (35012), United States of America, Chicago, Illinois At Capital One, were building a leading information-based technology company. Still founder-led by Chairman and Chief Executive Officer Richard Fairbank, Cap...
AVP, Management Liability - Technical Underwriting - Private and Not-for-Profit Companies','180006SK','!*! Job SummaryZurich North America is currently looking for an experienced Assistant Vice President of Private and Not for Pro...
The number of jobs listed on EmploymentCrossing is great. I appreciate the efforts that are taken to ensure the accuracy and validity of all jobs.
Richard S - Baltimore, MD
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
UnderwritingCrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
UnderwritingCrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2018 UnderwritingCrossing - All rights reserved. 169