MIS Executive

T&N Business Services; Gurugram District; On-site; INR 300,000 - 420,000; Full time

Job summary

T&N Business Services is seeking an MIS Executive to manage Excel-based reporting, dashboards and data workflows from Gurgaon, India. 1-13 years experience with strong Excel, Google Sheets and data visualization skills is preferred.

The role focuses on generating timely reports, maintaining data quality, and coordinating with CRM and finance teams while ensuring adherence to SLAs and process standards.

Qualifications

• Expert in Excel, Google Spreadsheets and data dashboards.
• Must be able to write good emails and have good listening skills.
• Must be able to write SOPs whenever required.
• Good communication skills must.
• Good Analytical/ Reasoning/Logical Ability
• Must be proficient in computer applications and shall possess skills to represent data in multiple graphical forms
• Managing multiple tasks at the same time proficiently
• Must know how to create and manage Google forms, Response validation and collection.

Responsibilities

• Manage daily, weekly and monthly sales reports and data.
• Manage monthly attendance of onroll and off role staff, preparing payroll trix in google sheets/excel and prepare management reports.
• Identify inaccuracy in reports, dashboards and how to prevent them.
• Prepare monthly, quarterly and yearly performance reports of staff and share with managers.
• Identify any loopholes in the current process and provide suggestions on how to improvise it.
• Manage data repositories and update those daily, weekly and monthly.
• Manage internal sales CRM tools and identify and report any issues to the management.
• Manage external agencies for hiring/joining HC requirements.
• Manage internal finance team requirements for external agencies.
• Manage and close the monthly payroll every month within the SLA.
• Manage own SOPs and projects defined existing SOPs and update them regularly.
• Build good relationships with external agencies to smooth the payroll process.
• Readiness to stretch when required specifically the first week of every month.
• Ability to make things within the TAT and SLA.
• Should be able to work under pressure and be able to manage the team.
• Conduct data and metrics analysis, understand patterns and derive KPIs/KRAs.
• Audits all MI prepared by the Executives.
• Structure data and Manage database for Ad Hoc reports.

Skills

Advanced Excel

Google Spreadsheet

Google Data Studio

VLOOKUP

Countifs

SUMIFS

Importrange

Job description

Job Summary

MIS Executive | Location: Haryana, India | Designation: MIS Executive | Experience: 1-13 Yrs | Job Type: Full Time | Skills: Candidate should have ework experience in Advanced Excel, Google Spreadsheet, Basic SQL

Job Description

We are looking for MIS Executive for Gurgaon. Experience required: 1-2 years. Locations: Gurgaon.

Job Responsibilities

• Manage daily, weekly and monthly sales reports and data.
• Manage monthly attendance of onroll and off role staff, preparing payroll trix in google sheets/excel and prepare management reports.
• Identify inaccuracy in reports, dashboards and how to prevent them.
• Prepare monthly, quarterly and yearly performance reports of staff and share with managers.
• Identify any loopholes in the current process and provide suggestions on how to improvise it.
• Manage data repositories and update those daily, weekly and monthly.
• Manage internal sales CRM tools and identify and report any issues to the management.
• Manage external agencies for hiring/joining HC requirements.
• Manage internal finance team requirements for external agencies.
• Manage and close the monthly payroll every month within the SLA.
• Manage own SOPs and projects defined existing SOPs and update them regularly.
• Build good relationships with external agencies to smooth the payroll process.
• Readiness to stretch when required specifically the first week of every month.
• Ability to make things within the TAT and SLA.
• Should be able to work under pressure and be able to manage the team.
• Conduct data and metrics analysis, understand patterns and derive KPIs/KRAs.
• Audits all MI prepared by the Executives.
• Structure data and Manage database for Ad Hoc reports.

Requirements

• Expert in Excel, Google Spreadsheets and Google Data Studio dashboards. Functions like Countifs, Sumifs, Vlookups, Importrange, Query functions, Pivot tables, Unique, Conditional formatting, Data validation techniques, Concatenation, etc.
• Must be able to write good emails and have good listening skills.
• Must be able to write SOPs whenever required.
• Good communication skills must.
• Good Analytical/ Reasoning/Logical Ability
• Must be proficient in computer applications and shall possess skills to represent data in multiple graphical forms
• Managing multiple tasks at the same time proficiently
• Must know how to create and manage Google forms, Response validation and collection.
• Design and under construction projects planning, progress tracking, documentation records, MIS, generating reports for all projects - progress, inputs, delays, costs incurred, invoices generated, payments received, made, queries received.

Skills

• Advanced Excel
• Google Spreadsheet
• Google Data Studio
• VLOOKUP
• Countifs
• SUMIFS
• Importrange