Digital Sales & Perfect Store Analyst

PepsiCo Inc.; Lisboa; On-site; EUR 25,000 - 38,000; Full time

Job summary

PepsiCo Portugal is seeking an analyst to provide operational and analytical support for digital selling and customer engagement tools and for field execution programs. The role covers data extraction, validation, dashboard preparation, and incident tracking, with collaboration across Sales, Trade Marketing, Marketing and IT teams.

The ideal candidate has a solid degree in business analytics or related field, strong Excel/Power BI skills, and a keen eye for data quality and process improvement.

Qualifications

• Bachelor's degree in Management, Economics, Marketing, Digital Business, Data/Business Analytics or a related discipline.

Responsibilities

• Update and maintain approved platform and field-tool content for defined customer segments and channels, including promotions, monthly targets, product information, surveys, videos, banners, push notifications and other engagement materials, using agreed templates and calendars.
• Set up and maintain customer and sales-structure master data and raise operational requests per approved processes and calendars.
• Extract, validate and consolidate customer registration, usage, ordering, sales and engagement data from approved sources; prepare dashboards and reports.
• Prepare recurring field-execution (Perfect Store) reporting by channel, such as service compliance, visit hours and results from field programs.
• Highlight data gaps, unusual trends, service issues and missed actions; provide a clear factual summary to the manager or owner.
• Collect and organize feedback from customers, Sales teams, field team and other users; group topics and support improvement recommendations.
• Prepare communications, user lists, training materials and follow-up trackers for adoption and change activities.
• Log and monitor platform incidents, service requests and change requests; maintain status information and elevate delays or risks.
• Perform user acceptance and smoke testing and document results for new features and changes, following test scripts.
• Provide inputs for business review meetings and maintain project documentation and action logs.

Skills

Basic understanding of commercial buis

FMCG and digital sales interest

English proficiency

Spanish language (advantage)

Attention to detail

Summarize information clearly

Data/standard KPIs knowledge

Education

Bachelor's degree in Management, Economics, Marketing, Digital Business, Data/Business Analytics or related discipline

Tools

Excel

PowerPoint

Power BI

CRM/SFA

ServiceNow

Job description

Overview

Provide operational and analytical support for PepsiCo Portugal's digital selling and customer engagement tools and for field execution programs (Perfect Store). The role executes recurring platform activities, maintains approved content, customer and structure data, monitors adoption and service KPIs, prepares standard reporting, supports users and follows up incidents and assigned project actions. Working within established processes, calendars and priorities, the analyst identifies issues, summarizes findings and proposes practical improvements for manager review. Strategic direction, platform roadmap, commercial targets, investment decisions and end-to-end programs ownership remain with the manager and relevant business owners.

Responsibilities

• Update and maintain approved platform and field-tool content for defined customer segments and channels, including promotions, monthly targets, product information, surveys, videos, banners, push notifications and other engagement materials, using agreed templates and calendars and the related back-office configuration.
• Set up and maintain customer and sales-structure master data ( customer opening, structure changes by channel, product and database updates) and raise operational requests such as purchase orders, following approved processes and calendars.
• Extract, validate and consolidate customer registration, usage, ordering, sales and engagement data from approved sources; prepare and refresh the datasets behind recurring dashboards and reports.
• Prepare recurring field-execution (Perfect Store) reporting by channel, such as service compliance, visit hours and results from field programs.
• Highlight data gaps, unusual trends, service issues and missed action; provide a clear factual summary to the manager or designated owner.
• Collect and organize feedback from customers, Sales teams, field teamand other users; group recurring topics and support the preparation of improvement recommendations.
• Prepare communications, user lists, training materials and follow-up trackers for approved adoption and change activities.
• Log and monitor platform incidents, service requests and change requests; maintain status information and maintain status information and elevate delays or risks according to the agreed process.
• Perform user acceptance and smoke testing and document results for new features, content changes or process updates, following test scripts and guidance provided by the project owner.
• Prepare inputs and materials for recurring and ad-hoc business review meetings and daily check-ins; maintain project documentation, action logs, meeting inputs and status updates for assigned workstreams; follow up agreed actions with relevant contributors.
• Provide standard analysis and operational support to Sales, Trade Marketing, Marketing, IT and other teams within the role scope.
• Identify simple opportunities to improve data quality, user experience or process efficiency and submit suggestions for review and approval.

Qualifications

• Bachelor's degree in Management, Economics, Marketing, Digital Business, Data/Business Analytics or a related discipline.
• Basic understanding of commercial processes and interest in FMCG and digital sales.
• Working proficiency in English; Spanish is an advantage.
• Good working knowledge of Excel and PowerPoint; familiarity with Power BI or similar BI tools is an advantage.
• Ability to work with structured data, recurring reports and standard KPIs.
• Comfort using CRM / sales force automation, digital platforms, back-office, ticketing tools or reporting systems ( SFA, Power BI, ServiceNow), with the ability to learn new tools.
• Strong attention to detail, data accuracy and document quality.
• Ability to summarize information clearly and communicate operational issues.