Job Title: Google Sheets Expert (MIS & Data Analyst)

Job Description

We are looking for a highly skilled Google Sheets Expert who can efficiently manage, analyze, and organize large datasets. The ideal candidate should have robust expertise in Google Sheets, Advanced Excel, MIS reporting, dashboard creation, and data analysis. The candidate must be able to create automated reports, maintain data accuracy, and provide actionable insights through well-structured dashboards.

Key Responsibilities
Manage and maintain large datasets in Google Sheets.
Create and maintain MIS reports and business dashboards.
Use advanced formulas such as VLOOKUP, XLOOKUP, INDEX-MATCH, QUERY, IF, SUMIFS, COUNTIFS, ARRAYFORMULA, and FILTER.
Build Pivot Tables, Charts, and automated reports.
Perform data cleaning, validation, sorting, filtering, and formatting.
Analyze business data and generate meaningful insights.
Prepare daily, weekly, and monthly reports.
Ensure data accuracy and consistency across reports.




Integrate Google Forms with Google Sheets for data collection.
Automate repetitive tasks using basic Google Apps Script (preferred).
Coordinate with internal teams to collect, update, and manage business data.
Maintain confidentiality and accuracy of company data.

Required Skills
Advanced Google Sheets
Advanced Microsoft Excel
Data Analysis
MIS Reporting
Dashboard Creation
Pivot Tables & Charts
VLOOKUP, XLOOKUP, INDEX-MATCH
QUERY, IF, SUMIFS, COUNTIFS
Conditional Formatting
Data Validation
Data Cleaning & Data Management
Google Forms
Google Workspace
Report Generation
Solid Analytical & Problem-Solving Skills
Excellent Attention to Detail
Positive Communication Skills
Time Management

Preferred Skills
Basic Google Apps Script
Automation of Reports
Experience handling large datasets
Knowledge of business reporting and KPI dashboards

📌 Google Sheets Expert Gurugram
🏢 Durawot Industries Private
📍 Gurugram