About The Opportunity A fast-scaling tech-enabled services firm in the India-based analytics and business intelligence sector, we empower mid-market enterprises with data-driven decision-making through streamlined MIS reporting, automation, and Excel-centric analytics. Our team turns raw operational data into visual dashboards, KPI trackers, and executive summaries — helping clients optimize sales, inventory, and finance workflows with precision and speed.

Role & Responsibilities

- Design, build, and maintain dynamic Excel dashboards using VLOOKUP, PivotTables, SUMIFS, and macros to visualize KPIs across sales, operations, and finance.
- Automate repetitive MIS reporting by developing reusable Excel templates and formulas that reduce manual entry and improve accuracy.
- Extract, clean, and consolidate data from multiple sources (CSVs, ERP exports, CRM sheets) into unified reporting structures.
- Generate weekly/monthly MIS reports for leadership — highlighting trends, variances, and actionable insights with transparent visual charts.




- Support stakeholders across departments by resolving data discrepancies, answering ad-hoc queries, and providing quick-turnaround analytics.
- Collaborate with internal teams to identify automation opportunities and recommend Excel-based process improvements using Power Query or VBScript.

Skills & Qualifications Must-Have

- VLOOKUP
- Excel Dashboards
- PivotTables
- SUMIFS
- Power Query
- Microsoft Excel Advanced Functions
- MIS Reporting
- Data Consolidation

Preferred

- Power BI
- Basic Python (Pandas/NumPy)
- SQL Querying

Benefits & Culture Highlights

- On-site collaborative workspace with access to modern analytics tools and mentorship from senior data leads.
- Focused on rapid skill growth — you’ll deep-dive into Excel mastery and real-world MIS automation projects within 3 months.
- Performance-linked bonus culture — your impact is measured, recognized, and rewarded.

Skills: data,dashboards,excel dashboards,sales,analytics,reporting,excel,automation,vlookup,finance

📌 Data Analyst & MIS EXECUTIVE (VLOOKUP/EXCEL) (Gurugram)
🏢 MG
📍 Gurugram