Analyst Sr Financial - Loyalty Marketing Walgreens Advertising Group

Walgreens; Deerfield (IL); On-site; USD 65,000 - 130,000; Full time

Job summary

Walgreens in Deerfield, IL is seeking an experienced financial analytics professional to develop and interpret complex financial models supporting decisions on new product development, portfolio profitability, capital investments, and revenue forecasting. The role emphasizes forecasting, scenario analysis, budgeting, and providing actionable insights to management.

You will prepare monthly financial statements, analyze variances, build tools using SAS or Excel, and guide junior analysts.

Qualifications

• Bachelor’s degree or HS diploma with 4+ years of analytical experience in finance, accounting, business management, quantitative analysis or economics.
• Experience with financial analysis, financial modeling, profitability analysis and/or auditing techniques.
• Intermediate level skill in Microsoft Excel (SUM, formatting, charts, sorting, headers/footers, print scaling).
• Willing to travel up to 10% of the time for business purposes (within state and out of state).

Responsibilities

• Develops complex financial models to support management decision-making related to new product development, profitability of opportunities, capital investments, revenue models and regulatory changes.
• Develops recommendations for management decision-making.
• Performs moderate to complex financial analysis and builds tools to fulfill reporting needs.
• Assists in long-range financial planning and collaborates with Walgreens to implement strategic initiatives.
• Reviews monthly financial results, identifies trends and variances, and reconciles accounts with other departments.

Skills

Financial analysis

Financial modeling

Profitability analysis

Time management

Education

Bachelor’s degree

High School Diploma

Master’s Degree or MBA

Tools

Excel

PowerPoint

Word

SAS

Job description

Job Summary

Develops complex financial models to support decision making related to complex business issues including new product development analysis, product portfolio analysis, and profitability of new opportunities, impacts of regulatory changes, capital analysis, revenue models and profit margin analysis. Emphasis on forecasting, analyzing current performance through the creation and monitoring of product metrics, and conducting prospective and ongoing economic analysis of products including marketing programs, product pricing, business initiatives and services. Prepares and analyzes the monthly financial statements and reports to produce forecasts of business, industry and/or economic conditions for use in making sound business decisions. Analyzes and reports on the financial impact of current and proposed programs. Fulfills complex analysis needs. Assists in driving change as needed to improve financials for the organization and/or to assist in the response to complex Request for Proposals questions where required. Builds analytical tools to gain efficiencies in financial modeling as required. Provides guidance and feedback to other analysts on the team.

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) proudly serves nearly 9 million customers and patients each day across its approximately 8,500 stores throughout the U.S. and Puerto Rico. Walgreens has approximately 220,000 team members, including nearly 90,000 healthcare service providers, and is committed to being the first choice for pharmacy, retail and health services, building trusted relationships that create healthier futures for customers, patients, team members and communities.

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.

Salary Range: $65000 - $130000 / Salaried