Key Responsibilities
1. Data Gathering & Extraction
- Extract, compile, and aggregate data daily, weekly, and monthly from various internal systems and departments.
- Ensure the accuracy, completeness, and timeliness of data collection to maintain the integrity of our databases.
- Liaise with different cross-functional teams to resolve any data discrepancies or missing information.
2. Data Organization & Management
- Clean, format, and structure raw data into standardized templates for easy analysis.
- Develop and maintain automated data pipelines where possible using Excel tools (e.g., Power Query) to reduce manual entry.
- Maintain organized digital records and repositories of historical reports for quick retrieval and audit purposes.
3. Reporting & Presentation
- Design, build, and maintain dynamic MIS dashboards and daily trackers tailored to management requirements.
- Translate complex datasets into visually appealing and easy-to-understand charts, graphs, and summary reports.
- Highlight key trends, variances, and anomalies in the data to assist leadership in swift decision-making.
Required Skills & Qualifications
- Experience: 1.5 to 2 years of hands-on experience in MIS, Data Analysis, or a similar reporting role.
- Advanced Excel Proficiency: Must be highly proficient in Advanced Excel. This includes:
- Complex formulas (XLOOKUP, INDEX/MATCH, nested IFs).
- Advanced Pivot Tables and Pivot Charts.
- Data Validation and Conditional Formatting.
- Familiarity with Power Query and basic Macros/VBA is highly preferred.
- Analytical Mind-set: Strong numerical aptitude with a sharp eye for detail and data accuracy..
Pay: ₹15,000.00 - ₹18,000.00 per month
Benefits:
Experience:
- XLOOKUP: 1 year (Required)
- VLOOKUP: 1 year (Required)
- Pivot tables: 1 year (Required)
- Power Pivot: 1 year (Required)
- MIS : 1 year (Required)
Location:
- Goregaon, Mumbai, Maharashtra (Required)
Work Location: In person
