Lead Engineer – 2 - Product Analyst - Data Product

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.

About PepsiCo

• 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.

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
• 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

Requirements

• 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.