Business Analyst - Beverage Firm

PURPOSE OF ROLE

Please summarise the overall purpose of the role.

- Business Analyst will be part Analytics COE located in Bangalore. S/he will be supporting Global Marketing department in future budget planning by analyzing/developing demand forecast models and finding actionable insights.

- To implement the complex statistical solutions that the team comes up with, with sound programming and insight generation

- To make sure any roadblocks in implementation is brought to the notice of Analytics Manager so that project timelines do not get affected

- Document every aspect of the project in standard way, for future purposes

2. KEY TASKS AND ACCOUNTABILITIES

The business analyst will analyze sales trends of brands across key markets and predict the sales based on various commercial activities planned for forecast year. The Analyst will:

- Provide key operational insights to Business partners for budget planning.

- Support exploratory data analysis and hypotheses testing needs for business teams.

- Analyze historical sales data to determine level, trends, seasonality and generate appropriate statistical forecasts using R or other software.

- Develop causal forecasts driven by machine learning, market intelligence, and marketing related programs.

- Manage non-periodic events while modeling or developing forecasts

- Liaise with business stakeholders from various countries to understand changes in market conditions, the resulting impact of those changes on forecasted demand and updating forecast to reflect those changes.

- Work closely with the business intelligence team in the development and maintenance of the analytical reporting tools.

- Develop and present reports to cross-functional stakeholders detailing forecast accuracy, variances in actual sales versus forecasted demand and progress versus targeted KPIs.

- Perform other job-related duties as assigned.

3. BUSINESS ENVIRONMENT

- This is a highly visible global analytics role with tremendous potential to help drive organic value creation in a very fast paced entrepreneurial business environment

- Main Characteristics: Challenges

- Work with internal clients to understand their business problems, map them against possible data sets, develop analyses,, and provide insight back to the business based on those results

- Summarize insights and recommendations to be presented back to the business

- Use innovative methods to continuously improve the quality of the analytics

- Evaluation Criteria (Targets):

- Projects delivered on time, on budget and without business disruption

- Project final analysis and deliverables signed off by stakeholders

- Final analysis implemented and delivering the expected results

- Key Dimensions:

- Global Directors & VPs

- Zones Directors & VPs

- Key Contacts:

- Shared Services Analytics Macro-Process Lead

- Directors and VPs in Zones, BUs, and GHQ

- 3rd party suppliers as required

- Geographical Scope:

- Global (Top 20 markets)

4. QUALIFICATIONS, EXPERIENCE, SKILLS

Please list the following requirements

- Level of educational attainment required:

From Premier institutes only

- Bachelor's Degree with 2+Yrs

OR

- MBA or Post Graduate Degree with 1+Yrs experience in Data Science

- Professional qualifications and accreditations/memberships required:

- 2+ years of hands-on relevant experience in business intelligence and analytics teams

- Previous work experience desired preferably in CPG domain

- Demonstrate functional experience working with Time-Series forecasting, Market Mix Models and Demand Planning using R/Python

- Other

- Strong knowledge & application of SQL for ETL automation

- Advanced Excel skills, Excel Macros desirable

- Data visualization tools like Qlikview (preferred) or tableau & other reporting solutions

- Experience in building and maintaining data warehousing and BI solutions

- Experience in managing teams that check the integrity and accuracy of data

- Experience in leading & mentoring/training small teams

- Language skills required

- English (Fluent), Hindi (moderate fluency)