Mis Executive

Tegh Infrastructures; Indore District; On-site; INR 350,000 - 550,000; Full time

Job summary

Tegh Infrastructures in India is seeking a detail-oriented MIS Analyst to transform sales data into actionable reports using advanced Excel and Google Sheets.

You will build dashboards, automate daily/weekly/monthly reports, and collaborate with cross-functional teams to identify process improvements in MIS operations.

Qualifications

• Must be proficient in pivot tables and advanced Excel functions like HLOOKUP and VLOOKUP.
• Ability to prepare daily/weekly/monthly MIS reports on sales performance.
• Experience creating dashboards in Google Sheets.
• Strong math concepts applied to business problems.

Responsibilities

• Utilize pivot tables to analyze large datasets and create insightful reports.
• Develop complex formulas (HLOOKUP, VLOOKUP) to extract relevant data from various sources.
• Prepare daily, weekly, and monthly reports on sales performance using advanced excel skills.
• Create dashboards in Google Sheets for easy visualization of business metrics.
• Collaborate with cross-functional teams to identify areas of improvement in MIS operations.

Skills

Pivot tables

HLOOKUP

VLOOKUP

Advanced Excel

Reporting

Tools

Google Sheets

Excel

Job description

Roles and Responsibilities

• Utilize pivot tables to analyze large datasets and create insightful reports.
  


• Develop complex formulas (HLOOKUP, VLOOKUP) to extract relevant data from various sources.
  


• Prepare daily, weekly, and monthly reports on sales performance using advanced excel skills.
  


• Create dashboards in Google Sheets for easy visualization of business metrics.
  


• Collaborate with cross-functional teams to identify areas of improvement in MIS operations.
  

Desired Candidate Profile

• Advanced knowledge of Microsoft Excel (HLOOKUP, VLOOKUP).
  


• Strong understanding of mathematics concepts applied to business problems.
  


• Proficiency in creating complex reports using pivot tables and other advanced functions.