MIS Executive

ESP Engineered; Pune District; On-site; INR 500,000 - 800,000; Full time

Job summary

ESP Engineered in Pune District, Maharashtra, is seeking a skilled data analyst to prepare and manage daily, weekly, and monthly MIS reports. The candidate will collect, validate, and analyze data from multiple departments, maintain accuracy across systems, and generate analytical reports.

The ideal candidate must be proficient in MS Excel and Power BI, with a solid understanding of data modeling and the ability to create visual reports. Strong communication skills and attention to detail are essential for this role.

Qualifications

• Strong knowledge of MS Excel and reporting tools.
• Hands-on experience with Power BI, dashboards, and DAX queries.
• Understanding of data modeling concepts and reporting structures.
• Good analytical and problem-solving skills.
• Ability to interpret, visualize, and present data effectively.
• Knowledge of MIS reporting formats and KPI tracking.
• Experience in project progress tracking and reporting preferred.
• Good communication abilities.
• Strong attention to detail and accuracy in reporting.

Responsibilities

• Prepare daily, weekly, and monthly MIS reports and dashboards.
• Collect, organize, validate, and analyze business data from multiple departments.
• Maintain accurate databases and ensure data integrity across systems.
• Generate analytical reports and coordinate across multiple departments.
• Track project progress, construction updates, timelines, milestones, and status reporting.
• Develop dashboards and visual reports using Power BI and Excel.
• Perform data modeling and create efficient data structures for reporting and analytics.
• Write and optimize DAX queries/measures in Power BI for advanced reporting and KPI tracking.
• Create reports using Excel formulas, Pivot Tables, VLOOKUP/XLOOKUP, charts, and dashboards.
• Identify trends, gaps, risks, and performance insights through data analysis.
• Share timely and accurate reports with management and internal stakeholders.
• Ensure timely submission, consistency, and accuracy of all reports and analytics.

Skills

MS Excel

Power BI

DAX queries

Data modeling

Data analysis

Project tracking

Communication

Attention to detail

Job description

• Preparedaily, weekly, and monthly MIS reports and dashboards.
• Collect, organize, validate, and analyze business data from multiple departments.
• Maintainaccurate databases and ensure data integrity across systems.
• Generateanalytical reports and co-ordinate across multiple departments.
• Track project progress, construction updates, timelines, milestones, and status reporting.
• Developdashboards and visual reports using Power BI and Excel.
• Perform data modeling and create efficient data structures for reporting and analytics.
• Write and optimize DAX queries/measures in Power BI for advanced reporting and KPI tracking.
• Createreports using Excel formulas, Pivot Tables, VLOOKUP/XLOOKUP, charts, and dashboards.
• Identify trends, gaps, risks, and performance insights through data analysis.
• Share timely and accurate reports with management and internal stakeholders.
• Ensure timely submission, consistency, and accuracy of all reports and analytics.

Required Skills

Strongknowledge of MSExcel and reporting tools.

Hands-onexperience with Power BI, dashboards, and DAX queries.

Understanding of data modeling concepts and reporting structures.

Goodanalytical and problem-solving skills.

Ability to interpret, visualize, and present data effectively.

KnowledgeofMISreporting formats and KPI tracking.

Experience in project progress tracking and reporting preferred.

Goodcommunicationabilities.

Strongattention to detail and accuracy in reporting.