Logo of Huzzle

Associate Manager

image

PepsiCo

1mo ago

  • Job
    Full-time
    Senior Level
  • Data
  • Hyderabad, +1

AI generated summary

  • You need 5+ years in analytics, a relevant Master's degree, skills in PowerPoint, Excel, Python, mySQL, PowerBI, Snowflake, and insights into CPG business performance.
  • You will connect data sources, execute marketing reports, automate data collection, build data pipelines, ensure data quality, and collaborate on analytics for impactful insights.

Requirements

  • Analytics professional with 5 years+ experience. Exposure to CPG industry is preferred.
  • Education: Masters/Graduate in Engineering/Mathematics/Statistics or Marketing
  • Proficient with PowerPoint, Excel, Python, mySQL including ability to write complex logics
  • Proficient with PowerBI Dashboard creation is a must
  • Proficient in snowflake for Azure based data warehousing
  • Deep understanding of CPG industry business performance outputs and causal measures, their relationships, and how to bring business performance insights to life visually is a plus

Responsibilities

  • Connect multiple data sources through curated metrics and develop calculated metrics to focus on the key outcome and diagnostic measures.
  • Execute market, portfolio, and brand level reporting of Marketing KPI performance (utilizing dashboards, templated decks, and reporting tools).
  • Work with our agency partner to streamline and automate data collection, DQ checks and transform the data for data modelling intake.
  • Support processes for output adherence and delivery to agreed scope - in line with the agreed timelines, aligned global templates.
  • Design, build, and maintain scalable data pipelines for collecting, storing, and processing large datasets from various sources (databases, APIs, etc.).
  • Work closely with data analysts, data scientists, and business stakeholders to gather and integrate data from multiple sources for analysis.
  • Develop and implement effective data models, data warehouses, and data marts to enable high-quality reporting and analytics.
  • Develop and manage ETL (Extract, Transform, Load) processes to ensure the timely availability of clean, processed data for analytics and business intelligence.
  • Monitor and enforce data quality standards, ensuring the integrity, consistency, and reliability of data pipelines.
  • Maintain proper documentation for data pipelines, architecture, and data flows to facilitate knowledge sharing and maintainability.

FAQs

What is the primary focus of the Associate Manager role?

The primary focus is on driving market-level priorities, enhancing and automating business reporting, and creating new data pipelines to provide better performance insights for the ROI Engine Team.

What qualifications are required for this position?

A Master's or Graduate degree in Engineering, Mathematics, Statistics, or Marketing and 5 years of experience in analytics, preferably with exposure to the CPG industry.

What tools and technologies should a candidate be proficient in?

Candidates should be proficient in PowerPoint, Excel, Python, mySQL, and must have experience with PowerBI Dashboard creation. Proficiency in Snowflake for Azure-based data warehousing is also required.

Is experience in the CPG industry preferred for this role?

Yes, exposure to the CPG industry is preferred for this position, as a deep understanding of business performance outputs and causal measures is beneficial.

What responsibilities does this role include regarding data pipelines?

Responsibilities include designing, building, and maintaining scalable data pipelines, as well as developing and managing ETL (Extract, Transform, Load) processes.

Will the Associate Manager work closely with other teams?

Yes, the Associate Manager will work closely with data analysts, data scientists, and business stakeholders to gather and integrate data from multiple sources for analysis.

How important is data quality in this role?

Data quality is very important; the Associate Manager will monitor and enforce data quality standards to ensure the integrity, consistency, and reliability of data pipelines.

What types of reporting will the Associate Manager be responsible for?

The Associate Manager will be responsible for executing market, portfolio, and brand level reporting of Marketing KPI performance using dashboards, templated decks, and reporting tools.

Is documentation part of the responsibilities for this position?

Yes, maintaining proper documentation for data pipelines, architecture, and data flows is a key responsibility to facilitate knowledge sharing and maintainability.

What is the expected experience level for the ideal candidate?

The ideal candidate should have over 5 years of experience in analytics, with an emphasis on data engineering and business intelligence development.

What makes you unique, makes us better.

Retail & Consumer Goods
Industry
10,001+
Employees
1965
Founded Year

Mission & Purpose

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.

Benefits

  • Well-being

    We offer programs for you and your family to help you reach your personal physical, emotional and financial well-being goals.

  • Retirement Benefits

    Our savings and retirement benefits are designed to help you reach your future retirement goals.

  • Health and Insurance Benefits

    We’re committed to helping you and your family live a healthy lifestyle. Our medical options provide access to quality, affordable health care.