BI & Reporting Associate Manager

PepsiCo Inc.; Hyderabad; On-site; INR 8,671,000 - 12,524,000; Full time

Job summary

PepsiCo Inc. is seeking an experienced BI/Analytics professional to deliver reporting, analytics, and insights across channels, brands, customers, and sales areas.

You will develop and maintain Power BI solutions, manage data validation, and translate data into actionable insights for Sales Leadership in a fast-paced environment. The role focuses on day-to-day reporting for the West OTS team and continuous improvement through automation, AI-driven insights, and scalable reporting frameworks to

Qualifications

• Bachelor's degree in Business, Commerce, Finance, Marketing, Data Analytics, CS or related field; Master's preferred.
• 6–7 years of experience in BI, Reporting, Data Analytics, Sales Analytics or related
• FMCG experience preferred.
• Power BI hands-on: report/dashboard development, data modeling, DAX, Power Query.
• Excel and PowerPoint proficiency; SQL preferred; Python/R an added advantage.
• Strong analytical, problem-solving and stakeholder communication skills.

Responsibilities

• Support Commercial function with KPI reporting and ad hoc analyses using internal data, shipments, POS, and market data (IRI).
• Develop and maintain Power BI dashboards, reports and scorecards for accessibility and agility.
• Leverage Power BI and Data Bricks to deliver advanced analytics and actionable insights.
• Analyze large datasets across channels, customers, brands, and sales areas for trends and opportunities.
• Present insights and recommendations to Sales Leadership to drive data-driven decisions.
• Collaborate with cross-functional teams to deliver actionable business insights and root-cause analyses.

Skills

Power BI

Excel

PowerPoint

Stakeholder communication

Education

Bachelor's degree in Business/Analytics

Master's degree a plus

Tools

Data Bricks

SQL

Python

Job description

Overview

This role is part of the North America Beverage organization and supports the Commercial team by delivering business-critical reporting, analytics, and actionable insights across Channels, Brands, Customers, and Sales Areas. The position is responsible for developing and maintaining Power BI reporting solutions, managing data acquisition and validation, analyzing complex datasets, and translating data into meaningful insights that enable data-driven decision-making for Sales Leadership across Sector and Division teams.

As the primary and only dedicated analytics resource supporting the West OTS team, this is a business-critical role responsible for ensuring the timely delivery of day-to-day reporting, operational analytics, and ad hoc business requests. The role also drives continuous improvement through reporting modernization, automation, and the adoption of advanced analytics, helping enhance business performance, improve operational efficiency, and support key commercial initiatives.

Responsibilities

• Support the Commercial function with performance reporting against established KPIs, including ad hoc reporting using internal, shipment/POS, and market data (IRI).
• Develop and maintain Power BI dashboards, reports, and scorecards that improve accessibility, visualization, and business agility.
• Leverage Power BI and Data Bricks (must-have) and other analytical tools and techniques to deliver reporting, advanced analytics, and actionable business insights.
• Collate, validate, and analyze large, complex datasets across multiple channels, customers, brands, and sales areas to identify performance trends and opportunities.
• Present clear, concise insights and recommendations to Sales Leadership to support data-driven decision-making.
• Analyze innovation and portfolio performance to identify opportunities across Channels, Brands, Customers, and Markets.
• Support field sales execution through timely reporting and compliance analytics.
• Partner with cross-functional teams to perform root cause analysis and deliver actionable business insights.
• Build and maintain effective relationships with stakeholders through clear verbal and written communication.
• Ensure the accurate and timely delivery of reporting and analytics in accordance with agreed service level agreements (SLAs), while maintaining a strong focus on quality and execution.
• Contribute to the modernization of reporting solutions by leveraging Power BI best practices, automation, and scalable reporting frameworks.
• Identify opportunities to automate manual processes and improve reporting efficiency through innovative analytics solutions.
• Support the adoption of AI-driven insights, predictive analytics, and emerging technologies to enhance business decision-making.
• Drive continuous improvement by simplifying processes, standardizing reporting, optimizing technology, and identifying opportunities to enhance service delivery.
• Foster an inclusive and collaborative work environment.

Qualifications

• Bachelor's degree in Business Administration, Commerce, Finance, Marketing, Data Analytics, Computer Science, or a related field. A Master's degree is a plus.
• 6 - 7 years of experience in Business Intelligence, Reporting, Data Analytics, Sales Analytics, or a related analytical role.
• Prior experience in the Fast-Moving Consumer Goods (FMCG) industry is preferred.
• Strong hands-on experience with Power BI (required), including report/dashboard development, data modeling, DAX, and Power Query.
• Proficiency in Microsoft Excel and PowerPoint; experience with SQL is preferred. Knowledge of Python, R, or other analytical tools is an added advantage.
• Strong analytical, critical thinking, and problem-solving skills with exceptional attention to detail.
• Ability to analyze complex datasets and translate findings into actionable business insights and recommendations.
• Excellent verbal and written communication skills, with the ability to effectively present insights to business stakeholders and leadership.
• Strong stakeholder management and customer service orientation, with the ability to collaborate across cross-functional teams.
• Excellent time management, prioritization, and organizational skills, with the ability to manage multiple deliverables in a fast-paced environment.
• Demonstrated ability and willingness to learn new technologies, business processes, and PepsiCo systems.