Mis Data Analyst

Prop Solutions4u; Maharashtra; On-site; INR 600,000 - 1,200,000; Full time

Benefits offered by this job

Provident Fund

Medical Insurance

Paid Leaves

Annual Bonus

Festival Holidays

Rewards Program

Job summary

Prop Solutions4u is seeking an Assistant Manager / Deputy Manager MIS in Navi Mumbai to bridge reporting and strategic data initiatives. You will oversee daily MIS operations, ensure data accuracy, and support automated dashboards for senior management.

The role requires 3–5 years in MIS/Data Analytics, with proficiency in Excel, SQL, Looker Studio, and Power BI. It offers a WFO setup at Arihant Aura Business Park and opportunities to drive process improvements.

Qualifications

• Bachelor’s degree in Commerce, Business, Statistics, IT, or a related field.
• A Master’s degree or MBA is preferred.
• Certification in Power BI, Data Analytics, or Business Intelligence will be an added advantage.
• Candidates should have 3–5 years of experience in MIS, Data Analytics, or Business Intelligence.

Responsibilities

• Oversee end-to-end MIS reporting for business operations and sales reviews.
• Prepare and review daily, weekly, monthly, and quarterly MIS reports with high accuracy and timeliness.
• Ensure data consistency across multiple reports and dashboards.
• Perform data mining from multiple data sources (Databases, CRM, ERP).
• Conduct trend analysis and root-cause analysis to identify anomalies and improvement opportunities.
• Design, develop, and maintain dashboards using Google Sheets and Looker Studio.
• Translate business requirements into visual analytics and operational dashboards.
• Use Advanced Excel functions such as Power Query, VBA/Macros, complex formulas, and automation.
• Automate recurring reports using scripts and formulas.
• Work closely on API Integration and collaboration with Management.
• Execute independent logics per Company parameters.

Skills

Advanced Excel

SQL

Looker Studio

Power BI

Google Sheets

Data Mining

Data Modeling

Google Apps Script

API Integration

AI tools awareness

Education

Bachelor's degree

Master's degree/MBA

Power BI/Data Analytics certification

Tools

SQL

Supabase

Job description

Job Title (Designation): Assistant Manager / Deputy Manager - MIS

Role: Individual Contributor
Reporting To: Senior Manager
Office Location: Arihant Aura Business Park, Turbhe, Navi Mumbai
Mode of Work: Work from Office
Preferred Industry: Open to any industry
Gender: Any

Role Objective

The Assistant Manager / Deputy Manager MIS will bridge the gap between reporting and strategic data initiatives. The role is responsible for overseeing daily MIS operations, ensuring data accuracy, supporting automated dashboards, driving process improvements, and providing actionable insights to senior management.

Educational Qualification

• Bachelor’s degree in Commerce, Business, Statistics, IT, or a related field.
• A Master’s degree or MBA is preferred.
• Certification in Power BI, Data Analytics, or Business Intelligence will be an added advantage.
• Candidates should have 3–5 years of experience in MIS, Data Analytics, or Business Intelligence.

Technical Skills Required

• Advanced Excel;
• SQL and Supabase (intermediate to advanced queries, joins)
• Looker Studio / Power BI
• Advanced Google Sheets
• Data Mining and Data Modeling
• Knowledge of AI tools and applications
• Google Apps Script and Mail Automation
• API Integration.

Soft Skills & Competencies

• Strong analytical and problem-solving skills.
• Excellent communication and presentation abilities.
• Stakeholder management and requirement gathering.
• Attention to detail and data accuracy.
• Ability to work in a fast-paced, deadline-driven environment.

Key Roles & Responsibilities

1. MIS & Reporting Management:

• Oversee end-to-end MIS reporting for business operations and sales reviews
• Prepare and review daily, weekly, monthly, and quarterly MIS reports with high accuracy and timeliness
• Ensure data consistency across multiple reports and dashboards

2. Data Analysis & Mining:

• Perform data mining from multiple data sources (Databases, CRM, ERP)
• Conduct trend analysis and root-cause analysis to identify anomalies and improvement opportunities

3. Dashboarding & Data Visualization:

• Design, develop, and maintain interactive dashboards using Google Sheets and Looker Studio
• Translate business requirements into visual analytics and operational dashboards

4. Advanced Excel & Google Sheets Expertise:

• Use Advanced Excel functions such as Power Query, VBA/Macros, complex formulas, and automation
• Automate recurring reports using scripts and formulas

5. Stakeholder Management & Collaboration:

• Work closely on API Integration, Task Management System with the Management
• Execute independent logics as per Company parameters
• Conduct regular reviews to ensure 100% accuracy before finalizing reports

6. Process Improvement & Compliance:

• Identify opportunities for report automation and process optimization
• Ensure compliance with data governance, security, and audit requirements

Key Performance Indicators (KPIs)

• Accuracy and timely delivery of MIS reports with zero errors
• Automation and process efficiency.
• stakeholder satisfaction with dashboard adoption.

Employee Benefits

• Provident Fund (if applicable),
• Paid Leaves and Festival Holidays,
• Medical Insurance and Personal Accident Insurance,
• Maternity and Paternity Leave
• Annual Diwali Bonus, and Weekly, Monthly, and Quarterly Rewards for top-performing employees.