Project Coordinator - Operations MIS & Reporting

ECLAT Health Solutions; Mumbai; On-site; INR 600,000 - 900,000; Full time

Job summary

ECLAT Health Solutions is seeking a detail-oriented Project Coordinator to support project tracking, MIS reporting, and dashboard development. You will manage data accuracy, consolidate operational metrics, and coordinate with multiple stakeholders to ensure timely reports.

The role emphasizes data management, performance monitoring, and report submission to internal and external stakeholders, with emphasis on Excel-based automation and Power BI-driven insights.

Qualifications

• 5 years of experience in project coordination and MIS reporting.
• Proficient in Advanced Excel (Pivot Tables, VLOOKUP/XLOOKUP, Index-Match, Data Validation, Conditional Formatting).
• Experience in creating and maintaining MIS dashboards and management reports.

Responsibilities

• Maintain and update project trackers, databases, and operational reports.
• Consolidate production, quality, attendance, staffing, and utilization data.
• Prepare daily, weekly, and monthly MIS reports.
• Generate dashboards and management reports; highlight gaps and risks.
• Coordinate with HR, Recruitment, Operations and Training teams.
• Standardize reporting formats and templates; explore automation options.

Skills

Advanced Excel

MIS Reporting

Data Analysis

Power BI

Power Query

Stakeholder Coordination

Attention to Detail

Problem Solving

Time Management

Data Visualization

Education

Bachelor's Degree in Commerce, Science, Management, Data Analytics, or related field

Tools

Power BI

Power Query

Job description

Project Coordinator - Operations MIS & Reporting

5 Years

Full-Time

We are looking for a detail-oriented Project Coordinator to support project tracking, operational reporting, resource tracking, and management dashboards. The role will be responsible for maintaining project data, preparing MIS reports, tracking productivity and quality metrics, coordinating with multiple stakeholders, and ensuring timely submission of reports.

Key Responsibilities

Data Management & Reporting

• Maintain and update project trackers, databases, and operational reports.
• Consolidate production, quality, attendance, staffing, and utilization data.
• Ensure data accuracy, consistency, and timely updates.
• Maintain project-wise, client-wise, and team-wise reports.

Operations & MIS

• Prepare daily, weekly, and monthly MIS reports.
• Track productivity, quality, SLA, TAT, backlog, and resource utilization.
• Generate dashboards and management reports.
• Highlight performance gaps, risks, and operational concerns.

Resource Tracking

• Maintain employee allocation, reporting structures, training records, and certification details.
• Track new hires, transfers, resignations, and staffing requirements.
• Coordinate with HR, Recruitment, Operations, and Training teams.

Quality & Performance Monitoring

• Track quality scores, audit results, productivity metrics, and performance trends.
• Prepare quality and operational dashboards.
• Follow up with stakeholders for pending reports and updates.

Client & Project Coordination

• Maintain project trackers for staffing, production, quality, and deliverables.
• Support MBR and QBR preparation.
• Assist with invoice volume reconciliation and reporting requirements.
• Ensure timely report submission to internal and external stakeholders.

Process Improvement

• Standardize reporting formats and templates.
• Support reporting automation using Excel, Power BI, or Power Query.
• Maintain confidentiality and data security standards.

Required Skills

• Advanced Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, Index-Match, Data Validation, Conditional Formatting)
• MIS Reporting
• Data Analysis
• Power BI (Preferred)
• Power Query (Preferred)
• Stakeholder Coordination
• Attention to Detail
• Problem Solving
• Time Management

Preferred Background

• Healthcare Operations
• Medical Coding
• Revenue Cycle Management (RCM)
• Operations Reporting

Education

• Bachelor's Degree in Commerce, Science, Management, Data Analytics, or a related field.