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 clear 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 contemporary 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,financ
📌 Data Analyst (Gurugram)
🏢 MG
📍 Gurugram