Google Sheets Expert

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 strong 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

* Strong Analytical & Problem-Solving Skills

* Excellent Attention to Detail

* Good Communication Skills

* Time Management

Preferred Skills

* Basic Google Apps Script

* Automation of Reports

* Experience handling large datasets

* Knowledge of business reporting and KPI dashboards