Green Coffee Training & Reporting Manager

At Tata Consumer Products Ltd, we stand #Forbetter – Planet, Sourcing, Nutrition, Communities. And #ForBetter Opportunities …. Here’s an exciting one!

How does this Job align to our Strategy?

At the core of Tata Consumer Products' business approach lie six strategic pillars that serve as the foundation for its growth and success: Strengthening & Accelerating our Core Business, Driving Digital and Innovation, Unlocking Synergies, Creating a Future-Ready Organization, Exploring New Opportunities and Embedding Sustainability.

This job opportunity closely aligns with one of these key strategic pillars, which is Strengthening & Accelerating our Core Business. The role involves harnessing data to create analysis and reports that offer insights and drive decision making. Accuracy and timeliness are critical factors for successful trading and therefore the role is paramount to controlling cost and maintaining competitiveness in the market.

Top dimensions :

• Direct reports: 0
• Matrix Reports : NA
• Type of Role : Analyst

What are the Key Deliverables in this role ?

Financial Outcomes:

• The role shares in the departmental responsibility of delivering on the budgeted “C” and Diff rates while maintaining the costs related to executing the hedging program at the benchmark levels defined in the Risk Management Policy.

Customer Service / Internal Processes / Innovation and Learning

Core Requirements:

This role is critical to the Green department’s ability to execute aggressive and timely trades and properly report on its financial outcomes.

The following responsibilities all directly impact trading and/or financial reporting:

• Lead Reporting and Analysis for the department, ensuring accuracy and consistency of various position management reports that are critical to purchasing strategy execution:

• Futures and Options Report.
• Economic Stock Position Report.
• Green Position Statements.
• Green Planning Position Statements.
• *Responsibility where BOT failures occur, trouble shoot and reports must be run manually.
• Ownership/Lead of the preparation of the Departmental Budget and LE reporting.
• Additionally, prepare monthly variance analysis, giving detailed explanations of significant variance drivers.
• EO Monthly Financial Reporting.
• Review, troubleshoot, validate monthly Financial Derivative workpapers (Step 1 & Step 2).
• Prepare key elements of Quarterly reporting.
• Performance to market.
• Supply and Demand compilation.
• Execute Price fixations.
• Serve as Primary point of contact for iRely (Error tickets and Development of new workflows as required by Department)
• Prepare ad-hock analysis as required by the Head of Coffee Trading.
• Ideation and development of new insightful analysis as per the requirement of the department.
• Monitor relevant BOTS and coordinate restoring of functionality after failure.
• Review and reconcile Supplier Invoice Variances.
• Participate in market strategy team discussions.
• Support Data requirements for Internal Audit.

Secondary (Backup) Requirement:

• Serve as a Backup to Physicals Buyer.
• Serve as Backup for Derivatives trading as per defined strategy.

Cross Departmental Collaborative Requirement:

• Work closely with the Procurement team to ensure proper physical forecasting of green coffee.
• Coordinate troubleshooting and maintenance of non-Departmental actively used BOTS.
• Probat BOT.
• Daily Exception BOT.
• Production Schedule BOT.

Requirements

What are the Critical success factors for the Role ?

• Advanced Excel Skills.
• a. The ability to create repeatable and intuitive templates to facilitate processes and decision making.
• b. The ability to troubleshoot existing template errors, tracing source or error.
• A thorough understanding of the coffee market as well as the mechanics of the coffee buying and hedging process.
• Strong financial background, in order to serve as liaison between Green Procurement department and Finance department.
• a. Understand the implications and be able to bridge Green coffee transactions to their respective impact on the P&L and Balance sheet.
• Knowledge of SQL so as to facilitate the development of new custom queries (Dashboards) that the department may require.
• Strong analytical ability to implement high value solutions to meet departmental requirements.
• Good communication skills.

Benefits

At Tata Consumer Products, we offer our employees:

• Medical, Dental, Vision
• Employee Assistance Program (EAP)
• 401K Match
• Employee Referral Bonus
• Employee Discounts on local and national retailers

We are obsessed about keeping Consumers & Customers first in our hearts – that’s why we are here !

We are trailblazers in executing with Excellence … Together as One Team !

We take Ownership of our business …delivering value for our Stakeholders .. no Compromises !

We are Open to Continuously improving … Continuously innovating … For Better !

We live & breathe our Tata Code of Conduct