Job Description

The

MIS Executive

will play a key role in managing and maintaining business data, ensuring data accuracy, creating custom reports, and enhancing decision-making processes within the organization. The role will involve leveraging advanced Excel, Google Sheets, and scripting languages to automate reports and data workflows, ensuring timely and actionable insights for various teams.

Key Responsibilities:

Data Management & Reporting

: Collect, organize, and manage data from different departments (Sales, Operations, Finance, etc.). Prepare and generate periodic reports (daily, weekly, monthly) using

Advanced Excel

and

Google Sheets

. Develop automated report templates and dashboards for improved decision-making and performance tracking.

Scripting & Automation

: Utilize

JavaScript

and

Google Apps Script

to automate repetitive tasks and workflows within Google Sheets and other Google Workspace tools. Write custom scripts to enhance the functionality of MIS reports and dashboards. Develop automation for data extraction, transformation, and loading (ETL processes) to reduce manual intervention.

Dashboard and Data Visualization

: Create and maintain dashboards in

Google Sheets

to visualize key metrics and KPIs. Implement advanced Excel features (pivot tables, macros, charts, etc.) to enhance the reporting process and make data more actionable. Integrate data from multiple sources into cohesive visualizations.

Data Analysis & Insights

: Analyze data trends and patterns to provide actionable insights to management. Generate ad-hoc reports and perform in-depth data analysis for business optimization and performance improvement. Support cross-functional teams by providing accurate and timely reports for decision-making.

System Maintenance & Support

: Ensure the accuracy and integrity of data across all MIS systems. Troubleshoot any issues with the reporting tools, scripts, and dashboards. Collaborate with IT teams to ensure seamless functioning of data systems and reporting platforms.

Collaboration & Training

: Work closely with business teams (Sales, Finance, HR, etc.) to understand data needs and provide tailored reports. Provide training and support to team members on using MIS systems and automated reporting tools. Suggest improvements in reporting processes and workflows to enhance data accuracy and accessibility.

Required Qualifications & Skills:

Education

: Bachelor's degree in Information Technology, Computer Science, Business Administration, or related field.

Experience

: Minimum of 2 years of experience in an

MIS Executive

or

Data Analyst

role.

Technical Skills

: Advanced proficiency in

Microsoft Excel

(pivot tables, VLOOKUP, macros, advanced formulas). Expertise in

Google Sheets

, including functions, data analysis tools, and scripting. Strong experience with

JavaScript

or

Google Apps Script

for automation and custom reporting. Familiarity with databases and data management tools. Experience with data visualization tools or software (e.g., Google Data Studio, Tableau) is a plus.
Job Type: Full-time

Pay: ₹20,000.00 - ₹30,000.00 per month

Work Location: In person