Website Nestley

Data Analyst – Nestlé India

SEO Content & Metadata

  • Post Title: Nestlé Data Analyst Hiring 2026: Role Overview, Power Platform & Requirements

  • SEO Title: Nestlé Data Analyst Role | Gurugram | MIS, Power BI & Power Automate

  • Meta Description: Detailed analysis of the Data Analyst (3rd Party Payroll) position at Nestlé India in Gurugram. Overview of responsibilities in SQL, Power BI, Advanced Excel, and Power Apps/Automate.

Opportunity Overview

Attribute Details
Organization Nestlé India (Consumer FMCG)
Position Title Data Analyst (3rd Party Payroll)
Experience Requirement 1 – 3 Years in Data Analytics, MIS, or Business Intelligence
Primary Location Gurugram, Haryana, India (DLF City Phase II)
Department Data Science & Analytics
Employment Type Full-Time, Temporary/Contractual (3rd Party Payroll)
Target Sector Fast-Moving Consumer Goods (FMCG)
Academic Target B.Sc, B.A. in Statistics, B.Tech / B.E. in any specialisation
Core Technical Stack SQL, Power BI, Advanced Excel (VBA/Macros), Power Automate, Power Apps, Python

Operations & Automation Workflow

The Data Analyst at Nestlé manages the complete operational analytics lifecycle—from raw data extraction to building low-code applications and interactive leadership dashboards:

┌───────────────────────────────────────────┐
│ 1. ETL & Database Querying               │ ➔ Write optimized SQL queries to extract & transform raw transactional data
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 2. Excel & Advanced Modeling             │ ➔ Construct complex financial/MIS models, VBA macros, and KPI trackers
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 3. Dashboarding & Executive MIS           │ ➔ Build interactive Power BI dashboards for leadership & cross-functional teams
└─────────────────────┬─────────────────────┘
                      ▼
┌───────────────────────────────────────────┐
│ 4. Workflow Automation & App Deployment   │ ➔ Create Power Automate flows and deploy lightweight Power Apps for ops teams
└───────────────────────────────────────────┘

Key Responsibilities

  • Data Cleansing & MIS Reporting: Collect, validate, and cleanse multi-source FMCG datasets to produce accurate periodic MIS reports and ad-hoc business analyses.

  • SQL Querying & ETL Automation: Construct and optimize SQL scripts to extract, transform, and load data into structured pipelines for recurring reporting.

  • Power BI Dashboard Development: Architect and maintain interactive Power BI visual dashboards for senior leadership and operational departments.

  • Advanced Excel Modeling: Design financial and operational trackers using advanced functions (INDEX-MATCH, VLOOKUP, pivot tables) and automated VBA macros.

  • Low-Code App & Workflow Automation: Build automated workflows using Power Automate and custom business apps via Power Apps to streamline repetitive tasks.

Qualification Matrix & Technical Stack

Core Requirements

Category Specifications
Educational Background B.Tech/B.E., B.Sc, or B.A. in Statistics/Quantitative fields.
Professional Experience 1 to 3 years in data analytics, MIS reporting, or operational BI roles.
Business Intelligence End-to-end expertise in Power BI (DAX, data modeling, dashboard deployment).
Database & Scripting Advanced SQL (ETL pipeline design, window functions) and foundational Python skills.
Excel & VBA Expert-level Excel skills including Macros/VBA, nested formulas, and dynamic templates.
Microsoft Power Platform Hands-on creation of Power Automate flows and Power Apps canvas applications.

Key Focus Areas for Interview Preparation

  1. Power Platform Integration: Be ready to demonstrate how Power BI, Power Automate, and Power Apps connect to streamline business processes.

  2. SQL & ETL Pipelines: Practice writing complex SQL queries for data aggregation, data deduplication, and automated reporting scheduled tasks.

  3. Advanced Excel & VBA Scenarios: Prepare for practical technical assessments involving complex lookup logic, dynamic charting, and macro-based process automation.

Upload your CV/resume or any other relevant file. Max. file size: 2 GB.