Job Purpose To manage retail sales data and develop accurate, productive MIS reports using advanced Google Sheets formulas, data analysis and reporting tools.

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

Robust hands-on knowledge of:





SUMIF / SUMIFS | COUNTIF / COUNTIFS | QUERY FUNCTION | TRIM | FILTER | SORT | UNIQUE | INDEX-MATCH | XLOOKUP | IF / IFS | IFERROR | ARRAYFORMULA | TEXT / DATE functions | Pivot Tables | Data Validation | Conditional Formatting
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: ₹20,000.00 - ₹25,000.00 per month

Application Question(s)
Do you have relevant experience in MIS / Sales MIS / Retail Reporting ?
Explain how you use Google Sheets formulas such as XLOOKUP, INDEX-MATCH, QUERY, and ARRAYFORMULA in MIS reporting. ?
How would you analyze sales performance and identify top-selling and bottom-selling products?
Do you have the Solid knowledge of :

SUMIF / SUMIFS | COUNTIF / COUNTIFS | QUERY FUNCTION | TRIM | FILTER | SORT | UNIQUE | INDEX-MATCH | XLOOKUP | IF / IFS | IFERROR | ARRAYFORMULA | TEXT / DATE functions | Pivot Tables | Data Validation | Conditional Formatting ?

Education
Bachelor's (Preferred)

Experience:
MIS Executive: 2 years (Preferred)

Location:
Topsia, Kolkata, West Bengal (Preferred)

Work Location: In person

📌 Mis Executive Topsia (India)
🏢 intellisolvers
📍 India