Trade Spend Analyst

Overview:
**The Role**:
This position is a key member of the Trade Spend Accounting team. The role will be accountable for ensuring that the all the period end journal entries, system processes and analysis of results have been completed in timely and accurate fashion. This role is a valued business partner of the NAM/KAMs, AFDs and CDFM teams. The incumbent will drive for continuous process improvement and perform financial analysis as needed to support decisions and drive value to the business.

**The Company**

PepsiCo Canada is recognized as one of Canada’s top 100 employers. PepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world. Our product portfolio includes 22 world-famous, billion-dollar brands; from Gatorade to Quaker, Tropicana to Lay’s and more. We make hundreds of enjoyable foods and beverages that are loved throughout the world. PepsiCo's effort to help build a more sustainable food system represents a key element of the company's broader vision of accelerated, sustainable growth known as Winning with Purpose. As part of this vision, PepsiCo is striving to be a better company by further integrating purpose into the core of its business and brands and doing even more for people and the planet. Our purpose efforts include fostering a diverse and inclusive work environment, supporting the communities where we live and work, and improving choices in our portfolio through reformulations and new products.

At PepsiCo Canada, we are focused on delighting our consumers by delivering high-quality products and exciting brand campaigns. Our people are critical to our success and by supporting their personal growth and development and providing them with the tools they need to succeed, PepsiCo Canada is a company you’ll be proud to join

**What you can expect from us**:

- Competitive compensation, benefits, pension, RRSP contribution and vacation time
- A flexible working environment that promotes a healthy work-life balance
- A dynamic and inclusive culture that promotes you to bring your whole-self to work
- A supportive team that will encourage your professional growth and development
- An opportunity to be meaningful and impactful within your work and projects
- An opportunity to give back to the community with our Always on Volunteer 360 Program
- An organization that aims to use their scale, reach and expertise to build a more sustainable world

**Responsibilities**:
**What you’ll be working on**:

- Lead period end activities for Quaker to ensure accurate reporting of PFC Trade Spend Liability
- Work with Customer Accounting Manager to analyze period end results compared to plan and forecast
- Prepare period end results report out on trade related reserves, damages expense and post audit expense
- Participate in period end results review meetings with the Customer Accounting Manager
- Accurately reconcile all trade related balance sheet accounts identifying and resolving reconciling items in a timely manner
- Prepare Net Liability by Customer reporting to identify gaps in Trade Spend Liability that require analysis and action
- Lead discussion with CDFM team in resolving gaps in Net Liability by customer
- Prepare Cash Flow Trade Liability forecast on a period basis, build Cash Flow Trade Liability AOP.
- Prepare presentations and lead balance sheet review discussions on all trade related balance sheet accounts.
- Ensure compliance with SOX requirements
- Perform ad hoc financial analysis as needed

Qualifications:
**Who’s a good fit for the team**:

- Strong analytical, organizational and problem solving skills
- Advanced Excel knowledge and experienced with Advanced Analytical Tools (Tableau, Power BI)
- Strong interpersonal skills with the ability to build strong working relationships and influence others
- Solid written and verbal communication skills
- Professionalism, initiative & drive for results
- Ability to effectively multi-task, prioritize and accurately execute tasks in a timely manner
- Ability to work independently and as a team member
- MS Office proficiency (PowerPoint, Word)
- Commitment to continuous process and system improvements
- Undergraduate diploma or degree in Business or Accounting or equivalent experience
- Pursuing a CPA designation is an asset
- Experience in SAP, Oracle and MFG/Pro is an asset