Lead Engineer 2 - Product Analyst - Data Product

PepsiCo; Rangareddy; Presencial; INR 900.000 - 1.500.000; Jornada completa

Descripción de la vacante

PepsiCo Inc. is seeking a Product Analyst to join the Data Product team. You will support product managers by gathering requirements, aligning KPI definitions across markets, and translating business needs into robust data engineering and BI specifications.

Ideal candidates have 5+ years in data or product analysis, strong SQL, and hands-on experience with Power BI, dbt, and Airflow, enabling data-driven decision-making across global stakeholders.

Formación

• 5+ years experience as a product or data analyst with large data sets from ingestion to visualization.
• Strong understanding of reporting and self-service analytics to empower business decisions.
• Proficiency in SQL.
• Ability to trace data issues to source, processing or reporting.
• Ability to work independently and justify next steps with evidence.
• Familiarity with Power BI, dbt, Airflow and API integrations to collaborate with engineering and BI teams.
• Ability to distinguish between stakeholder wants and needs.
• Ability to explain stakeholder needs to technical and non-technical audiences.

Responsabilidades

• Support Product Managers in initial requirements gathering and validation with key stakeholders across business units, including how to incorporate local nuances into the global solution.
• Work independently with EMEA stakeholders to understand their needs and turn them into clear requirements for data engineering and BI teams.
• Write and update specifications covering data sources, reporting detail, field mappings, KPI definitions, business rules, dependencies and acceptance criteria.
• Help align KPI definitions across markets and data providers. Document local needs and resolve differences with business owners and the Product Manager.
• Plan and run data checks and UAT. Define test cases and expected results, compare reports with source data, track issues and coordinate business approval.
• Be the first contact for data errors, reporting issues and delays within the assigned scope. Assess the impact, investigate the problem and work with the right teams to resolve it.

Conocimientos

5+ yrs exp

Self-service analytics

SQL skills

Trace data issues

Independent work

Power BI

dbt

Airflow

APIs

Stakeholder needs

Stakeholder comms

Herramientas

Power BI

dbt

Airflow

APIs

Descripción del empleo

Job Description

Overview

At PepsiCo International dCommerce team, we are building the next generation of innovative products and capabilities using emerging technologies to accelerate our business and gain back share. While tied closely to broader PepsiCo, the dCommerce group has a unique start-up feel and defined values that embrace a more entrepreneurial mindset.

We are looking for a Product Analyst to be part of the Product Management team for Data Product to enable our vision that data is a product is in of itself and needs to be treated and valued as such. This role reports into the Product lead and supports all data streams, with a focus on commercial retail data, from partnering with the business to better capture and materialize their requirements to working with engineering to ensure data robustness and integrity.

Responsibilities

• Support Product Managers in the initial requirements gathering and validation with key stakeholders across business units, including how to incorporate local nuances into the global solution
• Work independently with EMEA stakeholders to understand their needs and turn them into clear requirements for data engineering and BI teams.
• Write and update specifications covering data sources, reporting detail, field mappings, KPI definitions, business rules, dependencies and acceptance criteria.
• Help align KPI definitions across markets and data providers. Document local needs and resolve differences with business owners and the Product Manager.
• Plan and run data checks and UAT. Define test cases and expected results, compare reports with source data, track issues and coordinate business approval.
• Be the first contact for data errors, reporting issues and delays within the assigned scope. Assess the impact, investigate the problem and work with the right teams to resolve it.

Qualifications

• 5+ years as a product analyst or data analyst with beneficial consideration for experience working with large data sets from ingestion to visualization
• Strong understanding reporting and self-service analytics solutions and how they are used to empower business to make decisions
• Practical SQL skills.
• Ability to trace data issues and identify whether they come from the source, data processing or reporting.
• Ability to manage assigned work independently, use evidence to recommend next steps and explain when a decision or support is needed.
• Working knowledge of Power BI, dbt, Airflow and API integrations to work effectively with engineering and BI teams.
• Ability to identify the difference between what stakeholders want and what stakeholders need
• Ability to explain stakeholder needs to technical team members and explain technical considerations to non-technical stakeholders