About The Role

Job Title: Junior Manager GT Stock In Trade Data

Purpose of Role

Junior Manager / SME GT Stock In Trade Data role is based in India. The purpose of this role is

The role is designed to support and own the operational execution, governance, controls, reporting, and continuous improvement of the Stock in Trade (SIT) Reconciliation process across Global Travel customers and KCGs.
Ensure smooth and successful delivery of short- and long-term plans related to SIT reconciliations, customer balance validations, data quality controls, system uploads, reporting accuracy, and reconciliation governance.
Become the process owner and Subject Matter Expert (SME) for the SIT Reconciliation process. Ensure reconciliation cycles, validations, uploads, and reporting activities are delivered accurately, efficiently, on time, and in line with Commercial Finance and business requirements.
Act as the bridge between Commercial Finance, FP&A, Account Managers, Depletion Teams, TradeEdge teams, and system stakeholders to ensure timely issue resolution, approvals, and accurate reconciliation outcomes.
Provide analytical rigor, operational governance, and business insight to support inventory transparency, stock risk visibility, depletion alignment, and commercial decision-making.
Drive adherence to controls, audit readiness, reconciliation documentation standards, and process compliance requirements in line with year-end audit expectations.
Continuously improve reconciliation frameworks, reporting structures, validation controls, and onboarding governance for new KCGs and customers.
Ensure smooth business-as-usual operations, timely reconciliation closures, issue escalation management, and continuous stakeholder communication.
Demonstrate exceptional stakeholder management, ownership mindset, attention to detail, problem-solving ability, and leadership capability while handling cross-functional teams and timelines.
Perform any additional Commercial Data Systems or SIT Governance-related tasks as requested by the Line Manager.

Responsibilities and Skills Required

SIT Reconciliation Operations & Governance

Own and manage end-to-end SIT Reconciliation cycles across Global Travel KCGs.
Validate receipt and completeness of:
Stock on Hand (SOH) files
Depletion data
Shipment data
Stock on Water (SOW) files
Ensure reconciliations are initiated only after:
Previous cycles are closed
Required data sources are received and validated
Maintain and regularly update SIT Reconciliation Calendar and Status Tracker.
Ensure proper folder setup, audit documentation, and file governance for each KCG reconciliation cycle.
Manage reconciliation workflows for multiple KCGs simultaneously while maintaining delivery timelines and controls.

Reconciliation Preparation & Validation

Prepare reconciliation workbooks using:
Customer balance data
Depletion actuals
Shipment data
Stock on Water inputs
Validate and reconcile:
Start Stock
End Stock
Shipments
Depletions
Customer-reported inventory balances
Perform EU conversions using approved converter templates.
Identify and resolve:
Reporting brand mismatches
Product mapping issues
SOW discrepancies
Data alignment gaps
Ensure reconciliation validations are completed accurately before circulation to Commercial Finance and FP&A teams.
Conduct root cause analysis on reconciliation variances and work with stakeholders for remediation.

Anaplan Uploads & Data Maintenance

Prepare uploader files for approved customer balance adoption.
Complete SIT balance uploads into Anaplan and validate upload accuracy.
Troubleshoot upload failures, incorrect balance scenarios, and partial product-level corrections.
Ensure reconciliation uploads align with approved customer balances and audit requirements.
Maintain data integrity across:
Anaplan
DDH
GTME dashboards
Reconciliation workbooks

Stakeholder Management & Collaboration

Act as a key point of contact between:
Commercial Finance Managers (CFMs)
FP&A teams
Account Managers
Depletion Teams
TradeEdge Support teams
Commercial stakeholders
Coordinate approvals, validations, escalations, and reconciliation closures.
Drive timely follow-ups on pending customer responses, approvals, and data clarifications.
Support audit and governance discussions with commercial and finance stakeholders.
Lead and facilitate working sessions to resolve reconciliation variances and operational issues.

Data Quality, Controls & Audit Readiness

Ensure adherence to reconciliation controls, governance standards, and audit requirements.
Maintain complete documentation for:
Customer approvals
Validation evidence
Upload confirmations
Reconciliation sign-offs
Drive data quality improvement initiatives across reconciliation and depletion processes.
Identify recurring process gaps and recommend sustainable control improvements.
Ensure readiness for internal and external audit reviews.

