L8 Enterprise Data Operations Functional/Data Sr. Analyst

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 Ma