Mis Executive

Dhan Mitra Fin Services; NTR, Hyderabad; On-site; INR 300,000 - 520,000; Full time

Job summary

Dhan Mitra Fin Services is seeking a data analyst to prepare MIS reports and consolidate data from multiple departments. You will analyze data, create Excel trackers and dashboards, and ensure accuracy for management review.

The role requires strong Excel skills, attention to detail, and good communication to coordinate across branches and operations. Knowledge of Power BI is advantageous for reporting enhancements.

Qualifications

• Proficient in MS Excel with advanced functions and data analysis.
• Experience with Pivot Tables, VLOOKUP/XLOOKUP, and advanced formulas.
• Strong analytical and numerical skills.
• Excellent attention to detail and accuracy.
• Good communication and coordination abilities.
• Knowledge of Power BI is a plus.

Responsibilities

• Prepare and maintain MIS reports daily, weekly, and monthly.
• Collect data from multiple departments and consolidate it.
• Analyze data and prepare reports for management review.
• Maintain data for employees, sales, recruitment, branches, and operations.
• Create and update Excel trackers and dashboards.
• Ensure data accuracy, completeness, and timely reporting.
• Provide ad-hoc data analysis and reports.
• Coordinate with departments to gather required information.
• Identify and correct data discrepancies.
• Maintain records and databases.
• Support management with data-driven insights.

Skills

MS Excel

Power BI

Analytical skills

Attention to detail

Communication

Coordination

Data analysis

Tools

Pivot Tables

VLOOKUP/XLOOKUP

IF formulas

COUNTIFS

SUMIFS

Job description

Key Responsibilities:

• Prepare and maintain Daily, Weekly, and Monthly MIS reports.
• Collect data from different departments and consolidate it accurately.
• Analyze data and prepare reports for management review.
• Maintain employee, sales, recruitment, branch, and operational data.
• Create and update Excel trackers and dashboards.
• Ensure data accuracy, completeness, and timely reporting.
• Prepare reports using Excel functions such as VLOOKUP/XLOOKUP, Pivot Tables, IF formulas, COUNTIFS, SUMIFS, etc.
• Coordinate with different departments to collect required information.
• Identify data discrepancies and follow up for corrections.
• Maintain proper records and databases.
• Support management with ad-hoc reports and data analysis.

Required Skills:

• Excellent knowledge of MS Excel.
• Knowledge of Pivot Tables, VLOOKUP/XLOOKUP, and advanced Excel formulas.
• Good analytical and numerical skills.
• Strong attention to detail and accuracy.
• Good communication and coordination skills.
• Knowledge of Power BI will be an added advantage.