Reporting, Analysis & Continuous Improvement

Generate operational insights on:
Stock behaviour
Inventory accumulation risks
Stop-selling risks
Artificial stock build-up
Customer inventory anomalies
Support business teams with analytical insights from reconciliation outcomes.
Continuously improve:
Reconciliation templates
Validation mechanisms
Reporting structures
Process automation opportunities
Identify opportunities to streamline reconciliation timelines and improve operational efficiency.

Must-Have Skills & Experience

Strong experience in Commercial Data Systems, SIT Reconciliation, or Depletion Operations
Experience working with integrated systems such as:
Anaplan
DDH
SAP - ECC
SAP - BW
Strong reconciliation, analytical, and problem-solving skills
Strong understanding of stock reconciliation, inventory management, and depletion reporting
Advanced Excel knowledge including:
Pivot tables
Lookups
Data validations
Reconciliation reporting
Experience managing stakeholder communication across finance, commercial, and technical teams
Strong governance, documentation, and audit control mindset
Ability to work independently in a fast-paced operational environment

Good-to-Have Skills

Experience in FMCG or Commercial Finance operations
Exposure to TradeEdge and GTME platforms
Knowledge of SOH, SOW, KCG, and depletion data structures
Experience with Power BI or reporting dashboards
Exposure to DDH and data ingestion processes
Understanding of mapping logic, EU conversions, and product hierarchies
Familiarity with audit and compliance processes
Experience working in Agile or continuous improvement environments

Success Metrics (KPIs)

Timely completion of SIT reconciliation cycles
Reduction in reconciliation variances and upload errors
Timely FP&A and Commercial approvals
Improved reconciliation turnaround time
High audit compliance and documentation accuracy
Reduction in manual correction efforts and operational escalations
Improved stakeholder satisfaction and communication effectiveness
Successful onboarding and governance of new KCG reconciliations

Qualifications & Experience Required

Functional Capabilities

5–7 years of experience in Commercial Data Systems, SIT Reconciliation, Depletion Operations, or Commercial Finance support roles
FMCG industry experience preferred
Strong stakeholder management, coordination, and prioritization skills
Excellent analytical and problem-solving skills with strong attention to detail
Strong communication skills and business English proficiency
Self-driven personality with strong ownership mindset and ability to work independently
Ability to manage multiple priorities and tight timelines effectively
Strong interpersonal and collaboration skills across global teams
Experience handling audit-sensitive operational processes
Results-oriented and capable of working in a flexible and fast-paced environment

Barriers to Success in Role

Lack of ownership, inability to manage operational timelines, insufficient attention to detail, weak analytical capability, poor stakeholder management, inability to manage audit-sensitive processes, weak communication skills, inability to proactively escalate issues, lack of governance mindset, inability to work independently, poor adaptability to changing priorities, and inability to build strong working relationships across commercial, finance, and technical teams.

Flexible Working Statement

Flexibility is key to our success. Talk to us about what flexibility means to you, so that you’re supported to manage your wellbeing and balance your priorities from day one.

Rewards & Benefits Statement

We recognise and value performance, offering our people a highly competitive Rewards and Benefits package including

Diversity statement

Our purpose is to celebrate life, every day, everywhere. And creating an inclusive culture, where everyone feels valued and that they can belong, is a crucial part of this.

We embrace diversity in the broadest possible sense. This means that you’ll be welcomed and celebrated for who you are just by being you. You’ll be part of and help build and champion an inclusive culture that celebrates people of different gender, ethnicity, ability, age, sexual orientation, social class, educational backgrounds, experiences, mindsets, and more.

Our ambition is to create the best performing, most trusted and respected consumer products companies in the world. Join us and help transform our business as we take our brands to new heights and build new ones as part of shaping the next generation of celebrations for consumers around the world.

Feel inspired? Then this may be the opportunity for you.

If you require a reasonable adjustment, please ensure that you capture this information when you submit your application.

Recruitment Scam Warning

Protecting candidates is very important to us. All communications regarding your application will come from an email address ending in @diageo.com. In our recruitment process, we'll never ask for money.