Associate Manager – BI & Reporting and Product Management

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

Job summary

PepsiCo Deutschland GmbH is seeking a senior BI professional to lead the delivery of BI and reporting products, using Power BI as the primary platform. You will partner with business and technical teams to shape requirements, define scalable data solutions, and ensure successful build, delivery and sustainment of reporting products.

The role covers data ingestion, transformation, modelling and visualization, with a focus on cross-functional collaboration and data quality in a fast-paced

Qualifications

• Degree in Computer Science, Information Systems, Engineering, Business Analytics or a related field.
• 6+ years of experience in Business Intelligence, Reporting, Analytics or Data Management, with significant hands-on Power BI development.
• Experience developing dashboards, reports and analytical solutions for business users with cross-functional teams.

Responsibilities

• Data Ingestion & Integration - Microsoft Fabric data ingestion and integration, including SAP BW/HANA and other enterprise data sources.
• Data Transformation & Engineering - Developing scalable ETL/ELT pipelines, Dataflows and Notebooks to cleanse, transform and prepare data using a modern Medallion Architecture.
• Data Modelling - Designing performant dimensional models and Star Schemas, including fact/dimension structures, relationships and business-ready semantic models.
• Power BI Visualization - Developing intuitive, business-focused Power BI reports and dashboards, translating wireframes into effective visualisations and user experiences.

Skills

Power BI

Microsoft Fabric

SAP BW/HANA

ETL pipelines

SQL

Azure Data Lake

Dimensional Modeling

Data quality

Stakeholder mgmt

Education

Degree in Computer Science, Information Systems, Engineering, Business Analytics or a related field

Tools

Azure Data Factory

Synapse

Databricks

SAP BW/HANA

Job description

Overview

As part of the PGCS D&AI organisation, the role leads the delivery of Business Intelligence and Reporting products, with Power BI as the primary platform. The role partners with business and other technical teams to shape reporting requirements, define scalable data and semantic solutions, manage demand intake, and ensure successful build, delivery and sustainment of reporting product.

Responsibilities

Key Responsibilities

• Data Ingestion & Integration - Microsoft Fabric data ingestion and integration, including SAP BW/HANA and other enterprise data sources.
• Data Transformation & Engineering - Developing scalable ETL/ELT pipelines, Dataflows and Notebooks to cleanse, transform and prepare data using a modern Medallion Architecture.
• Data Modelling - Designing performant dimensional models and Star Schemas, including fact/dimension structures, relationships and business-ready semantic models.
• Power BI Visualisation - Developing intuitive, business-focused Power BI reports and dashboards, translating wireframes into effective visualisations and user experiences.

Qualifications

Skills Required

• Strong Power BI delivery experience - report and dashboard development, DAX, semantic models, performance optimisation and deployment practices.
• Working knowledge of Microsoft Fabric - ingestion and integration.
• Experience integrating SAP BW/HANA and other enterprise data sources into analytics and reporting platforms.
• ETL pipeline delivery on a Medallion Architecture, with an understanding of data quality, reconciliation and refresh management.
• SQL for querying, validation and data analysis; familiarity with the Azure Data & Analytics stack including Data Lake, Blob Storage, Azure Data Factory, Synapse and Databricks.
• Functional and technical data experience in Supply Chain and Commercial domains is preferred;

Experience Required

• Degree in Computer Science, Information Systems, Engineering, Business Analytics or a related field.
• 6+ years of experience in Business Intelligence, Reporting, Analytics or Data Management, with significant hands-on Power BI development.
• Experience developing dashboards, reports and analytical solutions for business users, working with cross-functional business and technology teams.

Behavioural Expectations

Strong analytical and problem-solving capability, with the ability to understand business processes and turn them into meaningful reporting. Excellent communication and stakeholder engagement skills, close attention to detail and a firm commitment to data quality are expected, together with a proactive learning mindset and the ability to manage multiple priorities in a fast-paced environment.