Data Impact Analyst

Overview

The Data Impact Analyst is part of the Data Impact team. The purpose of this team is to deliver business impact through data and industry leading analytics, all in close collaboration with the NWE commercial departments (DX, Sales and Marketing) and Europe sector teams/CoEs (Advanced Analytics, Data & Analytics, Digital, Reporting & Insights, Perfect Store).

The associate will support PepsiCo NWE Commercial Data & Analytics strategy definition. He/she will own and maintain the commercial reporting landscape and play an instrumental role in data democratization, making sure that data and insights are available to everyone in an easy and effective way through standardization and new tools development (e.g. dashboarding).

As a member of the Data Impact team, he/she will lead the translation of strategic business questions into analytics use cases and ultimately business impact through capturing needs, preparing relevant data sources and applying advanced analytics methods.

Responsibilities

• Co-own data management strategy - define the way we collect, store, maintain and automate commercial data sources and assess improvement potential for the existing strategy
• Conduct periodic data quality checks
• Own and maintain existing commercial reporting landscape; assess automation and harmonization potential and align with commercial stakeholders on their reporting needs
• Based on the assessment, transform the existing reporting into Power BI dashboards; develop new reports if needed
• Use tools like Python/PySpark in Azure Databricks to prepare data for analytics use cases
• Work with commercial teams and translate their strategic business questions into analytics use cases
• Act as a data and analytics evangelist, be at the forefront of data-driven models and insights and lead others to leverage data in their decision making
  
  

Qualifications

• Excellent analytical skills with a natural ability to visualize data in a way that uncovers (new) insights
• Ability to process and work with large and diversified datasets
• Strong experience in Power BI - Backend/Frontend
• Previous experience with data preparation tools like Alteryx and Azure Databricks
• Experience in Databricks and Python/PySpark - Should be able to perform an ETL transformation of a mid-large scale dataset
• Previous experience with data visualization tools - preferably MS Power BI
• Good to have knowledge of R/understanding and running simple machine learning models/SQL but not mandatory
• Attention to detail, accuracy and ability to work towards tight deadlines
• Intellectually curious, with an interest in how analytics can be leveraged to derive business value
• Effective verbal and written communication skills
• E2E project management experience is preferable - i.e. from collecting/understanding business requirements through development to implementation and evaluation