Senior Analyst, Data and Business Reporting

| North Suburbs

Job Summary

Responsible for using advanced SAS and data management skills to develop and maintain the internal framework by which the Pharmaceutical Development Retail Strategy Group provides analysis and reporting.  Compiles data and information to provide analysis support for all Retail Strategy opportunities. Provides decision support on business development opportunities generated within Retail Strategy such as rebates and pharmaceutical development service programs.  Evaluates business opportunities proposed by pharmaceutical manufacturers or Retail Strategy team financial analysis and modeling. Analyzes the performance of existing contracts and making recommendations to maximize performance.

Job Responsibilities
 

  • Develops and maintains reporting and analytics infrastructure for team using advanced technical skills.
  • Develops and maintains SAS based programs to optimize efficiency of program performance and outcomes.
  • Cross-functional collaboration between Pharmaceutical Development Retail Strategy and internal enabling functions as well as external service providers needed to develop, implement and manage reporting requirements.
  • Leads the design of analysis plans and protocols to satisfy program objectives for each Retail Strategy program.  Coordinates the development of tailored reporting packages, measuring of program performance against established goals, and coordinates the reporting of such results to all internal and external stakeholders.
  • Acts as liaison between Pharmaceutical Development Retail Strategy team, NPAD Team and the core enabling groups across Walgreens, as well as external service providers needed to develop, implement and manage reporting and analytics.
  • Analyzes and reports, both internally and externally, on the performance and outcomes of manufacturer sponsored programs as well as program offering recommendations.
  • Creates reports to provide actionable information to the Retail Strategy group and forecasts to assist Walgreens business units with business planning and strategy.
  • Assists the Retail Strategy Group in pricing all new proposals (RFPs) for distribution and service programs with pharmaceutical manufacturers to ensure profitable deals are created.  Evaluates bids and proposals to assist Retail Strategy Group with business development decisions related to pharmaceutical manufacture opportunities.
  • Collaborates with internal/external vendors to provide web-enabled access to program performance.  Collaborates with department Directors to effectively translate departmental reporting needs into tactical resources and deliverables to be used internally and with external customers and stakeholders.
  • Assists in budgeting and forecasting all revenue streams related to pharmaceutical manufacturer agreements.

External Basic Qualifications

 

  • Bachelor’s Degree and at least three (3) years experience in an analysis role to include leading the design of analysis plans.
  • Experience collaborating with internal and external resources to develop strategies that meet department goals within budget and established timelines.
  • 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 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).
  • Advanced programming and technical skill in SAS.
  • Experience using time management skills such as prioritizing/organizing and tracking details and meeting deadlines of multiple projects with varying completion dates.
  • Experience communicating both verbally (on phone, one-on-one, to groups) and in writing (emails, letters, reports, presentations) to various audiences (work group, team, company management, prospective acquisitions, external clients.
  • Experience with analyzing active programs to identify issues, trends, or necessary improvements to capitalize on overall team strategy and drive results.
  •  Willing to travel up to 10 percent of the time for business purposes (within state and out of state).

Preferred Qualifications

 

  • Experience working on cross-functional teams and indirectly managing teams across business units.
  • Experience in economic modeling with the ability to synthesize information into meaningful conclusions and tactical recommendations.
  • Advanced level skill in Microsoft Excel (for example: using AVERAGE function, merging and centering cells, printing centered page and/or creating a pivot table).
  • Advanced level skill in Microsoft Access (for example: modifying default field properties, creating a sub form, adding a control button, modifying query criteria and query totals, using conditional formatting and/or viewing data relationships).
Read Full Job Description

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PerlLanguages
    • SqlLanguages
    • MVCLanguages

Location

Developed and diverse suburb in N.Chicago. Opening our new Tech Office downtown at the Old Chicago Post Office in January 2020!

An Insider's view of Walgreens

What’s the vibe like in the office?

You can expect to be challenged, every day. You can also expect an extraordinarily diverse environment of collaborative professionals who are putting their talents together to fulfill the vision and mission. There are plenty of opportunities to make an impact, to grow and to learn with the team. The future of Technology is bright at Walgreens!

Carlos

Director, RunOps

How do your team's ideas influence the company's direction?

We are faced with a host of rapid changes occurring in the healthcare and retail landscapes.. To make the most of these changes, Walgreens is adapting to the fast moving technology world of today and is committed to deploying cutting edge solutions to support our business and customers.

Doug

Senior Product Manager, Pharmacy and Retail Operations

What are Walgreens Perks + Benefits

Walgreens Benefits Overview

Walgreens offers a wide variety of benefits to eligible team members designed to support your physical, financial, and emotional well-being while helping you balance work and life. In addition to company-paid life insurance and voluntary life & personal accident insurance, the benefits below are available to our team members. To learn more visit https://jobs.walgreens.com/benefits.

Culture
Volunteer in local community
Walgreens is proud to be a Corporate Social Responsibility leader, setting the pace on some of the most important issues of our day, and our IT and digital teams are no exception.
Friends outside of work
Intracompany committees
To learn more visit https://jobs.walgreens.com/it-culture
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Every day, in a multitude of ways, the foundational principles of integrity, respect and fair dealing embraced by our founder Charles R. Walgreen inspire us.
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Walgreens employees can contribute up to $500 annually to their FSA.
Disability Insurance
Dental Benefits
For dental coverage, you may choose from four plan levels ranging from a basic-only option to those with orthodontia and other major service coverage.
Vision Benefits
There are three levels of benefits for vision coverage ranging from an exam-only discount option to an enhanced PPO with both in and out-of-network benefits.
Health Insurance Benefits
You have access to competitive coverage options through the Benefits Support Center, which is the Walgreens private corporate exchange.
Life Insurance
Benefit-eligible team members are eligible for company-paid term life insurance at a benefit equal to: • 1.5 times annual base salary and $25,000 for all other hourly-paid team members
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Child Care Benefits
Generous Parental Leave
Remote Work Program
Our remote work program includes work from home Work remotely 2 days per week and/or work remotely on occasion as needed.
Family Medical Leave
Vacation & Time Off Benefits
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Acme Co. hosts company outings Annually.
Game Room
Our game room includes Ping Pong, Foosball.
Parking
We offer employees Free on-site garage parking.
Professional Development Benefits
Lunch and learns
Renewal host weekly Lunch and Learns on topics selected by our team.
Promote from within
Customized development tracks

Additional Perks + Benefits

Walgreens offers a wide variety of benefits to eligible team members designed to support your physical, financial, and emotional well-being while helping you balance work and life. To learn more visit https://jobs.walgreens.com/benefits.

More Jobs at Walgreens58 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Operations
Product
Project Mgmt
Data + Analytics
new
North Suburbs
Product
new
North Suburbs
Developer
new
North Suburbs
Product
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Developer
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Project Mgmt
new
North Suburbs
Operations
new
North Suburbs
Developer
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Developer
new
North Suburbs
Data + Analytics
new
North Suburbs
Data + Analytics
new
North Suburbs
Operations
new
North Suburbs
Developer
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Operations
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
North Suburbs
Developer
new
Chicago
Data + Analytics
new
Chicago
Operations
new
Chicago
Operations
new
North Suburbs