Key Responsibilities

1. Prepare and circulate daily, weekly, and monthly MIS reports as required by management.

2. Collect, consolidate, verify, and maintain data received from different departments.

3. Develop and maintain Excel-based dashboards, trackers, reports, and performance summaries.

4. Monitor data accuracy, identify discrepancies, and coordinate with concerned departments for corrections.

5. Prepare department-wise reports covering sales, operations, procurement, logistics, collections, attendance, and other business activities.

6. Track key performance indicators (KPIs) and highlight variances or key trends to management.

7. Maintain structured databases and ensure proper documentation and version control of MIS records.

8. Automate repetitive reporting tasks using advanced Excel functions, Pivot Tables, Power Query, and other relevant tools.

9. Generate ad-hoc reports and analysis based on management requirements.

10.



Coordinate with department heads to ensure timely submission of required data and reports.

11. Maintain confidentiality and security of company data and management reports.

12. Support management with data analysis for operational and business decision-making.Role & responsibilities

Required Skills

- Advanced MS Excel

- Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS

- Excel dashboards and data visualization

- Power Query preferred

- MIS reporting and data analysis

- Strong attention to detail and data accuracy

- Good analytical and problem-solving skills

- Good communication and coordination skills

- Ability to manage multiple reports and deadlines

- Knowledge of Power BI will be an advantage

- Basic knowledge of ERP/MIS software preferred

📌 Walk-in || Senior Mis Executive (Ranchi)
🏢 PDC and group of companies
📍 Ranchi