Finance Assit Analyst (Proficient in Microsoft Excel with the ability to quickly learn SAP CRM/BW

October 29, 2020
Chicago, IL
Job Type


Job Title: Finance Assistant Analyst (Proficient in Microsoft Excel with the ability to quickly learn SAP CRM/BW)

Location: Chicago, Illinois : 60661

Duration: 12+ Months Contract/ Can be extended

Pay Rate: $21/hr

Monday-Friday, 8am - 5 pm



Job Description:

·         This is your opportunity to take your financial and analytical skills to the next level with endless possibilities!

·         The Financial Assistant Analyst will be a key finance contact for the North American Nutrition and Gatorade Sales teams. The Finance Assistant Analyst will provide entry and verification support for Sales' customer trade execution plans.

Responsibilities Include:

·         Monitor events processed through new SAP interface from Sales-managed Sales Planner and complete any exception entry required in SAP Trade Promotion Management

·         Analyze customer event changes within Sales-managed Sales Planner and execute necessary updates within SAP Trade Promotion Management

·         Develop understanding of NAN/ Gatorade sales sell-in calendars and contracts to ensure financial records match sold-in promotional details

·         Develop PepsiCo specific financial skills in SAP, BPC, and Excel to support accurate and effective communications to Sales and Sales Finance, and, promote future career progression

·         Build positive working relationships with Sales Customer Managers; communicate contract exceptions via weekly calls/emails. Work requires leveraging Intermediate Excel skills, written communication and analytic skills to identify and obtain timely resolution of event variances by NAN/ GAT Sales team members.

·         Develop BeX/BW bi-weekly SAP transaction reports to Sales Finance Analysts to initiate approval of financial trade accruals

·         Monitor and support downstream needs of our Customer Financial Service partners

Qualifications/Requirements Education/Certification:

·         Bachelor’s Degree Required (Finance or Accounting preferred)

Work Experience:

·         1-2 years of finance analyst experience

Skills & Capabilities:

·         Excellent analytical skills and the ability to translate analytical findings into actionable solutions and processes

·         Ability to function well in a team corporate environment

·         Solid demonstration of corporate finance and accounting standards sufficient to support daily decisions, and career progression

·         Strong verbal and written communication skills to manage information gathering requests

·         Results oriented with the ability to complete assignments in a timely manner

·         Ability to handle multiple priorities

·         Proficient in Microsoft Excel with the ability to quickly learn SAP CRM/BW software applications

·         Aptitude to work with minimal supervision

·         Detail-oriented; organized in approach and in document maintenance

Only registered members can apply for jobs.

Related Jobs

Bartender   Downers Grove, IL new
November 28, 2020
Prep Cook   Chicago, IL new
November 28, 2020
Food Server   Chicago, IL new
November 28, 2020
Server   Oak Lawn, IL new
November 28, 2020
Bar Back   Chicago, IL new
November 28, 2020