Data Analyst

Sylvi; Surat; On-site; INR 500,000 - 700,000; Full time

Job summary

Sylvi in Surat, India seeks a Data Analyst to clean, validate, and consolidate data from multiple sources. You will analyze sales, inventory, and operations performance, reconcile stock, and build MIS reports and KPI dashboards.

The role involves automating recurring reports and ensuring precise data formulas, with training provided for e-commerce processes. Ideal candidates have strong Excel/Sheets skills, SQL, Power BI/Looker Studio familiarity, and meticulous attention to detail.

Qualifications

• Experience in cleaning, validating and reconciling data from multiple sources.
• Ability to create MIS reports and KPI dashboards.
• Experience with data cleaning and reconciliation processes.
• Experience with dashboard development and reporting automation.

Responsibilities

• Clean, validate and consolidate data from multiple sources.
• Analyse sales, inventory and operational performance.
• Reconcile SKU-wise stock and identify discrepancies.
• Create MIS reports and KPI dashboards.
• Identify trends, risks and performance gaps.
• Present data-supported findings and recommendations.
• Automate recurring reports and manual processes.
• Maintain accurate formulas, logic and documentation.

Skills

Advanced Excel

Google Sheets

Power Query

Pivot Tables

Data cleaning

Reconciliation

Dashboard & KPI reporting

XLOOKUP / SUMIFS / COUNTIFS

Analytical thinking

Attention to detail

Clear communication

Presentation skills

Tools

Power BI

Looker Studio

Google Apps Script

Python (basic)

SQL

Job description

Job Summary

Role Summary We are looking for a Data Analyst skilled in data cleaning, reconciliation, KPI reporting, dashboard creation and reporting automation. E-commerce process training will be provided internally.

Responsibilities

• Clean, validate and consolidate data from multiple sources.
• Analyse sales, inventory and operational performance.
• Reconcile SKU-wise stock and identify discrepancies.
• Create MIS reports and KPI dashboards.
• Identify trends, risks and performance gaps.
• Present data-supported findings and recommendations.
• Automate recurring reports and manual processes.
• Maintain accurate formulas, logic and documentation.

Required Skills

• Advanced Excel and Google Sheets
• Power Query and Pivot Tables
• Data cleaning and reconciliation
• Dashboard and KPI reporting
• Xlookup, sumifs, countifs, query and arrayformula
• Analytical thinking and root-cause analysis
• Strong accuracy and attention to detail
• Clear communication and presentation skills

Preferred Skills

• SQL
• Power BI or Looker Studio
• Google Apps Script
• Basic Python
• Inventory, retail or e-commerce data experience

Selection Process

• Shortlisted candidates will complete a practical test covering data cleaning, inventory analysis, reconciliation, dashboard creation and business recommendations.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.