Key Responsibilities

- Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
- Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
- Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
- Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
- Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
- Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
- Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
- Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.




- Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.

Required Skills & Qualifications

- Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.
- Proven experience (1–3 years or as per company requirement) in MIS, data reporting/analysis, or similar role.
- Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
- Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
- Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
- Positive communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
- Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.

Skills:- MS-Excel and PowerBI

📌 Sr. MIS Executive (Mumbai)
🏢 Apprication
📍 Mumbai