Mbs Visualization Developer

**Overview**

**We Are PepsiCo**
- PepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world. PepsiCo generated more than $79 billion in net revenue in 2021, driven by a complementary beverage and convenient foods portfolio that includes
**LAY’S ®️, DORITOS ®️, CHEETOS ®️, GATORADE ®️, PEPSI ®️, QUAKER ®️** and more. PepsiCo's product portfolio includes a wide range of enjoyable foods and beverages, including many iconic brands that generate more than $1 billion each in estimated annual retail sales.

Guiding PepsiCo is our vision to Be the Global Leader in Beverages and Convenient Foods by Winning with PepsiCo Positive (pep+). pep+ is our strategic end-to-end transformation that puts sustainability and human capital at the center of how we will create value and growth by operating within planetary boundaries and inspiring positive change for planet and people.

Our employees drive our culture. No two days are the same; we are dynamic and full of passionate teams that embrace new ideas through our collaborative spirit. At PepsiCo, we know that our company can only succeed when our associates and the society we serve flourishes. We are committed to fostering a diverse workforce by creating a collaborative, equitable and inclusive space where everyone, regardless of what we look like, where we come from or who we love, has a voice. At PepsiCo we create a Space to be y( )u.

**Join PepsiCo, dare to transform.**

**Responsibilities**

**MBS Visualization Developer**

**Main purpose**

The Visualization Developer will operate within a team of data engineers, database developers, and data analysts to produce best-in-class dashboard solutions for supply chain performance managers, decision makers, specialists and frontline personnel.

Visualization Developer’s primary responsibilities include:
2) Utilize data skills to define data design and technical requirements to enable the dashboard solutions. Utilize SQL to join disperse data sets and bring harmonized data into the visualization layer. Develop understandings of various system data and data engineering processes and the potential implications on the data.

3) Diagnose, troubleshoot, and repair issues in existing Tableau and PowerBI Dashboards. Perform visual and functional overhauls of existing dashboards to improve user experience. Trace data issues through ETL processes and partner with data engineers to resolve.

4) Partner closely with data engineers and product owners to ensure end-to-end solution is reliable, accurate, and scalable. Partner with team members to align on data design, system design, visual design, and data engineering processes.

5) Support team with various ad-hoc requests including data analysis, dashboard troubleshooting, and end-user support

**Your Impact**

As The MBS Visualization Developer your scope will consist of:

- Develop, maintain, and troubleshoot Tableau and PowerBI Dashboards, utilizing appropriate visualization types for each scenario, testing various layouts with end users in iterative approach. Utilize best practices for color, contrast, repetition, alignment, and proximity, building out consistent look and feel across supply chain dashboards.
- Work with the HQ Warehouse Team SMEs to ensure reporting and analytics supports the Warehouse productivity agenda
- Develop, support and sustain supply chain warehouse metrics, tools, reports and dashboards for Frito Lay North America business team
- Troubleshoot & resolve issues related to existing suite tools, reports and dashboards
- Support ad-hoc analytical needs as needed by developing programs, tools, analyzing data, and/or creating visualizations in Excel, PowerBI and/or Tableau.
- Work closely with other team members (business analysts, data engineers, Tableau and PowerBI developers) to collaborate, design, plan work, and develop complete business solutions.
- Support team with ad-hoc analytics, tool troubleshooting, and support end-users directly to resolve tool issues.

**Qualifications**

**Who Are We Looking For?**
- Fluent in English
- Bachelor’s degree or equivalent work experience in business systems or information technology
- 2+ years Tableau and PowerBI. Experience using various visualization techniques to build dashboards. Deep understanding of filters, actions, interactivity, data blending, and data models. Experience building wireframes for various personas and developing those into finished solutions.
- Intermediate to advanced SQL skills. Experience utilizing various data sources (such as Oracle, Teradata, Datalake) to harmonize and prepare data for a dashboard solution. Basic to intermediate understand of data engineering (ETL), with expectation to continue learning in this area.
- Experience using various data models in Tableau and PowerBI, ability to define data designs to enable various calculations and dashboard solutions.
- Ability to translate bu