About PepsiCo

PepsiCo is one of the world's leading food and beverage companies, with a portfolio that includes iconic brands like Pepsi, Lay's, Gatorade, and Quaker. Operating in over 200 countries, PepsiCo employs over 300,000 people globally and generates annual revenues exceeding $90 billion. In India, PepsiCo has a strong presence with manufacturing facilities, distribution networks, and innovation centers driving growth in the consumer packaged goods (CPG) sector. As a Data Modeler in Hyderabad, you'll contribute to PepsiCo's digital transformation, powering data-driven decisions in revenue management, supply chain, manufacturing, and logistics.

Role Overview

The Data Modeler role at PepsiCo in Hyderabad partners with the D&A Data Foundation team to design and implement robust data models for global projects. This position focuses on analyzing data needs, identifying storage and integration requirements, and promoting data model reuse. You'll advocate for Enterprise Architecture and Data Design standards, creating conceptual, logical, and physical data models for large-scale, cloud-based applications. Impacting PepsiCo's flagship data products, this role supports key areas like Revenue Management, Supply Chain, Manufacturing, and Logistics, ensuring scalable, efficient data solutions in a dynamic CPG environment.

Key Technologies

Work with cutting-edge platforms including Snowflake, Azure Synapse, SQL Data Warehouse, EMR, Spark, and Databricks. Leverage tools like ER/Studio and Erwin for modeling, while integrating with multi-cloud (Azure) and on-premises technologies.

Key Responsibilities

In this role, you'll drive data excellence through hands-on modeling and collaboration:

• Design conceptual, logical, and physical data models for platforms such as Snowflake, Azure Synapse, SQL Data Warehouse, EMR, Spark, and Databricks.
• Govern data design and modeling, including metadata documentation and database object construction.
• Collaborate with Data Governance, Data Engineering, and Data Architects to ensure compliance with enterprise standards.
• Prepare Source-to-Target mappings and define data transformation rules for ETL and BI developers.
• Support data lineage, profiling, and metadata management for enterprise data models.
• Develop reusable data models with an extensible philosophy to minimize future rework.
• Partner with IT and business teams to incorporate security, regulatory compliance, and privacy-by-design principles.
• Drive collaborative reviews of design, code, and data security features.
• Assist with data planning, sourcing, collection, profiling, and transformation.
• Advocate data design patterns for scalable and efficient models.

Qualifications & Requirements

To succeed, candidates must meet these must-have criteria:

• 5+ years overall technology experience, including 2+ years in data modeling and systems architecture.
• 2+ years experience developing Enterprise Data Models.
• Expertise in data modeling tools: ER/Studio, Erwin, IDM/ARDM.
• Experience with Snowflake and at least one MPP database technology (Synapse, Teradata, Redshift).
• 2+ years experience with Data Lake Infrastructure, Data Warehousing, and Data Analytics tools.
• Strong knowledge of Source-to-Target mapping and canonical model design.
• Experience with multi-cloud integration (Azure) and on-premises technologies.
• Basic SQL and/or Python skills.
• Excellent verbal and written communication skills.
• Bachelor’s degree in Computer Science, Data Management/Analytics, Information Systems, or related discipline.

Desirable Skills

Stand out with: Knowledge of Azure Data Factory, Databricks, Azure Machine Learning; data quality tools (Apache Griffin, IDQ, Great Expectations, Axon); Azure Basic Certification; metadata management; SAP data; CPG industry; ML, GitHub, CI/CD; Agile/DevOps/DataOps; BI tools like Power BI.

Benefits & Perks

PepsiCo offers a premium compensation package tailored for top talent in India:

• Competitive salary estimated at ₹15-26 lakhs per annum, based on Food & Beverage sector rates with a 5-10% buffer.
• Performance-based incentives and bonuses.
• Comprehensive health insurance, including family coverage, mental wellness programs, and gym memberships.
• Generous paid time off, flexible hybrid work arrangements, and modern facilities in Hyderabad's tech hub.
• Employee stock purchase plans and retirement benefits.
• Learning stipends, certifications reimbursement, and access to PepsiCo University for skill development.

Career Growth

At PepsiCo, career progression is data-driven. Data Modelers advance to Senior Data Architect, Data Platform Lead, or global D&A roles. With exposure to high-impact projects, mentorship from experts, and Agile/DataOps practices, you'll build a trajectory in cloud data engineering, AI/ML integration, and enterprise governance. PepsiCo's commitment to internal mobility means opportunities across India and worldwide offices.

Why Join Us

Join PepsiCo's Hyderabad team to work on transformative projects for a global giant. Collaborate with cross-functional experts, innovate in cloud data modeling, and contribute to sustainable supply chains in the CPG industry. Enjoy a premium work culture emphasizing innovation, inclusivity, and impact. PepsiCo values diversity, with employee resource groups and leadership programs fostering growth. In Hyderabad's vibrant tech ecosystem, you'll thrive in a role blending technical depth with business strategy.

Role FAQs

What is the experience level required?

5+ years in technology, with 2+ in data modeling.

Is relocation support provided?

Yes, for eligible candidates, including housing assistance.

What tools will I use daily?

ER/Studio, Erwin, Snowflake, Azure Synapse, SQL, Python.

Is this a hybrid role?

Yes, flexible hybrid model with office in Hyderabad.

How does PepsiCo support certifications?

Reimbursement for Azure and relevant data certs.