42 days ago PepsiCo

Data Analyst

  • Internship
  • Reading ( Reading )

Job description



Job Description

Auto req ID: 197218BR

Job Description

As PepsiCo we embark on a number of initiatives to make us more efficient and agile as a company. One key initiative to unleashing the Power of PepsiCo Enterprise First: Global Template. It is a multi-year program designed to harmonize PepsiCo’s core business processes and common data, enabled by the latest SAP technology. As we start to form a cross-functional, ESSA-wide high performing team to support Wave 1 implementation, we are delighted to announce that we are searching for:

Responsibilities

Data Analyst for Enterprise First, Finance will be responsible for Data Conversion and Data Readiness work stream ahead of a full Project Deployment engagement, to mitigate risks and improve project effectiveness. This will help reduce the time to deliver valid and accurate (“business ready”) data in support of the project activities, as well as reduce the risk to the target deployment date.
Objective is to use expert Master Data and functional knowledge to plan activities for workstream (create mappings, update Data Quality rules, conduct Data Assessments & execute Source Data Cleansing).

Main Accountabilities for the position:

·
Cleanse and Enrich Legacy Data based on Target Requirements in the Legacy system, if possible. If not possible, contribute in defining the transformation rules in Middleware

·
Reconcile duplicates for Customer, Vendor and Material (Core Master Data) based on the Design Requirements and Scope.

·
Complete User Acceptance Tests

·
Execute Post Conversion Data Verification and Business Sign off

·
Manual resolution of Data Conversion failures

·
Review/Approve Data Ownership Recommendations

·
Participate in End User Training for new system and processes

·
Contribute to Data Conversion Functional Design Requirements

·
Work with team to identify and deliver all master data and reporting requirements related to the project workstream

·
At all phases, partner with IT team to ensure planned solutions are “fit for purpose” for the BU needs

Qualifications/Requirements

Key Skills Required

·
Openness to regular business travel

·
Conversational in English Language

·
Experience in working with master data and reports is desired

·
Pays Attention to detail

·
Strong customer service skills towards stakeholders and end user groups

·
Excellent time management skills, ability to multitask and work to deadlines

·
Excellent communication skills

·
Experience of working in an IT environment is an additional asset

Differentiating Competencies Required

·
Deep knowledge of Domain Legacy Data, from the Application perspective and how it supports the Business Process, Operational & Reporting today to contribute to Target Design Requirements.

·
Understanding of the Domain data legacy field usage to assist with Data Fields & Values Mapping activity from Legacy Source to SAP Target

·
Capability to understand the gaps, patterns & anomalies identified from the collaborative review of Legacy System Data Profiling reports (based on target requirements) & provide business insight for cause & action from legacy perspective.

·
Engage and collaborate cross-functionally to work on data-related issues resolution, data cleansing and validation activities and manage downstream impacts on the as-is data-related processes and systems

·
Attend training to use Project Data Quality Reports that identify legacy data issues based on the SAP Target requirements.

·
Have access and ownership in the Legacy Source system to cleanse the existing legacy data based on the Data Quality Rule Reports on a regular basis to ensure Data Readiness for Conversion activities.

·
Understand Legacy business processes to identify & share scenarios with the Project team where Data cannot be cleansed in Legacy due to current operational/reporting impact. Ability to support data enrichment activities in Project Data Staging system for such data scenarios.

·
Reconcile duplicates for Customer, Vendor and Material within a system or across multiple sources

Relocation Eligible: Not Applicable
Job Type: Pipeline

We are an equal opportunity employer and comply with the Equality Act 2010, we value diversity at our company; it is an essential part of our success. We do not discriminate on the basis of age, pregnancy or maternity, marital/civil partnerships, religion or belief, sex or sexual orientation, gender or gender reassignment, disability or race including; colour, nationality, ethnic or national origin.