Business Intelligence BI

Overview:
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.

**Responsibilities**:
**Business Intelligence Bi & Visualization Analyst**:
**Main Purpose**

In this Sr. Analyst role, you will play a key role in advancing data solutions & capabilities. You will execute data-related initiatives in our critical Go-To-Market team by understanding business needs, researching and analyzing appropriate data sources and building dimensional data models that will service those business data need.

Your hands-on SQL and Power BI skills as a data professional will allow you to quickly profile & analyze data sets, even ones with which you lack full business context and familiarity. Your ability to use data itself along with innate curiosity as a method for building contextual knowledge about the business will establish you as a key team member to deliver data solutions.

Your role as a Sr Analyst will put you at the center of key insights projects and position you to quickly build up functional and technical knowledge that will create a myriad of future career path options.

**Accountabilities**
- Quickly use technical (e.g., SQL), discovery and data profiling techniques to enable team understanding of “what data is available” within the context of
- Effectively communicate findings to both business and technical personnel, and iteratively execute follow-ups
- Understand business needs along with the data available and use to design effective dimensional data models to share with data engineers for technical ETL build
- Frame high complex visualization / analytical solutions based on business needs and Pepsico standard platforms
- Experienced user of Power BI
- Build Data Definition Language (DDL) constructs iteratively based on feedback from data engineers and evolving business requirements
- Anticipate and overcome technical / data problems and makes appropriate decisions to deliver assigned projects
- Define and establish standards for data modeling across the PFNA Data & Digital Solutions Team
- Lead Jr data analysts across the team and pa to share approaches and incorporate learnings into future work
- Assist other team members on project deliverables as needed
- Responsible of the support of a variety of data sets and data visualization tools in the production environment

Qualifications:
**Qualifications**:

- 2-3 years’ experience operating in an IT data analyst or business data analyst role

Technical Skills:

- Extensive & high level hands-on Power Bi & SQL experience, with ability to write complex queries to explore and understand data
- Knowledge and/or ability and experience querying both traditional relational database technologies (e.g., Teradata, Oracle, SQL Server, DB2) and emerging cloud-based technologies (Azure Data Lake, Hive, Presto, Synapse)
- Knowledge & Experience creating DDL data models
- Ability to perform data discovery and profiling activities on data sets and present results to both IT and business users
- Strong functional domain expertise in at least one core PepsiCo business function a plus - sales, supply chain, finance
- Teach master classes within the Power BI community of practice to build/grow data culture around the business

Non-Technical Skills:

- Ability to work with agile delivery methodologies
- Ability to ideate requirements & design iteratively with business partners without formal requirements documentation
- Strong written and verbal communication skills, storyteller
- Ability to work at detailed technical level with data engineers, while equally proficient having business context conversations with busines