Data Analyst

Navneet Education Limited; Mumbai; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Navneet Education Limited is seeking a Data Analyst to translate CRM, ERP, and factory data into actionable insights. You will own dashboard and report development across Power BI, Looker Studio, and other BI tools, surfacing coverage metrics, operational efficiency, and data health scores for leadership.

You will collaborate with the Data Management Lead and SBUs to ensure data is structured, accurate, and presented to drive decision-making across the organization, with a strong focus on data

Qualifications

• Bachelor's degree; preference for Engineering, Statistics, Commerce, or Computer Applications
• MBA or Analytics specialization is an advantage
• Proficiency in BI tools (Power BI / Looker Studio)
• Strong SQL/MySQL and Python skills
• Experience with ERP/CRM and factory data integration

Responsibilities

• Design, build, and maintain dashboards and reports across CRM/ERP datasets
• Translate data into KPI views for leadership
• Create a Master Dashboard consolidating departmental views for organisation-wide visibility
• Apply DAX, Power Query, and data modelling best practices for scalable dashboards

Skills

SQL / MySQL

Looker Studio

Python (Pandas)

ERP/CRM data integration

KPI design

Stakeholder management

Data storytelling

SOP documentation

Education

Bachelor's degree

MBA / Analytics

Tools

Power BI

Looker Studio

SAP SD/MM

Job description

• Minimum 2-3 years of hands-on experience in BI/dashboarding tools (Power BI, Looker Studio, or equivalent)
• Experience working with ERP/CRM data (SAP SD/MM or equivalent) strongly preferred

Role Summary

The Data Analyst will be responsible for translating the Group’s data - spanning customer/stakeholder data (Teachers, Schools, Retailers, Distributors, Vendors, Partners) and factory operations data (production, dispatch, inventory, material movement) - into actionable business insights. The role owns dashboard and report development across CRM and ERP systems, surfacing coverage metrics, campaign engagement, operational efficiency, data health scores, and compliance status for SBU heads, plant leadership, and senior management.

The position works closely with the Data Management Lead, Governance Lead, Marketing Automation Lead, and SBU stakeholders to ensure data is structured, accurate, and presented in a way that drives decision-making across the organisation.

Key Responsibilities

• Design, build, and maintain dashboards and reports (Power BI / Looker Studio / equivalent BI tools) covering coverage metrics, campaign engagement, operational performance, data health, and compliance status across customer and factory datasets.
• Translate raw CRM, ERP, and factory operations data into business-ready KPI views for SBU heads, plant leadership, and senior management.
• Build and maintain a Master Dashboard consolidating departmental views into a single navigation hub for organisation-wide visibility.
• Apply DAX, Power Query, and data modelling best practices (star schema, row-level security) to ensure dashboards are scalable, secure, and performant.

Data Analysis & Insights

• Conduct customer/stakeholder segmentation analysis across Teachers, Schools, Retailers, Distributors, Vendors, and Partners to identify trends, inactivity, and engagement patterns; present findings and recommendations to leadership.
• Analyse factory operations data - production output, dispatch, material movement, and inventory - to identify inefficiencies, optimisation opportunities, and cost-saving areas (e.g. slow-moving stock, process bottlenecks, vendor price variations).
• Sanitise and centralise data from disparate CRM, ERP, and factory systems into a single, governed source of truth - ensuring consistent definitions, eliminating duplicate/conflicting records, and enabling unified reporting across the organisation.
• Perform data cleansing, deduplication, and validation across CRM, ERP, and factory systems to maintain data quality and integrity.
• Conduct exploratory and variance analysis to flag anomalies, policy violations, or process gaps for resolution by the relevant function (Data Management Lead, Governance Lead, SBU teams, or plant operations).
• Support ad-hoc analytical requests from SBU heads, plant leadership, and senior management with quick-turnaround data pulls and visualisations.

Data Integration & ETL

• Build and maintain ETL pipelines to extract, cleanse, and load data from CRM, ERP, marketing automation, and factory operations systems into reporting tools.
• Maintain unique key mapping and data integration logic across systems to eliminate data silos and ensure a single source of truth for stakeholder data.
• Coordinate with the Data Management Lead on data quality rules, validity standards, and master data structure to ensure reporting reflects the governed data model.

Stakeholder Support & Coordination

• Gather reporting requirements from SBU heads, departmental teams, and leadership; translate business questions into dashboard and KPI specifications.
• Support the Marketing Automation Lead with campaign performance reporting and ROI analysis across WhatsApp, email, and SMS channels.
• Document dashboard logic, data definitions, and reporting SOPs to ensure consistency and ease of handover.
• Train SBU users on self-service dashboard usage where applicable.

Qualifications

• Bachelor's degree in any discipline; preference for Engineering, Statistics, Commerce, or Computer Applications
• MBA or equivalent specialisation in Business Analytics / Data Science is an advantage
• Power BI / Power BI Developer
• SQL / MySQL
• Python for Data Analysis

Required Skills

Strong proficiency in:

• SQL / MySQL
• Google Looker Studio and/or other BI/analytics platforms
• Working knowledge of Python (Pandas, NumPy) for data analysis and automation
• Experience integrating and reporting on ERP/CRM and factory/production data (SAP SD/MM or equivalent)
• Strong understanding of KPI design, MIS reporting, and data storytelling for senior leadership audiences
• Ability to manage multiple stakeholders across SBUs and translate business requirements into reporting solutions
• Strong analytical and problem-solving skills, with attention to data accuracy and detail
• Process orientation: ability to document SOPs and maintain reporting consistency at scale

Key Performance Indicators (KPIs)

• Dashboard Coverage & Adoption: Core KPI dashboards live and actively used by SBU heads and plant leadership; usage/adoption tracked monthly.
• Reporting Turnaround: Standard reports delivered on defined refresh cycles; ad-hoc analytical requests turned around within agreed SLA.
• Data Quality & Accuracy: Data health score maintained above target threshold across CRM, ERP, and factory datasets; duplicate/erroneous records identified and flagged for correction.
• Operational Insights Delivered: Number and impact of actionable insights surfaced (e.g. inventory optimisation, cost savings, process inefficiencies identified) and adopted by business/plant teams.
• Customer/Stakeholder Insights Delivered: Segmentation and engagement analyses delivered on schedule, with measurable follow-through on recommendations (e.g. re-engagement campaigns, coverage improvement).
• Automation Impact: Manual reporting effort reduced through automation of recurring reports/alerts, tracked as hours saved.