RGM & BI Analyst at Mondelez International

How You Will Contribute

You will:

• Define requirements for analysis in a given business area and perform detailed analysis and identify trends defined in the requirements
• Identify patterns and help the business react to changing business conditions
• Perform root-cause analysis and interpret data
• Work with large amounts of data such as facts, figures, and mathematics/formulas and undertake analytical activities and delivers analysis outputs in accordance with customer needs and conforming to established standards
• Understand and be involved with aspects of the data science process
• As the investigator on the data science team, you will apply your knowledge of languages and pull data out of SQL databases, using Tableau/Power BI type tools, and producing basic data visualizations and reporting dashboards

What You Will Bring

A desire to drive your future and accelerate your career and the following experience and knowledge:

• Knowledge of Microsoft Excel, Power BI, SQL,R, Python, SAS software, Google Analytics, Google Tag Manager, Tableau, Google AdWords, statistical software
• Moderate knowledge in math and statistical skills, strong business acumen, moderate computer science/coding skills
• Develop key performance indicators and create visualizations of the data
• Utilize business intelligence and analytics tool

More About This Role

• Revenue Growth Management (RGM) at Mondelez is a key organizational priority to drive superior, healthy growth over the long-term. It is acknowledged as a critical capability in driving competitive advantage.
• The role will analyze key data necessary for driving essential business intelligence, reporting, analytics and commercial modelling in aid of supporting Mondelez business priorities, in line with Revenue Growth Management levers and initiatives.
• The role will be responsible for the development, analysis and maintenance of RGM and RTM projects and tools. The candidate will be required to work cross-functionally and will play an important role in using both internal and 3rd party data to present key analysis and insights to track business performance and impact of RGM levers and initiatives. The role will drive collaboration within the business through providing and leveraging the insights from data analytics to influence key stakeholders and positive business outcomes. The overall function assists the business by empowering them with intelligence that will result in better decision-making and organizational performance.

What you need to know about this position:

This position (reporting to the RGM & BI Lead – South Africa) will drive the business forward by increasing insight and access to data as well as increase the capability and role of RGM by supporting and driving superior, healthy growth within the South African (“Market”) including BLNS. Specifically, this role will:

• Gather, analyze and report on internal & external data sources, including SAP BI, Smollan, Nielsen, Spar Insights, Data Orbis, plus any other external data sources having the potential to impact and drive business forward business performance
• Drive the adoption of business intelligence as an integral step in helping key stakeholders stay updated with their business performance by proving timeous and accurate information of their customers, categories, segments, product portfolios, etc.
• Support the establishment, alignment, and delivery of the market’s ambition, approach & strategic roadmap for RGM
• Provide in-depth analysis in order to uncover and unlock RGM insights and sized growth opportunities.
• Support in the management, maintenance & implementation (as required), best-in-class RGM methodologies, processes & technologies to ensure the market has the right access to data, analytical & evaluation tools.
• Work with & support regional team to drive specific work tracks & ad-hoc projects in market as and when as required
• Have a good understand of the Perfect Store/Right Store principals, drive execution through reporting that supports the overall business objective.

What extra ingredients you will bring:

• RGM understanding and expertise in concepts such as pricing, mix management, promotional optimization and return on investment.
• Thorough commercial understanding and understanding of the FMCG industry, categories, and key markets within BU.
• Ability to effectively plan, prioritize, execute and follow-up in a timely manner and anticipate problems and roadblocks.
• Highly analytical with a proven history of using data analytics to build insights and action in order to solve business issues and influence key business decision makers.
• Strong quantitative and qualitative analysis skills
• Strong communication and presentation skills
• Prioritization and time management
• Agile and able to work effectively under pressure and within tight timelines
• Cross-functional collaboration to achieve desired business and project outcomes (Marketing, sales, finance, consulting)

Education / Certifications:

• University Degree qualified preferably in Commerce, Marketing, or related discipline (e.g. Finance)
• Minimum of 5 experience in the FMCG industry
• Experience in working with large data sets, reports and dashboard development
• Experience in operational planning/revenue management roles
• Excellent working knowledge of Excel (creating Pivot tables, VLOOKUPS, etc. is a must)
• Intermediate experience in implementation of systems, digital technologies, data analytics and development of models with commercial insights
• Excellent systems knowledge (SAP, Microsoft, etc.) a must
• Familiarity with creating and maintaining processes efficiently as well as updating and maintaining SOP documentation

Job specific requirements:

Assist in leading the establishment, alignment, and delivery of the market’s ambition, approach & strategic roadmap for RGM:

Lead & enable the Market to analyze, uncover and unlock RGM insights and sized growth opportunities:

• Support in executing & facilitating deployment of Advanced RGM training within the Markets (i.e. playbooks, tools & methodologies), including assisting with tailoring the localization of training materials where necessary.
• Support / lead RGM project deep dives or ‘sprints’ across prioritized Market categories to unlock further growth opportunities and prioritize executional plans inclusive of leveraging regional and / or global learnings & initiatives.

Entrench RGM as ‘business as usual’ through the cross-functional commercial planning process:

• Support development of RGM Market blueprint by category; process establishment including setting and reporting on KPI’s and preparation of plans for AC/SP horizons; required analytical and digital capabilities / enablers; ensure ongoing governance.
• Maintain market governance of RGM – including Price protocols and agreed KPI delivery.

Ensure the market has access to accurate and updated data, analytical tools, and best-in-class RGM methodologies & technologies:

• Understand regional vs market data requirements to enable best practice RGM and partner with local I&A/D&A teams to ensure an ongoing level of quality and sufficiency
• Support with scope, development and implementation of Market RGM systems, digital & analytical needs and support MDS.
• Leverage best practice tools and technology in RGM and where appropriate pilot in-market through RGM Domain expertise (use & outcome)
• Support Market adoption and best practice implementation of RGM digital platforms and tools
• Build required relationships with relevant cross functional teams & leaders within the Market
• Support in managing RGM relationships with all external RGM partners within the region including Customer and service provider engagement and support for Sales Teams
• Directly supports the Category Revenue Managers with work tracks & ad-hoc projects as required
• Track RGM projects and initiatives and co-ordinate ad-hoc work when support is required
• Elevate internal and external data and processes to support the functional requirements and progression of perfect store

Drive Best in Class reporting & systems, this would include weekly / Monthly / Quarterly and annually

• Monthly sales decks
• Consumption/Distributor data Dashboard
• Gross to Net Management & Reporting (aligning with finance)
• Systems and project updates
• Support full Business planning process including of RGM

Work with critical departments to streamline data and alignment

• Working cross boundary with Commercial finance and their systems and tools – SAP and Opal
• Supply Chain & IBP – Inputs on budgets and forecast, rolling up to forward views/projections
• Category finance – alignment of Category views, P&L’s and forward views / projections