Data Analyst - Purchase, United States - PepsiCo

Description

Overview

Looking 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

• 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

>

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 availableEEO is the Law&EEO is the Law Supplementdocuments. ViewPepsiCo EEO Policy.

Please view ourPay Transparency Statement