Sr. Analyst, BI and Visualization

Job description

Overview

We Are PepsiCo

 

Join PepsiCo and dare to transform! We are the perfect place for curious people, thinkers and change agents. From leadership to front lines, we're excited about the future and working together to make the world a better place.

 

Being part of PepsiCo means being part of one of the largest food and beverage companies in the world, with our iconic brands consumed more than a billion times a day in more than 200 countries. In

 

PepsiCo Mexico is one of the most important consumer products companies in the country. Our product portfolio, which includes 22 of the world's most iconic brands, such as Sabritas, Gamesa, Quaker, Pepsi, Gatorade and Sonrics, has been a part of Mexican homes for more than 116 years.

 

A career at PepsiCo means working in a culture where all people are welcome. Here, you can dare to be you. No matter who you are, where you're from, or who you love, you can always influence the people around you and make a positive impact in the world.

 

Know a little more: PepsiCoJobs

Join PepsiCo, dare to transform.

Responsibilities

The Opportunity

 This role with the PFNA Data & Digital solutions team within PFNA IT. In this role, you will play a key role in advancing PFNA data solutions & capabilities.

 

You will execute data- related initiatives in one or more functional domains (finance, sales, marketing supply chain)  by understanding business needs, researching and analyzing appropriate data sources and building dimensional data models that will service those business data need.

 

Your Impact.

As Sr. Analyst,BI and Visualization your responsibilities would consist of:

·  Quickly use technical (e.g.SQL), discovery and data profiling techniques to enable team understanding of \"what data is available\" within the context of specifin business needs.
·  Effectively communicate findings to both business and technincal 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 standar platforms.
·  Build Data Definition Language (DDL) constructs iteratively based on feedback from data engineers an devolving busicess requirements.
·  Anticipate and overcome technical/ data problems and makes appropiate decisions to deliver assigned projects.
·  Define and establish standards for data modeling across the PFNA Data& Digital Solitions Team.
·  Lead Jr data analsts 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 envioment.
Qualifications

Who Are We Looking For?  

 

Experience

·   2. 4 years experience in BI development and delivery with Power BI; Experience with Tableu a plus.
·  Minimum 2 years experience in project management.
·  2-3 years experience operating in an IT data analyst or business data analyst role.

Tech skills:

·  Extensive hand- on SQL experience whit ability to writecomplex queries to explore and uderstand data.
·  Ability and experience querying both traditional relationaldatabase technologies (e.g. Teradata, Oracle, SQL server DB2) and emerging cloud- based technologies (Azure DataLake, Hive, Presto, Synapse).
·  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 tech skills

·  Ability to work with  agile delivery methodologies.
·  Ability to ideate requirements & design iteratively withbusiness partners without formal  requirements documentation.
·  Ability to quickly understand business context of solution needs, and apply to analysis & data modeling activities.
·  Strong written and verbal communication skills, story teller.
·  Ability to work at detailed technical level with data engineers, while equally proficient having business analysts.
·  Positively influence inmediate team members, including contract resources.
·  Ability to adapt to change quickly and handle unforeseen requirements effectvely  with limited assistance for prioritization.
·  Ability to work with virtual & global teams, including offshore

 

If this is an opportunity that interests you, we encourage you to apply even if you do not meet 100% of the requirements.

 

What can you expect from us:

 

·  Opportunities to learn and develop every day through a wide range of programs.
·  Internal digital platforms that promote self-learning.
·  Development programs according to Leadership skills.
·  Specialized training according to the role.
·  Learning experiences with internal and external providers.
·  We love to celebrate success, which is why we have recognition programs for seniority, behavior, leadership, moments of life, among others.
·  Financial wellness programs that will help you reach your goals in all stages of life.
·  A flexibility program that will allow you to balance your personal and work life, adapting your working day to your lifestyle.
·  And because your family is also important to us, they can also enjoy benefits such as our Wellness Line, thousands of Agreements and Discounts, Scholarship programs for your children, Aid Plans for different moments of life, among others.

 

We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We respect and value diversity as a work force and innovation for the organization.