MIS Executive

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