Walk-in | Mis Executive

TLC DigiTech; Delhi; On-site; INR 600,000 - 1,200,000; Full time

Job summary

TLC DigiTech in Delhi is seeking a data-focused MIS analyst to collect, consolidate, and validate data from multiple sources, and to prepare timely MIS reports and management presentations.

You will develop dashboards and trackers, analyze trends, ensure data accuracy, and automate recurring reports, leveraging Excel, Power Query, and Power BI where possible.

Qualifications

• Advanced MS Excel proficiency with reporting experience.

Responsibilities

• Collect, consolidate, validate, and maintain data from multiple sources.
• Prepare daily, weekly, and monthly MIS reports as per business requirements.
• Develop and maintain dashboards, trackers, and performance reports.
• Analyze data to identify trends, gaps, variances, and performance indicators.
• Ensure accuracy and integrity of data before sharing reports with stakeholders.
• Maintain databases, spreadsheets, and MIS records in an organized manner.
• Generate operational, sales, productivity, attendance, and performance reports as required.
• Prepare management reports and presentations for review meetings.
• Coordinate with different departments to collect required data and resolve discrepancies.
• Track KPIs and prepare performance summaries.
• Automate recurring reports and improve reporting processes wherever possible.
• Use advanced Excel functions and tools to improve reporting efficiency.
• Maintain proper documentation of reports, data sources, and reporting processes.
• Handle ad-hoc reporting and data analysis requirements from management.
• Ensure timely submission of all assigned reports.

Skills

MS Excel

Pivot Tables

VLOOKUP/XLOOKUP

INDEX-MATCH

SUMIFS/COUNTIFS

IF Functions

Charts & Formatting

Power Query

Power BI

Analytical Skills

Attention to Detail

Communication Skills

Data Handling

Time Management

Tools

Power Query

Power BI

Job description

Key Responsibilities

• Collect, consolidate, validate, and maintain data from multiple sources.
• Prepare daily, weekly, and monthly MIS reports as per business requirements.
• Develop and maintain dashboards, trackers, and performance reports.
• Analyze data to identify trends, gaps, variances, and performance indicators.
• Ensure accuracy and integrity of data before sharing reports with stakeholders.
• Maintain databases, spreadsheets, and MIS records in an organized manner.
• Generate operational, sales, productivity, attendance, and performance reports as required.
• Prepare management reports and presentations for review meetings.
• Coordinate with different departments to collect required data and resolve discrepancies.
• Track KPIs and prepare performance summaries.
• Automate recurring reports and improve reporting processes wherever possible.
• Use advanced Excel functions and tools to improve reporting efficiency.
• Maintain proper documentation of reports, data sources, and reporting processes.
• Handle ad-hoc reporting and data analysis requirements from management.
• Ensure timely submission of all assigned reports.

Required Skills

• Advanced knowledge of MS Excel.
• Strong knowledge of Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF functions, charts, and conditional formatting.
• Knowledge of Power Query and data automation is preferred.
• Knowledge of Power BI is an advantage.
• Good analytical and problem-solving skills.
• Strong attention to detail and accuracy.
• Good communication and coordination skills.
• Ability to work with large volumes of data.
• Good time-management and multitasking abilities.