Mexico Supply FC Analyst

at  Diageo

Job Description :
Job Posting Title: Mexico Supply FC Analyst
Level: 6B
Location: Bogotá
Type of Contract: Permanent
About us:
From Arthur Guinness to Johnnie Walker, our business was founded on people of excellent character, and in 250 years, nothings changed. We’re the world’s leading premium alcohol company. Our brands are industry icons. And our success is thanks to the strength of our people, in every role. It’s why we trust them with our legacy. And it’s why we reward them with the career-defining opportunities that they deserve. Our ambition is to build the best performing, most trusted and respected Consumer Products Company in the world. To achieve these, we need the world’s very best people.
Feel encouraged? Then this may be the opportunity for you

Operation Follow up

• Follow up of open points of previous closures regarding Dry Components Cost, Liquid Cost en Profit results reporting
• Prepare weekly Process Order review files for TPOs

Lead weekly meetings with TPO Production Analysts to review issues on Process Order records

• Review weekly PPV Reports to look for possible issues regarding purchase order or prices
• Review Toll Manufacturing operation to assure financial postings for GR, GI and IR

Pre Close Analysis

• Lead monthly Preclose Agenda for liquid and Dry Component with Mexico BPs: Generating Preclose landing files vs LE for Liquid and Dry Components.
• Coordinate review meetings with BP on the Market. Follow up open points from te session to raise risk and opportunities facing the closure

Period Closing and Financial Results

• Review month end closure of Material module for TPOs: Including process order closure, STOs, Write off and any other material related movement until last working day of the month for TPOs.
• Generate Manual journal postings needed for Material Ledger Run and Allocations for Scorecard reporting
• Update Closure FP&A File (Flash OP) for download actual results during closure and reviewing possible issues before GL closure.
• ML Run and Analysis: Monthly analysis of variations against standard cost and ML posting. Control C0207 - provide variation analysis by SKU with commentaries and needs for adjustments. Support on ML Run on WD1
• Generate Closure files for Actual cost analysis for Liquid and dry component. Coordinate review meetings with Market BPs and look for the drivers of the principal variations on month result vs LE.
• Generate Recovery analysis file by cost line (Liquid, Dry components, ovh, Move) and by brand for bottling profit per case exercise
• Generate Cost per case report by Variant during month end closure

LE Generation and Analysis

• Generate YTG and FY analysis recovery file by COGS line (Liquid, Dry components, ovh, Move) and by brand for bottling profit forecast exercise
• Support conversations on profit forecast, raise risks and opportunities

Support to FC

• Audits Support: Provide evidence as required and support audit points regarding COGS reporting and variations

Projects

• Participate actively in the planning process provide insights and raise risks
• Key user for UATs testing of expansion projects and support for project managers

Inclusion&Diversity
Celebrating our inclusive and diverse culture is core to Diageo’s purpose of “celebrating life every day everywhere”. This purpose is, in itself, inclusive in nature, as it values everybody irrespective of background, disability, religion, gender identity, sexuality or ethnicity.
We know that for our business to thrive and for Diageo to realize its ambition, we depend on having diverse talent with a range of backgrounds, skills and capabilities in each of the 180 countries in which we operate and to reflect our broad consumer base. We view diversity as one of the key enablers that helps our business to grow and our values, purpose and standards set the conditions for us to respect the outstanding contribution each person brings.
Flexibility is key to success in our business and many of our staff work flexibly in many different ways, including part-time, compressed hours, flexible location. Please talk to us about what flexibility means to you and don’t let anything stop you from applying.
Worker Type :
Regular
Primary Location:
Bogota - EOB
Additional Locations :
Job Posting Start Date :
2024-08-1

Please refer the Job description for details