Salary
Job Type
Job Details
Location - Purchase, NY
Job Description
OverviewLooking for a self-motivated Junior Data analyst, who will be accountable for the PBNA Data identification, analysis and integration for the global IBP program. This role will adopt and adhere to PepsiCo’s SAFe agile principles.
Ability to provide PBNA IT and Functional knowledge to enable common global designs, data, reporting and analytics and own the mapping of PBNA Data for IBP integration. The role needs to analyze and define PBNA data sources in collaboration with the global groups.
Ability to navigate and translate data areas in Legacy and PGT environments in addition to DDH and EDW.
Responsibilities- Manage the Data object priorities in collaboration with the global groups and define and align on timelines and delivery schedules.
- Document the data usage and map them to GDO objects required for global IBP program.
- Drive PBNA IBP data requirements and identification of sources and alignment to global models for global IBP program. Drive the Global Data Object mappings.
- Define test scripts required to ensure data quality.
- Document data validation rules based on the data subject areas and sources, ensuring the data quality is maintained. Ensure source data from transactional systems ties in the target. Ensure data is certified using the PBNA data certification process.
- Ensure data rules and specifications are communicated to the development resources to ensure data is handled and used correctly.
- Ensure data context and one source of truth for PBNA by partnering with PBNA Functional Leadership (Supply Chain, GTM Operations, Commercial, S&T) and PBNA IT leadership.
- Ensure historical data is identified and ingested through Enterprise Data as per agreed timeline and requirements.
Compensation and Benefits
- The expected compensation range for this position is between $74,800 - $110,250 based on a full-time schedule.
- Location, confirmed job-related skills and experience will be considered in setting actual starting salary.
- Bonus based on performance and eligibility; target payout is 8% of annual salary paid out annually.
- Paid time off subject to eligibility, including paid parental leave, vacation, sick, and bereavement.
- In addition to salary, PepsiCo offers a comprehensive benefits package to support our employees and their families, subject to elections and eligibility: Medical, Dental, Vision, Disability, Health and Dependent Care Reimbursement Accounts, Employee Assistance Program (EAP), Insurance (Accident, Group Legal, Life), Defined Contribution Retirement Plan.
Qualifications
Qualifications
- 5+ years of IT experience
- 3+ years of experience in data analytics and data integration expertise
- Good data analytical skills.
- Ability to read data model diagrams and understand data relationships.
- Ability to navigate database platforms to analyze and map data.
- Preferably Safe Agile certified.
- Good understanding of cloud technologies in Azure, ADF, Synapse and Databricks
- Ability to query multiple databases like Oracle, Sybase, Hana and Teradata
Our mission: Create more smiles with every sip and every bite For our consumers: By creating joyful moments through our delicious and nourishing... Read more