BI & Reporting Assoc Analyst

PepsiCo Inc.; Hyderabad; Presencial; INR 1 500 000 - 2 500 000; Tempo integral

Resumo da oferta

PepsiCo Inc. Hyderabad, India, is seeking an experienced analytics professional to support the Shopper Marketing team with KPI tracking, campaign reporting, and post-campaign insights. You will work closely with agencies and internal teams to deliver actionable recommendations.

You will develop scorecards, dashboards, and visualizations to communicate complex insights to stakeholders, enabling data-driven optimization of future campaigns across channels.

Qualificações

• 6+ years of analytics experience in a leading consumer goods company.
• Strong experience in marketing reporting and analytics.
• Familiarity with marketing, reporting and media KPIs.
• Deep familiarity with CPG data sources (e.g., Nielsen/IRi, GlobalData, Kantar).

Responsabilidades

• Maintain standards and ensure SLA targets are met (95%+).
• Produce regular KPI scorecards for campaign performance.
• Conduct post-campaign deep dives to extract actionable insights.
• Collaborate with agencies and Shopper Marketing teams on reporting and budgets.
• Partner with stakeholders for competitive analysis and best practices.
• Create visualizations and dashboards to explain insights clearly.

Conhecimentos

Marketing analytics

Campaign reporting

Stakeholder collaboration

Excel

PowerPoint

Formação académica

Bachelor’s Degree in any discipline

Ferramentas

Power BI

Descrição da oferta de emprego

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 updating 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