MIS Executive

Position Overview

The MIS Executive will be tasked with the management, analysis, and reporting of company data to empower informed decision-making. This role demands strong analytical capabilities, proficiency with data management software, and the ability to deliver accurate reports promptly to management.

Key Responsibilities

• Generate and maintain daily, weekly, and monthly MIS reports and dashboards utilizing Google Sheets and Microsoft Excel.
• Develop and oversee shared trackers, dashboards, and reports within Google Workspace tools (Sheets, Docs, Forms, Slides) to support real-time collaboration among departments.
• Create and sustain interactive dashboards in Looker Studio (Google Data Studio) integrating data from Sheets where applicable.
• Leverage advanced Excel features such as VLOOKUP/XLOOKUP, INDEX-MATCH, Pivot Tables, and Conditional Formatting to analyze data.
• Implement automation of routine reporting tasks using Google Apps Script and/or Excel Macros/VBA.

Qualifications and Requirements

• Minimum bachelor's degree in any field, with preference for Commerce, IT, or Business Administration backgrounds.
• Between two to six years of experience in MIS, reporting, or data management roles.
• Expert-level proficiency in Excel functions including Pivot Tables, VLOOKUP/XLOOKUP, IF/Nested IF statements, Conditional Formatting, and Data Validation; knowledge of Macros/VBA is advantageous.
• Strong experience with Google Workspace, particularly Google Sheets formulas, pivot tables, data linking, Google Forms, Google Docs, and managing files/folders in Google Drive.
• Familiarity with Google Apps Script for automating tasks is favorable but not mandatory.
• Mandatory competency in preparing dashboards.

Additional Information

Location: Sukhmani Enclave, Ludhiana, Punjab, India

Salary Range: INR 20,000 to 30,000 per month.

Candidates interested in this urgent opening can send resumes to the email address provided or via WhatsApp messaging.