Data Analyst Assoc Manager - Enterprise Data Foundation

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.

Responsibilities

As a member of the data engineering team, you will be the key domain & data expert overseeing PepsiCo's business process in the Supplier Data Domain. You will help identify, define, analyze & prioritize consumer data very closely together with business leads, digital program leads, IT and our data engineering team. You'll develop an in-depth understanding of relevant Consumer business processes and translate business requirements to the data engineering team in a technical way.

 

As Sr Data Analyst - Enterprise Data Foundation your scope would consist of:

·  Discover, analyze, and scope data requirements & representing them in conceptual and logical data models.
·  Gather and analyze data pertaining to supplier data topics, spanning procurement, supplier , spend , commodity etc.
·  Create high-level process models (system interface diagrams, workflow & swim lane diagrams, data flow diagrams) to represent processes for the area under analysis.
·  Empower the business by creating value through the increased adoption of data, data science and business intelligence landscape.
·  Responsible to improve the quality of data in relation to defined expectations.
·  Perform analysis of system data to identify patterns, exceptions, and erroneous data
Qualifications

Education

·  Bachelor’s Degree in Computer Science/Operations Management/Sustainability Studies, Masters Preferred.

Experience

·  6+ years of experience with data analysis & data profiling in project, business requirements definition or data engineering in CPG or Manufacturing Industry.
·  4+ years of strong Data Profiling experience & ability to identify trends and anomalies in the data to in-form data model build out.
·  3+ years’ work experience in the areas of supplier data topics, spanning procurement, supplier , spend , commodity etc.
·  Experience working with structured/unstructured datasets, ability to clearly document and communicate requirement to technical team members.
·  A strong candidate will have proficient knowledge on 3-5 of the tools listed below. The list is indicative and not exhaustive.
o Business Process Modelling: Visio, Celonis, UML
o Data Profiling: OpenRefine, Informatica, Ataccama, Apache Griffin, Talend, IBM InfoSphere, SAP BODS
o Business Intelligence: Power BI, Tableau, Cognos, SAP BI, ORACLE BI, Qlik
o SQL: PostgreSQL, Azure SQL, PgAdmin, Oracle SQL Developer, Microsoft SQL, Datapine SQL Editor, Adminer
o Strong Excel and/or Access skills

Competencies

·  Strong knowledge and understanding of supplier data elements and processes per the necessary in-scope data domain
·  Ability to translate business requirements into critical data dependencies and requirements
·  Able to challenge and align various stakeholders to a common set of standards
·  Self-starter with excellent written & verbal communication skills.
·  Self-learner and eager to understand data, business processes, concepts, and technologies.
EEO Statement

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status. 

 

PepsiCo is an Equal Opportunity Employer: Female / Minority / Disability / Protected Veteran / Sexual Orientation / Gender Identity 

 

If you'd like more information about your EEO rights as an applicant under the law, please download the available EEO is the Law & EEO is the Law Supplement documents. View PepsiCo EEO Policy . 

 

Please view our Pay Transparency Statement