Associate Manager - BI & Reporting

PepsiCo; Hyderabad; Hybrid; INR 900,000 - 1,300,000; Full time

Job summary

PepsiCo seeks a BI & Reporting Associate Analyst in Hyderabad to independently deliver dashboards, analysis, and automated reports across assigned business workstreams, ensuring accuracy, timeliness, and data quality.

You will design Power BI dashboards and data models, translate requirements into concrete solutions, use SQL and automation tools (VBA/macros, Python or R), and collaborate with stakeholders to drive actionable insights and governance.

Qualifications

• 6–7 years of experience in reporting or BI roles.
• Bachelor’s degree in Engineering, Business Administration, Commerce, Marketing, Analytics, or related field.
• Advanced Power BI, MS Office, with SQL and data automation experience.
• Strong analytical and stakeholder management skills.
• Knowledge of data modelling, data governance and quality controls.

Responsibilities

• Own end-to-end reporting across assigned workstreams with accuracy and timeliness.
• Design, develop, and optimize dashboards, data models, visuals using Power BI.
• Translate business requirements into reporting solutions and present insights.
• Drive automation using SQL, VBA/macros, Python or R to increase efficiency.
• Establish robust data-quality checks and governance compliance.
• Analyze performance, identify trends and risks, provide evidence-based recommendations.
• Coordinate cross-functional priorities and manage stakeholder expectations.
• Promote standardization, document practices, share knowledge, and support agile delivery.

Skills

Power BI

SQL

Python

R

VBA/macros

Data automation

Data visualization

Analytical thinking

Stakeholder management

Education

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

Tools

MS Office

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.