Overview
On Site
USD 89,000.00 - 149,000.00 per year
Full Time
Skills
MAGIC
Leadership
Pivotal
Decision-making
Innovation
Management
Data Storage
Scalability
Scripting
Space Planning
Database
Data Modeling
Data Management
Collaboration
Data Flow
Analytics
SQL
Insurance
Legal
SQL Azure
Writing
Stored Procedures
Performance Tuning
Optimization
Database Design
Data Architecture
Sales
Snow Flake Schema
Microsoft Power BI
Cloud Computing
Communication
Organizational Skills
Reporting
LOS
Recruiting
Law
Job Details
Overview
We are PepsiCo
PepsiCo is a playground for curious people. We invite thinkers, doers, and changemakers to champion innovation, take calculated risks, and challenge the status quo. From executives to team members on the front lines, we're excited about the future. We take chances. Together, we dare to make the world a better place.
Our associates are the magic ingredient. Each of them plays an integral role in helping create deep connections between people and our products. Think about your last group celebration: Chances are, one of our iconic brands was by your side. At PepsiCo, you're invited to be a part of a global team of innovators who make, move, and sell these products-which are enjoyed by more than 1 billion people a day.
A career at PepsiCo means working in a culture where everyone's welcome. Here, you can dare to be yourself. No matter who you are or where you're from, you can influence the people around you and the world at large. By showing up, you'll have the opportunity to learn, develop and grow your skills for the future. Our supportive teams can fuel your professional goals to make a global impact on people and the planet.
Join us. Dare for Better.
Who We Are
The North America Insights & Intelligence (NAI&I) team drive a human-centric and integrated Power of One (PO1) approach to insights and intelligence across our North America Commercial and Consumer organizations, to drive market-leading growth for PepsiCo. The team provides deep Food & Beverage expertise across Shopper Analytics & Insights, Consumer Insights, Commercial Intelligence and Category Leadership to build best-in-class capabilities and offer focused programs to drive growth with our customers.
Join us for a rewarding opportunity for personal and professional growth. You will have a unique opportunity to expand your commercial and consumer knowledge.
Responsibilities
As an Associate Manager, Space Analytics & Data Optimization, you will play a pivotal role in shaping the future of our space management capabilities through data, technology, and automation. You'll be responsible for designing, optimizing, and maintaining Azure SQL and other database environments that power critical business decisions-especially in support of our Digital Planogram Ordering (DPO) system and frontline sales tools. By driving digitalization and enabling faster, smarter, better decision-making, you'll help transform how our sales teams do business and unlock new ways of working. At PepsiCo, we invite you to Dare For Better-leveraging innovation to build the future of space management.
Compensation & Benefits:
Qualifications
>
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
We are PepsiCo
PepsiCo is a playground for curious people. We invite thinkers, doers, and changemakers to champion innovation, take calculated risks, and challenge the status quo. From executives to team members on the front lines, we're excited about the future. We take chances. Together, we dare to make the world a better place.
Our associates are the magic ingredient. Each of them plays an integral role in helping create deep connections between people and our products. Think about your last group celebration: Chances are, one of our iconic brands was by your side. At PepsiCo, you're invited to be a part of a global team of innovators who make, move, and sell these products-which are enjoyed by more than 1 billion people a day.
A career at PepsiCo means working in a culture where everyone's welcome. Here, you can dare to be yourself. No matter who you are or where you're from, you can influence the people around you and the world at large. By showing up, you'll have the opportunity to learn, develop and grow your skills for the future. Our supportive teams can fuel your professional goals to make a global impact on people and the planet.
Join us. Dare for Better.
Who We Are
The North America Insights & Intelligence (NAI&I) team drive a human-centric and integrated Power of One (PO1) approach to insights and intelligence across our North America Commercial and Consumer organizations, to drive market-leading growth for PepsiCo. The team provides deep Food & Beverage expertise across Shopper Analytics & Insights, Consumer Insights, Commercial Intelligence and Category Leadership to build best-in-class capabilities and offer focused programs to drive growth with our customers.
Join us for a rewarding opportunity for personal and professional growth. You will have a unique opportunity to expand your commercial and consumer knowledge.
Responsibilities
As an Associate Manager, Space Analytics & Data Optimization, you will play a pivotal role in shaping the future of our space management capabilities through data, technology, and automation. You'll be responsible for designing, optimizing, and maintaining Azure SQL and other database environments that power critical business decisions-especially in support of our Digital Planogram Ordering (DPO) system and frontline sales tools. By driving digitalization and enabling faster, smarter, better decision-making, you'll help transform how our sales teams do business and unlock new ways of working. At PepsiCo, we invite you to Dare For Better-leveraging innovation to build the future of space management.
- Build and optimize data storage systems that support space analytics, including table structures, indexing strategies, and partitioning in Azure SQL to ensure performance and scalability.
- Develop and maintain stored procedures, views, and scripts to support internal tools used by frontline sales teams and space planning stakeholders.
- Act as the primary database expert on the Space Analytics & Automation team, focusing on efficient data modeling, performance tuning, and large-scale data management.
- Partner with sales and customer teams to understand planogram logic and translate business needs into robust backend data solutions.
- Collaborate cross-functionally with internal teams (NAII, S&T (Strategy and Transformation), sector teams, etc.) to align on end-to-end data flow, ensuring consistent and reliable access to high-quality data.
- Lead efforts to organize and centralize internal data sources, enabling smarter analytics and more seamless tool development.
- Contribute to the development of internal tools by providing clean, optimized datasets and designing backend processes that support user-facing solutions.
- Be at the forefront of building the team's data infrastructure, directly influencing how data is collected, stored, and leveraged for growth.
- Snowflake experience is a plus, as we expand our analytics capabilities beyond traditional SQL environments.
Compensation & Benefits:
- The expected compensation range for this position is between $89,000 - $149,000.
- 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 10% 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.
- 3-5 years of experience and strong proficiency working with Azure SQL, including writing complex stored procedures, performance tuning, and index optimization required.
- Strong understanding of relational database design and data architecture best practices.
- Experience working with cross-functional business teams, especially sales or operations, to translate business logic into data-driven solutions.
- Familiarity with Snowflake, Power BI, or other cloud-based data platforms is a bonus.
- Experience working in the CPG industry is a bonus.
- Strong communication and organizational skills with the ability to work outside traditional IT silos and within a fast-paced, evolving business environment.
>
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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.