Lead Engineer – 2 - Product Analyst - Data Product

Location: Hyderabad, Telangana, India

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

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