Team Leader - Analytics

Hindustan Coca Cola Beverages (HCCB); Mumbai; On-site; INR 900,000 - 1,700,000; Full time

Job summary

Hindustan Coca Cola Beverages (HCCB) in Mumbai seeks a Team Leader Analytics to manage and execute advanced analytics projects at zonal and national levels. You will drive KPIs, build dashboards, and partner with operations, sales, and supply chain to convert data into strategic actions.

The role requires 5+ years in analytics within CPG/FMCG, strong stakeholder management, and expertise in data modeling and visualization. Travel up to 10% may be required. This is an on-site Mumbai position.

Qualifications

• Degree / Master’s degree in a relevant field including Business Analytics, Mathematics, Statistics, Engineering, Computer Science, MBA or equivalent experience
• 5+ years’ experience in delivering Sales, operational and strategic Analytics; Managing Analytics projects
• Cross-functional experience in CPG / FMCG or related industry; Strong stakeholder management skills and the ability to communicate analytical and technical concepts with confidence

Responsibilities

• Collaborate with key stakeholders (operations & Commercial, Support functions) to define KPIs based on analytical outputs, and identify key Cost and Revenue Drivers
• Manipulate and analyze large datasets and derive insights
• Extensive use of databases
• Work on statistical modeling techniques like – Correlation, Regression, Segmentation, Optimization
• Develop intuitive visualization using PowerBI
• Prepare executive presentations
• Work with cross-functional teams, manage stakeholders effectively and recommend operational actions
• Coordinate with zonal MIS team members to build common platforms for reports & MIS

Skills

Power BI

Excel

Data analysis

Storytelling

PPT presentations

Stakeholder management

Education

Degree / Master’s in Analytics or related fields

Tools

SAP

Margin Minder

Distributor Management System

Power BI

Job description

Job Description:

Objective: Role holder is expected to manage / execute different advanced analytics projects cross-functionally but focused more on the Zonal & National level Commercial/GT vertical.

• Expertise in building advanced analytics frameworks to deliver business impact projects driving better Sales/operations Levels and / or Optimizing costs using various data sources coming from Zones/Units /Warehouse / Depot, distributors etc,
• Exposure to various Operations solutions like – Route Optimization, QSIPs/Incentive earning opportunities ext., Expertise in Data extraction, mining, and Slicing /Dicing techniques to highlight key opportunity areas and automate reports,
• Working on cross-functional data coming from multiple sources using custom internal and industry standard tools like SAP, Margin Minder, Distributor Management System, etc,
• Hands on extensive experience in analytics tools, visualization platforms and databases.
• Advanced in programming languages for data transformation and modelling
• Ability to leverage macros/power pivots/Visual Basic to operationalize / automate analytics
• An expert in advanced excel and can leverage different excel functions, pivots, slicers and other utilities for analysis and data management to derive insights from data
• Analysing and teasing out insights from data, storyboard and create executive presentations (Good in PPT making and storytelling skills)
• Identifying key opportunity/gaps through monthly/fortnightly business reviews
• Very good interpersonal skills and can work seamlessly across various teams

Title: Team Leader Analytics

Function: Commercial

Work Location: Mumbai

Job Responsibilities:

Act as a Supporting manager for building Commercial advanced analytics - Managing All reports like DSRs, monthly report from Requirement Gathering, Data Capture, Analysis Framework, Insights Generation within the provided scope and timelines.

• Collaborate with key stakeholders (operations & Commercial, Support functions) to define KPIs based on analytical outputs, and identify key Cost and Revenue Drivers and opportunities to improve Sales/operational performance.
• Manipulate and analyze large datasets and derive insights
• Extensive use of databases.
• Work on statistical modeling techniques like – Correlation, Regression, Segmentation, Optimization.
• Develop intuitive visualization using PowerBI
• Prepare executive presentations
• Work with cross-functional teams, manage stakeholders effectively Recommend operational actions based on analytics output and build a mechanism to review execution based on recommendations
• Work with Units/ Zones for data gathering, analysis outputs etc,.
• Work as conduit between zones to ensure uniformity of data & analysis / formats. Coordinate with zonal MIS team members & help build common platforms wrt various reports & MIS

Supervises: NA

Internal Stakeholders: Corporate Business and functional teams in Sales, Commercial, Supply Chain, Finance, Procurement

External Stakeholders - Vendors and Service providers, Direct and indirect customers, Distributors

Reports To: ZVP

Job Requirements:

Qualifications: Degree / Master’s degree in a relevant field including Business Analytics, Mathematics, Statistics, Engineering, Computer Science, MBA or equivalent experience

Experience: 5+ years’ experience in delivering Sales, operational and strategic Analytics; Managing Analytics projects

• Cross-functional experience in CPG / FMCG or related industry; worked in enterprise analytics or analytics consulting areas Strong stakeholder management skills and the ability to communicate analytical and technical concepts with confidence and in an easy-to-understand fashion
• strong business acumen Travel: Up to 10% of the time