Overview As a Senior Functional Analyst/Data Analyst, your focus will be to partner with the Enterprise Data Foundation team to design and create efficient, scalable & reuseable data models for Global projects. This would include independently analysing data requests, identifying data storage and integration needs/issues, driving opportunities for data model reuse and satisfying project requirements. Role will advocate Enterprise Architecture, Data Design, Data Modeling standards and best practices. You will be performing all aspects of Data Modeling and Analysis working closely with Data Governance, Data Engineering and Data Architecture teams. Responsibilities Perform Data Discovery/Profiling, Meta-Data Management, Data Governance, Data Security and Data Transformation/Conversion and identify issues that impact accuracy, completeness, consistency, integrity, timeliness and validity. Create Source to Target Mapping documents including identifying and documenting data transformations. Perform and/or support data analysis, requirements gathering, solution development, and design reviews for enhancements to existing, or new, applications/reporting. Develop a deep understanding of the business domains and enterprise technology inventory to craft a solution roadmap that achieves business objectives and maximizes reuse. Ensure physical and logical data models are designed with an extensible philosophy to support future, unknown use cases with minimal rework. Drive collaborative reviews of design, code, data and security features implementation performed by data engineers to drive data product development. Govern Data Modeling design and advocate for adherence to all approved standards and guidelines. Partner with IT, data engineering and other teams to ensure the enterprise data model incorporates key dimensions needed for proper management of: business and financial policies, security, local-market regulatory rules, consumer privacy by design principles (PII management) and all linked across fundamental identity foundations. Partner with the Data Governance team to standardize their classification of unstructured data into standard structures for data discovery and action by business customers and stakeholders. Assume accountability and responsibility for assigned product delivery, be flexible and able to work with ambiguity, changing priorities, tight timelines and critical situations/issues. Lead and support assigned project contractors (both on & offshore), orienting new contractors to standards, best practices, and tools. Contribute to project cost estimates, working with senior members of team to evaluate the size and complexity of enhancements or new development. Compensation and Benefits: The expected compensation range for this position is between $76,400 - $127,850. Location, confirmed job-related skills, experience, and education will be considered in setting actual starting salary. Your recruiter can share more about the specific salary range during the hiring process. 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 Bachelor’s degree required, preference in Computer Science, Data Management/Engineering, Information Systems, Software Engineering or related Technology Discipline. 8+ years of overall technology experience that includes at least 4+ years of Data Modeling, Data Analysis and Systems Architecture/Integration. 3+ years of Functional experience with SAP Master Data Governance (MDG) including use of T-Codes to create/update records and query tables. Extensive knowledge of all core Master Data tables, Reference Tables, IDoc structures. 3+ years of experience with SAP Customer Master Data. 3+ years of experience preparing ‘Source to Target’ data mapping documents and writing data transformation rules. 2+ years of experience with data profiling and strong SQL skills with ability to write complex queries. Experience with Python a plus. Expertise with data at all levels: low-latency, relational, unstructured data stores, analytical and data lakes, data streaming (consumption/production) and data in-transit. Strong understanding of Data Life cycle, Integration and Master Data Management principles. Excellent verbal and written communication and collaboration skills. Strong Excel skills for data analysis and manipulation. Strong analytical and problem-solving skills. Differentiating Competencies Experience with SAP Supplier Master and Material Master Data. Experience with metadata management, data lineage and data glossaries. CPG industry experience. Experience with Azure Data Factory, Databricks and Azure Machine learning. Experience with Data Modeling tools; ER Studio, Hackolade or IDM. Experience with Data Lake Infrastructure, Data Warehousing and Data Analytics tools. Experience with Transactional Data in Finance, Supply Chain, Logistics and Manufacturing. EEO Statement Our Company will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of the Fair Credit Reporting Act, and all other applicable laws, including but not limited to, San Francisco Police Code Sections 4901-4919, commonly referred to as the San Francisco Fair Chance Ordinance; and Chapter XVII, Article 9 of the Los Angeles Municipal Code, commonly referred to as the Fair Chance Initiative for Hiring Ordinance. 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