MIS Executive - Google Sheets Expert

Industry: Retail & Apparel | Focus: Google Sheets & Sales MIS

Job Purpose To manage retail sales data and develop accurate, effective MIS reports using advanced Google Sheets formulas only, data analysis and reporting tools are a plus.

Key Responsibilities
Manage and maintain sales, product, style code, color, designer and transaction data.
Prepare daily, weekly, monthly and financial-year-wise sales MIS.
Analyze sales by Style Code, Product Category, Color, Designer and Month.
Identify Top & Bottom selling styles/products and sales trends.
Prepare product-wise and year-wise sales comparison reports.
Develop automated reports using Google Sheets formulas and functions.
Create and maintain Pivot Tables, dashboards, summaries and management reports.
Perform data cleaning, validation and reconciliation to ensure 100% data accuracy.
Identify sales trends, variances and anomalies and provide actionable insights to management.
Improve existing MIS formats and automate repetitive reporting processes.

Mandatory Google Sheets Skills

Strong hands-on knowledge of:





QUERY FORMULA | ARRAYFORMULA | UNIQUE | INDEX-MATCH | SUMIF / SUMIFS | COUNTIF / COUNTIFS | FILTER | SORT | XLOOKUP | IF / IFS | IFERROR | Pivot Tables | Data Validation | Conditional Formatting

Candidate Profile
2–4 years of experience in MIS / Sales MIS / Retail Reporting.
Strong Google Sheets expertise is mandatory (not looking for advance excel).
Positive understanding of retail sales and inventory data.
Robust analytical and numerical skills.
Excellent attention to detail and data accuracy.
Ability to convert raw data into meaningful management reports.
Experience in Apparel / Fashion / Lifestyle Retail preferred.

Key Performance Indicators
MIS accuracy and timely submission
Automation and reduction of manual reporting
Data integrity and reconciliation
Quality of sales analysis and management reports
Ability to identify meaningful business trends and insights

Pay: ₹22,000.00 - ₹28,000.00 per month

Work Location: In person

📌 Mis Executive Google Sheets Expert Topsia
🏢 Osaa by Adarsh
📍 Topsia