Manager - Platforms & Solutions

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

Job summary

PepsiCo Hyderabad seeks an experienced analytics professional to sustain and enhance the Microsoft Fabric architecture and Power BI reporting portal. You will automate data sets, ensure data security, and deliver highly visual, user-friendly dashboards for diverse stakeholders.

You will engage with PGCS Data Analytics and business teams to identify opportunities, build end-to-end reports, and serve as the SME for Fabric-driven analytics. Strong SQL, DAX, and cloud fundamentals are required.

Qualifications

• 7-9 years of IT analytics experience in cross-functional environments.
• Experience developing and debugging Power BI reports and dashboards using DAX.
• Experience with SQL.
• Familiarity with Cloud, DevSecOps, and Infrastructure.
• Familiarity with Security and Compliance standards.
• Demonstrated ability to effectively communicate with all levels of the organization.
• Knowledge and experience with SAP Solman, HP-ALM, SharePoint, ServiceNow is a plus.
• Power BI: 5Yrs of exp; Microsoft Fabric: 1Yr
• Cross functional knowledge of FMCG sector.

Responsibilities

• Design and develop Power BI dashboards with DAX.
• Create and manage ETL data flows using SAP BW Extractors, SAP SDI and SDA.
• Support data integration and reporting solutions for SAP modules related to Supply Chain, Finance, Manufacturing, Operations.
• Strong knowledge of SQL and data modeling for end-to-end reporting.
• Collaborate with onshore and offshore teams to ensure timely delivery.
• Be the technical SME on the Fabric-based reporting platform.

Skills

Power BI

DAX

SQL

Python

JavaScript

Node.js

YAML

Azure DevOps

Azure Data Engineering

Cloud computing

Security & Compliance

Communication

Cross-functional collaboration

FMCG knowledge

Microsoft Fabric

Tools

SAP Solman

HP-ALM

SharePoint

ServiceNow

Job description

Overview

Sustain all current Microsoft Fabric architecture.

Establish solid relationships with business stakeholders and PGCS Data Analytic team members. Work to ensure most reporting and data sets are automated and/or semi-automated. Ensure data security.

Manage all backend data to support PGCS self-service reporting Power BI reporting portal. Leverage DAX experience within Power BI. Deliver highly visual easy to navigate reporting.

Ensure all reports / analytic reporting is flexible to enable multiple audiences to quickly pull various insights from a single data set. Partner with functional stakeholders to capture and combine varied data sets to a single report with the goal - make insights available rich and telling.

Sustain all Power BI reporting within the Fabric environment as appropriate. Create new reporting as necessary and work to transition all required data integrations with the new platform as well. Be the technical SME on the project team.

Provide analytic support to aid and drive the PGCS productivity agenda. Will require a high level of business engagement (engagement/participation) within business venues. Collaborate with PGCS and BU teams to identify the opportunities and leverage correct data sets to optimize & generate efficient E2E business solutions.

Manage PGCS project pipeline, work with team members to define value realization for those projects and monitor progress to ensure delivery.

Construct user stories with key stakeholders to deliver new capabilities. Lead productivity/E2E projects. Partner with IT business and IT stakeholders to prioritize work required and lead as project manager to ensure IT delivers optimal working solution.

Responsibilities

• Daily interaction with lead role and SME of respective area. Daily interaction with various level on the business depending on situation. Weekly interaction with D&A lead.
• Design and develop Power BI Dashboard with DAX
• Create and mange Extraction Transformation Loading (ETL) data flows using SAP BW Extractors, SAP Smart Data Integration (SDI) and Smart Data Access (SDA).
• Support data integration and reporting solutions based on the SAP modules related to Supply Chain, Financial reporting, Manufacturing, Operations, Master data.
• Strong knowledge of SQL.
• Knowledge of python, yaml, node.js and javascript would be an advantage
• Resource to be part of DSO team. Responsible to analyse issues/tickets raised by business and coordinate with business associates to have a resolution as per SLA.
• For the Enhancements/new report requirements, own requirements gathering, design, delivery, testing and user training of reporting and analytics solutions within the scope of PepsiCo Global Template.
• Partner with the Value Stream Leads to verify the issue resolution before implementation and deploy – Consult / Execute
• Work closely and collaborate with onshore and offshore team members and business partners to ensure timely delivery of the work

Qualifications

• 7-9 years of IT experience in analytics supporting cross-functional environments.
• Experience in developing and debugging reports and dashboards using Power BI, DAX
• Experience with SQL
• Familiarity with Cloud, DevSecOps, and Infrastructure
• Familiarity with Security and Compliance standards
• Demonstrated ability to effectively communicate with all levels of the organization
• Ability to work flexible hours based on varying business requirements
• Knowledge and experience in the following tools, disciplines and processes are nice to have: SAP Solman, HP-ALM, Sharepoint, ServiceNow etc.
• Ability to quickly adapt to changes in technologies, timelines and sequences
• Power BI: 5Yrs of exp
• Microsoft Fabric – 1Yr
• Cross Functional knowledge of FMCG company
• Azure Data Engineering
• Python
• Azure DevopsSQL
• Lakehouse Medallion Architecture, DAX functions