MIS - Gurgaon - MALE - Package 40K Upto

The Global Zone; Gurugram District; On-site; INR 450,000 - 650,000; Full time

Job summary

The Global Zone is seeking a detail-oriented Data/MIS Analyst to consolidate daily, weekly, and monthly reports. You will build and maintain Excel-based dashboards, validate data across departments, and support management with trend analysis.

Responsibilities include automating recurring reports, coordinating with cross-functional teams, ensuring data security, and delivering error-free presentations to senior leadership.

Qualifications

• Advanced Excel is a must.
• Strong knowledge of MS Excel and Google Sheets.
• Hands-on with Pivot Tables, VLOOKUP/HLOOKUP, and formula-based reporting.
• Math background or numerical aptitude is a plus.
• Bachelors degree in commerce, IT, CS, or Math.
• SQL/MS Access understanding is advantageous.
• Strong analytical and problem-solving skills with attention to detail.
• Good written and verbal communication.
• Ability to manage multiple reports and meet deadlines.

Responsibilities

• Prepare, maintain, and update daily, weekly, and monthly MIS reports and dashboards.
• Collect, compile, and validate data from various departments for accuracy and consistency.
• Develop and maintain Excel-based reports using formulas, pivot tables, VLOOKUP/HLOOKUP, and charts.
• Support management with data analysis, trend identification, and performance tracking.
• Maintain and update databases, ensuring data security and confidentiality.
• Automate recurring reports and processes to improve efficiency and turnaround time.
• Coordinate with cross-functional teams to gather requirements and resolve data discrepancies.
• Ensure timely and error-free submission of reports to stakeholders and senior management.
• Assist in preparing presentations and MIS documentation as required.

Skills

Advanced Excel

Pivot Tables

VLOOKUP/HLOOKUP

Mathematical aptitude

Data analysis

Communication skills

Deadline management

Education

Bachelor's degree in commerce/IT/CS/Math

Tools

SQL

MS Access

Google Sheets

Job description

• Prepare, maintain, and update daily, weekly, and monthly MIS reports and dashboards.
• Collect, compile, and validate data from various departments to ensure accuracy and consistency.
• Develop and maintain Excel-based reports using formulas, pivot tables, VLOOKUP/HLOOKUP, and charts.
• Support management with data analysis, trend identification, and performance tracking.
• Maintain and update databases, ensuring data security and confidentiality.
• Automate recurring reports and processes to improve efficiency and turnaround time.
• Coordinate with cross-functional teams to gather requirements and resolve data discrepancies.
• Ensure timely and error-free submission of reports to stakeholders and senior management.
• Assist in preparing presentations and MIS documentation as required.

REQUIRED SKILLS & QUALIFICATIONS

• Good working knowledge of Advanced Excel is a must.
• Thorough knowledge of MS Excel and/or Google Sheets.
• Hands-on experience with Pivot Tables, VLOOKUP/HLOOKUP, and formula-based reporting.
• A background in Mathematics or a strong numerical aptitude will be an added advantage.
• Bachelors degree in commerce, IT, Computer Science, Mathematics, or a related field.
• Basic understanding of databases (SQL/MS Access) is an added advantage.
• Strong analytical and problem-solving skills with high attention to detail.
• Good communication skills, both written and verbal.
• Ability to manage multiple reports and meet strict deadlines.