Associate Manager - BI & Reporting

PepsiCo Inc.; Hyderabad; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

The PepsiCo Inc. BI&R Associate Analyst independently delivers Business Intelligence and Reporting solutions for complex business needs, translating stakeholder requirements into reliable dashboards, analysis, and automated reporting.

The role owns assigned reporting workstreams, strengthens controls and data quality, and recommends improvements that enhance decision‑making and execution effectiveness. This role partners with cross-functional stakeholders, coordinates delivery priorities,

Qualifications

• 6–7 years of experience in reporting, BI, analytics, or related roles with independent ownership.
• Bachelor’s degree in Engineering, Business Administration, Commerce, Marketing, Analytics, or related field.
• Advanced hands-on expertise in Power BI and Microsoft Office, with SQL and data automation skills.
• Strong analytical, problem-solving, and stakeholder management with project delivery ability.
• Knowledge of data modelling, data governance, quality controls, and knowledge sharing.

Responsibilities

• Independently own end-to-end delivery of reporting across assigned workstreams with accuracy and timeliness.
• Design, develop, and optimize dashboards, data models, visualizations, and analytical solutions.
• Translate business requirements into reporting solutions and present actionable insights to stakeholders.
• Drive automation using SQL, VBA/macros, Python, or other tools to improve efficiency.
• Establish data-quality checks, investigate root causes, and ensure governance and standards.
• Analyze performance, identify trends and risks, and influence decisions with evidence.
• Coordinate cross-functional priorities, manage stakeholder expectations, and resolve issues.
• Drive standardization, maintain documentation, and share best practices to strengthen delivery.

Skills

Power BI

SQL

VBA/macros

Python

R

Data modelling

Education

Bachelor’s degree in Engineering, Business Administration, Commerce, Marketing, Analytics, or a related field

Tools

Microsoft Office

Excel

Job description

Overview

The BI&R Associate Analyst independently delivers Business Intelligence and Reporting solutions for complex business needs, translating stakeholder requirements into reliable dashboards, analysis, and automated reporting. The role owns assigned reporting workstreams, strengthens controls and data quality, and recommends improvements that enhance decision‑making and execution effectiveness.

This role partners with cross-functional stakeholders, coordinates delivery priorities, resolves complex reporting issues, and provides guidance to junior team members while contributing to broader analytics and digital transformation initiatives.

Responsibilities

• Independently own end-to-end delivery of standardized and ad hoc reporting across assigned business workstreams, ensuring accuracy, consistency, and timeliness.
• Design, develop, and optimize complex dashboards, data models, visualizations, and analytical solutions using Power BI and other reporting tools.
• Translate business requirements into reporting solutions and present actionable insights and recommendations to business stakeholders.
• Drive automation and process improvements using SQL, VBA/macros, Python, R, or other digital solutions to improve efficiency and scalability.
• Establish robust data-quality checks, investigate root causes, and ensure compliance with service standards, governance, and reporting requirements.
• Analyze business performance, identify emerging trends and risks, and influence decisions through evidence-based recommendations.
• Coordinate cross-functional priorities, manage stakeholder expectations, and resolve complex reporting or delivery issues.
• Drive standardization, maintain documentation, share best practices, and provide practical guidance to strengthen team capability and agile delivery.

Qualifications

• 6–7 years of experience in reporting, Business Intelligence, analytics, or related operational roles, including independent ownership of reporting workstreams.
• Bachelor’s degree in Engineering, Business Administration, Commerce, Marketing, Analytics, or a related field.
• Advanced hands‑on expertise in Power BI and Microsoft Office, with proficiency in SQL and data automation or analytical tools such as VBA/macros, Python or R.
• Strong analytical, problem‑solving, communication, stakeholder management and project delivery skills, with the ability to manage competing priorities independently.
• Demonstrated knowledge of data modelling, data governance, quality controls, and effective knowledge-sharing practices.