Data & Consolidation Analyst

You will support the sales team to prepare and undertake analysis of sales data to support in decision making.

A day in the life…

As the successful candidate, a typical day will focus on

Support Management of Business Performance:

Promote understanding of the business drivers using KPIs and comparative benchmarking
Support understanding and identification of KPIs achievement/gaps versus plans
Establish and promote clear accountabilities around target achievements and KPI delivery and performance
Ensure daily, weekly, monthly and quarterly reviews and support internal business partners on decisions around appropriate corrective actions
Ensure decision making balances the short term with long term value
Preparing and circulating Month To Date / Year To Date Sales Update and Total Trade Spend Report for Sales, Finance & MD
Develop and maintain sales performance reports, in a manner to establish brand, category and competitor trends and insights -dashboards, and forecasts to provide actionable insights to the sales team and management.
Periodic circulation of developed reports as per requirements (ranging from daily, weekly, monthly) -Enhanced engagement of stakeholders to ensure take outs are actioned.
Maintain Sales Database: Update and maintain the sales database while ensuring data integrity and accuracy. Data safety credentials and controlled access system
Assist in Sales Reporting: Prepare and generate sales reports, including sales performance, inventory levels, and customer analytics. Provide regular updates on sales metrics to the sales team and management.
Preparing and completing Presentation Slides (Townhall, Dynamic Forecast Slides, Ad Hoc slides etc.)
Ensure Execution of value chain mapping, Pricing Policy/Margin in-line with Agreed Strategies
Challenge pricing: benchmark against competitors’ prices; reflect value propositions of products; improve price through product mixes; and are linked to internal P&L
Consolidation of Joint Business Plans to evaluate customer efficiencies, effectiveness and return on investments
Support Monthly Business Planning process – Monthly Sales Review Analytics.
Track & Review all the Sales related Policies.
Ensure all Contract and Customer files, bank guarantees etc are well kept
Preparing Trade-activity Post Evaluation tracker and ensuring timely post evaluation process & Drive Quarterly Review meetings.

What will make you successful

University degree in Finance/ IT-Data Analytics / Business Administration
Minimum 3-years’ experience in finance with a background in sales.
Proven data analyst experience (2+ years) with proven track record in leveraging large complex data sets for driving business results.
Functional expertise regarding data models, database design development, data mining and segmentation techniques.
Experience in data visualization and dashboarding, PowerBI.
Prior exposure to SAP.
Expertise in Excel.
Strong critical thinking, analytical skills, and detail oriented with strong organizational skills.
Strong project management and stakeholder management skills.
Able to collaborate internally & externally.

Apply via :

jobdetails.nestle.com