Senior Business Analyst

Walgreens•Deerfield, IL

5d•$65,000 - $113,750

About The Position

The Senior Business Analyst provides complex technical analytics to support Pharmacy, Health and Wellness initiatives and makes operational recommendations based on analysis. The role collects and analyzes performance data and develops reports and analyses to support decision-making. It also creates and manages database structures and analytics websites used to collect, analyze, and disseminate operational data. The analyst works with management to shape pharmacy analytics strategy, provides guidance to other analysts and business teams, and presents findings and recommendations to management at different levels. The role serves as a subject matter expert in pharmacy performance metrics, queries, reports, dashboards, and statistical analysis. It also develops and maintains databases, spreadsheets, self-service reporting tools, and automated analytics, while establishing reporting standards and ensuring data integrity.

Requirements

Bachelor’s degree in a technical or quantitative field and at least 3 years of experience in an analytical or pharmacy role, or a high school diploma/GED and at least 6 years of experience in an analytical or pharmacy role.
Experience in analytics and problem solving.
Experience querying databases.
Experience identifying operational issues and recommending and implementing strategies to resolve problems.
Experience analyzing and reporting data to identify issues, trends, or exceptions, drive improvement, and find solutions.
Experience prioritizing and organizing work, tracking details, and meeting deadlines across multiple projects with varying completion dates.
Ability to accomplish goals with little or no supervision, work independently to complete objectives, and determine when issues need escalation.
Advanced Microsoft Excel skills, such as VB macros, nested IF statements and other complex functions, advanced pivot tables, and cell formatting and printing features.
Willingness to travel up to 10% for business purposes, within and outside the state.

Nice To Haves

Experience with full-stack application development.
Experience administering or developing solutions using Microsoft SQL Server, Windows Server, Internet Information Services (IIS), Microsoft Azure Virtual Machines, Azure Data Factory, and Microsoft Fabric.
Experience working with enterprise data platforms, including Microsoft SQL Server, Databricks, Snowflake, Teradata, and Oracle.
Advanced SQL proficiency and proficiency in one or more programming languages or frameworks, such as Python, C#, HTML, CSS, JavaScript, jQuery, AngularJS, and Vue.js 3.
Experience using Visual Studio Code and Visual Studio Professional to develop, debug, test, and deploy applications.
Experience using GitHub Copilot or similar AI-assisted development tools, including agentic workflows and large language models, to improve software development, testing, documentation, and maintenance.
Experience designing, developing, and maintaining databases, tables, indexes, views, and stored procedures supporting business operations, analytics, and reporting.
Experience planning and managing projects, including scope, resources, timelines, risks, and deliverables.
Ability to build and maintain effective working relationships with stakeholders at all organizational levels.
Experience collaborating with internal and external partners to develop and implement strategies that meet departmental goals within budgets and timelines.
Advanced Microsoft PowerPoint proficiency, including creating clear, executive-ready presentations that communicate complex information effectively.
Bachelor’s degree in computer science, information systems, engineering, analytics, or a related field.
Experience in retail, pharmacy, healthcare, or another highly regulated industry.

Responsibilities

Define, design, build, and prepare daily, weekly, monthly, customizable, and ad hoc operational reports and analyses for key metrics; anticipate additional needs that could add value or improve functionality.
Collaborate with management to define broader pharmacy analytics strategy.
Mentor, coach, train, and assist analysts and colleagues in Store Operations, Pharmacy, and other Walgreens corporate teams.
Research and analyze current and past activity, expected trends, and potential effects of change; present findings and recommendations to management.
Develop and report granular metrics using knowledge of Walgreens pharmacy operations and systems such as Intercom Plus and RxI.
Evaluate data, identify and interpret trends, communicate results and recommendations to senior management, and continually review data sources, processes, and systems to ensure reporting accuracy.
Prepare graphs, spreadsheets, reports, and PowerPoint presentations.
Serve as a subject matter expert in pharmacy performance metrics analysis and in the design, development, and execution of queries, business reports, and dashboards.
Use statistical methodologies to describe and model behaviors, transaction volumes, and performance measures.
Create and maintain databases, spreadsheets, interactive self-service reporting web front ends, and other tracking mechanisms.
Review data maintenance processes to improve data integrity and redundancy and maximize available resources.
Collaborate with internal departments to initiate and implement improvements and efficiencies in analytics.
Create and maintain tools to automate analytics, such as web-based reporting; establish reporting standards and criteria and maintain data and reporting integrity.
Define reporting requirements for all levels of management and develop methodologies for calculating metrics and conducting analyses.