11/07/2025 Enterprise Solutions Jr. Analyst

Overview

The Tech Strategy & Enterprise Solutions – Consumer Capability at PepsiCo drives personalization at scale by leveraging best-in-class technology stack. The team elevates consumer engagement through Salesforce Marketing Cloud, Data Cloud, MCP, and Service Cloud, enabling targeted campaigns and loyalty initiatives. We are seeking a skilled Administrator to manage and maintain our Marketing Cloud and Customer Data Platform (CDP) environments. The ideal candidate will be responsible for ensuring seamless operations, user management, system configurations, and integrations across these platforms.

Responsibilities

- Creating and managing roles and permissions. Manage and create users/accesses.
- Create and manage FTP users and directories, Handle SFTP key management.
- Setup "Sender Authentication Package (SAP)", Manage "send classifications".
- Manage Audit trail, Manage data import, and export in SFMC.
- Create reports and send analytics.
- Create and monitor file drop and schedule automation.
- Track latest release impacts, install packages, and Set up New SFMC Bus.
- Document CRs, Basic SQL hands-on Work with data integration technologies to design and implement new solutions and processes for clients to support new customer experience strategies  Identify data points required to enable use cases Analyze data for usability in CDP Identify data cleansing requirements Map data sources to CDP data objects (which requires detailed knowledge of the CDP data model) Map data fields to CDP data fields Identify the need to custom CDP objects Determine the relationship between CDP data objects Identify the appropriate primary and secondary keys for each object Determine the specific unification algorithms required for the data of a given client
- Design test data to test the data model and unification algorithms Execute complex system tests

Qualifications

- 2+ years of hands-on experience with marketing data in MarTech and/or Data Cloud (CDP) space.
- 3 year of experience in administrator role in other Salesforce cloud.
- Minimum 1-year implementation experience for one or more Customer Data Platforms  
- Minimum 1-year hands on SQL experience  Bachelor's degree or equivalent  Experience on Lightning web components. 2+ years of experience with data management, data transformation, ETL, preferably using cloud-based tools/infrastructure.  
- Attitude for taking on technical challenges.
- Relevant Salesforce experience in Sales & Service Cloud as well as Marketing Cloud, related certifications is a plus (Marketing Cloud Consultant, Administrator, Advanced Administrator, Service Cloud Consultant, Sales Cloud Consultant, etc.

- 2+ years of hands-on experience with marketing data in MarTech and/or Data Cloud (CDP) space.
- 3 year of experience in administrator role in other Salesforce cloud.
- Minimum 1-year implementation experience for one or more Customer Data Platforms  
- Minimum 1-year hands on SQL experience  Bachelor's degree or equivalent  Experience on Lightning web components. 2+ years of experience with data management, data transformation, ETL, preferably using cloud-based tools/infrastructure.  
- Attitude for taking on technical challenges.
- Relevant Salesforce experience in Sales & Service Cloud as well as Marketing Cloud, related certifications is a plus (Marketing Cloud Consultant, Administrator, Advanced Administrator, Service Cloud Consultant, Sales Cloud Consultant, etc.

- Creating and managing roles and permissions. Manage and create users/accesses.
- Create and manage FTP users and directories, Handle SFTP key management.
- Setup "Sender Authentication Package (SAP)", Manage "send classifications".
- Manage Audit trail, Manage data import, and export in SFMC.
- Create reports and send analytics.
- Create and monitor file drop and schedule automation.
- Track latest release impacts, install packages, and Set up New SFMC Bus.
- Document CRs, Basic SQL hands-on Work with data integration technologies to design and implement new solutions and processes for clients to support new customer experience strategies  Identify data points required to enable use cases Analyze data for usability in CDP Identify data cleansing requirements Map data sources to CDP data objects (which requires detailed knowledge of the CDP data model) Map data fields to CDP data fields Identify the need to custom CDP objects Determine the relationship between CDP data objects Identify the appropriate primary and secondary keys for each object Determine the specific unification algorithms required for the data of a given client
- Design test data to test the data model and unification algorithms Execute complex system tests

---