BI & Reporting Assoc Analyst

PepsiCo; Hyderabad; On-site; INR 800,000 - 1,500,000; Full time

Job summary

PepsiCo is seeking a seasoned analytics professional to support the Shopper Marketing team in tracking KPIs for campaigns and performing post-campaign deep dives. You will develop insights to optimize future campaigns and enhance shopper targeting across channels.

The role requires strong communication, collaboration, and a solid background in marketing reporting within a consumer goods context. Proficiency in Power BI and Excel is preferred, with English fluency a must.

Qualifications

• 6+ years of analytics experience in consumer goods
• Proven marketing reporting and analytics experience
• Familiarity with marketing KPI dashboards and reporting
• CPG/食品 & beverages data sources familiarity (e.g., Nielsen/IRi, GlobalData)
• Proficient with PowerPoint and Excel; Power BI knowledge a plus

Responsibilities

• Track KPIs for shopper marketing campaigns and post-campaign analyses
• Create KPI scorecards and dashboards
• Perform deep dives to generate insights for future campaigns
• Collaborate with agencies and Shopper team on reporting and budget tracking
• Support stakeholder needs with timely outputs and improved processes

Skills

Analytics

Marketing reporting

KPIs tracking

Power BI

Excel

English communication

Collaboration

Stakeholder management

Education

Bachelor's degree

Tools

Power BI

Excel

Job description

Overview

This role will support the Shopper Marketing team in the tracking of agreed KPIs of shopper marketing campaigns as well as post campaign deep dives to develop recommendations needed to optimise performance and shopper targeting of future campaigns. Using the consistent tracking of KPIs and development of recommendations.

This role will need to be highly analytical and can identify growth driving insights as well as having strong communication and collaboration skills.

Responsibilities

Functional Responsibilities:

General

• Maintain standards and ensure all SLA’s are met,
• 95% + on SLAs and 95+ on accuracy
• Maintain a positive working relationship with market to deliver value through automation, standardization and digitization
• Maintain a healthy working environment for the team and foster their growth by investing in upskilling them from time to time
• Drive process excellence initiatives

Support Shopper Marketing team with delivery of insights

• Responsible for working with Shopper Marketing stakeholders and agencies to provide regular reports on campaign performance via the creation of KPIs tracking scorecards
• Perform post campaign deep dives to unlock insights to feed into the optimization of future campaigns and development of shopper marketing pictures of success across channels.
• Work in close collaboration with agencies & Shopper team on campaign reporting and assist in budget tracking.
• Partner with Shopper leads for on-going needs including competitive analysis & creating new best practices
• Support shopper team in the launch & maintenance of the programming & generate regular and ad-hoc reports through data and customer feedback
• Create visualizations/dashboards to be used in explaining and clarifying difficult concepts and analytical insights

Support relationships with the key stakeholders & Customer teams

• Own flawless execution of analytics exercises
• Manage relationship with stakeholders, requesters and end service users
• Deliver outputs in line with the agreed timelines and formats while upd
• ating existing project management tools
• Flag and monitor any business risks related to delivering the requested outputs
• Improve existing processes based on frequent Business Partner & end-user feedback loop

Qualifications

• An experienced analytics profession in a leading consumer goods company. 6 years+ experience
• Proven experience in marketing reporting / analytics
• Familiarity with marketing reporting / marketing & media KPIs
• High degree of familiarity with CPG and Food & Beverage industry data sources, including Nielsen/IRi (POS and HH panel), GlobalData, Kantar Worldpanel, etc.
• Deep understanding of CPG industry business performance outputs and causal measures, their relationships, and how to address business questions in a robust way that translates to simple outputs
• Proficient with Power Point and Excel
• Power Bi or any visualization tool knowledge is good to have
• Strong collaborator: Interested and motivated by working with others. Actively creates and participates in opportunities to co-create solutions across markets
• Can easily see how insights/research learning can improve businesses impact and frames up reporting efforts and opportunities to inform business decisions
• Bachelor’s Degree in any disciple.
• Excellent communication skills and proficiency in English language