MIS - Jayanagar (Bangalore)

The Global Zone; Bengaluru; On-site; INR 400,000 - 700,000; Full time

Job summary

The Global Zone in Bengaluru seeks a detail‑oriented MIS Analyst to join our team. You will prepare and maintain daily, weekly, and monthly MIS reports and dashboards, ensuring accuracy across departments.

You will develop Excel‑based reports using formulas, pivot tables, and VLOOKUP/HLOOKUP, with a strong emphasis on data validation and attention to detail. A commerce/IT/CS/math background is preferred.

Qualifications

• Proficient in creating MIS reports and dashboards.
• Strong Excel skills with advanced functions and charting.
• Experience validating data from multiple sources.
• Background in commerce/IT/CS/math preferred.
• Familiarity with databases (SQL/MS Access) is a plus.

Responsibilities

• 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.
• 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.

Skills

Advanced Excel

Pivot Tables

VLOOKUP/HLOOKUP

Dashboards

SQL basics

Data analysis

Education

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

Tools

MS Access

SQL

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.
• 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.