Finance Associate Analyst
PepsiCo
Mississauga, ON
Auto req ID: 182771BR
Job Description
PepsiCo Canada employs nearly 10,000 Canadians and is organized into two business units - PepsiCo Beverages Canada, which includes brands such as Pepsi, Gatorade and Tropicana; and PepsiCo Foods Canada, which includes Frito Lay Canada and Quaker foods & snacks. PepsiCo Canada, in turn, belongs to the global PepsiCo, Inc., family.

At PepsiCo Canada, we're committed to achieving business and financial success while leaving a positive imprint on society - delivering what we call Performance with Purpose. Performance with Purpose is at the heart of every aspect of our business.

Our people are our greatest asset. By supporting their ability to work effectively together and providing them with the tools they need to succeed, we are ensuring that PepsiCo Canada is the kind of company where talented people of all backgrounds want to work.

Position Summary :
The Financial Associate Analyst contributes to the Pepsi Beverages Company’s success by acting as an integral part of the Canadian Business Unit Finance team, supporting the Customer Accounting Team and functional sales leaders. This analyst role provides both technical and business support and will work to enhance our controls. Success in this role will require results-driven behavior, strong communication skills, solid organizational skills, a compliance mindset, intellectual curiosity, analytical thinking, technical strength and the ability to be both a team leader and member.

Key Responsibilities :
Manage and maintain periodic partnership funding calculation, booking and billing process.
Maintain strong relationship with external partners including review of funding calculation and billing invoices.
Perform Bi-annual audit for partnership warehouse customers.
Perform bi-monthly customer trade reconciliations for several Retail and FS customers including review of Contracts, Prosper and other aspects of the customer trade spend.
Work with KAMs to prepare year end accrual for select accounts.
Work with KAMs and AR on processing deductions and payments related to the above accounts and highlight any risks / gaps.
Support daily & weekly reporting as required
Support the period end trade spend booking processes
Support YE accrual trade spend processes and FIFO tracking and reporting.
Reconcile balance sheet accounts each period and present at quarterly balance sheet review highlighting any risks and opportunities
Support Franchise Bottler trade spend bill-back process including the preparation of quarterly invoices.
Understand and adhere to all aspects of Global Control Standard trade spend guidelines
Support team as required
Qualifications/Requirements
University degree in Accounting / Business an asset
Experience in consumer products industry an asset
Strong customer relations, interpersonal and verbal and written communications skills
Strong organizational and multi-tasking skills with a keen eye for detail and accuracy
Experience in formal/informal team leadership
Strong technical, problem solving, and analytical skills
Advance Microsoft Excel skills including visual basics are a key requirement
Previous experience in Smartview/Essbase, Oracle GL, Prosper and Maxtrac software an asset
Ability to work independently with minimal supervision
Ability to act with integrity and in a professional manner
Ability to work well under pressure and meet deadlines
Relocation Eligible: Not Applicable
Job Type: Regular