Data Engineer

Work with a leading FMCG Manufacturing company, and grow with its amazing team.

Our Client is the world's largest FMCG brand manufacturer and exporter with a legacy spanning over 120 years.They are India's first integrated company with a comprehensive product chain. Our client is a billion dollar top line company holding 45% market share in India and 50% share in export market.

As a Manager Global FP&A, you will be managing a multitude of responsibilities that are related to forecasting, reporting, Implementation and analytics to improve on the company's product, sales and marketing effectiveness.

What you will do:

Marketing and Sales Analytics

• Performing insightful analysis of sales performance of brands (own and competitors) to highlight key performance/ issues across area/ geographies and facilitating strategic initiatives for improvement
• Working on Measurement and evaluation of effectiveness of executed marketing promotions
• Analyzing industry growth trends vis-a-vis own brands and competitors on monthly basis. Identifying gaps, planning and designing territory specific schemes to overcome competition
• Supporting sales teams with customized data queries, analysis and reports catering to specific business needs
• Pricing analysis within brands, packs and segments to suggest a competitive price for old/ new brands

• Identifying outlet gaps in width of distribution/ availability of brands in retail, bars and clubs for the ease of the sales team to focus for the month
• Designing motivating reward schemes for the sales team with parameters of target achievement (overall volume and focus brands volume)
• Identifying outlet wise volume potential and plan monthly brand wise volumes to meet monthly regional sales plan (# of outlets 7000+)
• Evaluating sales team performance on monthly basis and computing incentive payouts and rewards
• Deriving frequency of visiting outlets basis value potential of the outlet - used to design PJP (Permanent Journey Plan) for better coverage of outlets by sales executive

• Projecting secondary sales volume for a horizon of 3 financial years and estimaing manufacturing unit requirements
• Forecasting yearly/ quarterly/ monthly/ weekly volume plans and identifying opportunities & risks
• Planning Monthly volume plan for brands and packs prediction on industry growth trends and sales inputs

• Reporting on budget achievement, growth (volume and value) for the month and year till date
• Executive summary highlighting- environmental challenges and mitigation plan, market summary (Trade, Manufacturing, Supply Chain, Sales, Marketing) on what worked well/ what can work better vis a vis action points, issues performance achievements/ issues; to be submitted to the top management of the organization

• Becoming a Project Lead for all regional implementation, requirements and smooth execution of RtC project

• Creating Segmentation of outlets based on Gross Sales Value (GSV) contribution to region
• MAking a Selection of top outlets based on value and profile of outlets to be transformed into perfect outlets
• Measuring parameters of Quality, Distribution, Visibility, Price, Promotion and Persuasion of an outlet and develop plan for improvement
• Training sales executives and third-party auditors on guidelines of retail outlet planogram and evaluating

• Measuring availability of brands in outlets on a weekly basis and providing targets to fill gaps
• Measuring and monitoring coverage of frontline sales team

• Making management presentations for review
• Preparing monthly and quarterly financial reports of various oversee distributors
• Adhering to accounting standards / ensure financial compliance in conjunction with international law and corporate accounting standards including export / import documentation as FEMA and RBI regulations
• Checking International Trade Marketing expenses inline of approval provided
• Preparing and checking Quarterly TME approval to be provided to distributors
• Creating an Analysis report on budgeted expenditure and actual expenditure of TME
• Maintaining dialogues and working relationship with overseas distributors.
• Managing receipts & vendor payments for exports receivables (AR)
• Implementing a Business Intelligence tool and dashboard reports
• Supporting management team and the Heads of Department with data-driven analysis

What you need to have:

• Either B.Tech & MBA or B.Com & MBA
• Worked on Sales Analytics for a FMCG company in food and beverage space of 500 crores plus size.
• Worked in the Domestic / Export division handling distributors, channel partners, dispensing customer and trade schemes
• Worked on sales budget analytics (revenue) as well as rationalization of spends (cost optimization of schemes)
• Possesses data collation and aggregation skills from multiple sources both internal and external to the organization.
• Comfortable working with large amounts of data and run historical analytics as well future trend progression to drive business unit objectives.
• Sales AOP, Forecast, Pricing, Expenses
• Working with Head Sales, Preparing various reports through BI Tools
• Strong Quantitative & Analytics abilities
• Experience with Global Financial Planning & Analysis
• Adaptive, willing and able to work with different time zones to get the work completed
• Advanced computer software skills, including writing macros in Excel and other accounting packages