MIS Executive

Neuraleap Group; Mumbai; On-site; INR 650,000 - 900,000; Full time

Job summary

Neuraleap Group in Mumbai seeks an MIS Executive to manage business data, generate MIS reports, and build dashboards. You will automate repetitive processes using Advanced Excel, SQL, and Google Apps Script to deliver timely insights to management.

Ideal candidate will analyze large datasets, ensure data quality, and collaborate with multiple departments to tailor reports that track KPIs, sales, operations, and productivity. This role offers growth in a fast-paced, data-driven environment.

Qualifications

• Experience generating MIS reports and dashboards from multiple data sources.
• Strong analytical skills with ability to work with large datasets.
• Proficiency in Advanced Excel, SQL, and Google Apps Script for automation.

Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports and dashboards.
• Collect, consolidate, and analyze data from multiple sources.
• Develop automated reports and dashboards using Advanced Excel, SQL, and Google Sheets.
• Write and optimize SQL queries to extract and analyze data.
• Develop and maintain Google Apps Script solutions to automate reporting processes.

Skills

Advanced Excel

SQL

Google Apps Script

Tools

Google Sheets

Data Visualization

Job description

Job Summary

We are looking for a MIS Executive with strong expertise in Advanced Excel, SQL, and Google Apps Script to manage business data, reporting, dashboards, and automation. The candidate will be responsible for generating accurate MIS reports, analyzing business data, automating repetitive processes, and providing actionable insights to management.

The ideal candidate should have strong analytical skills and the ability to work with large datasets while continuously identifying opportunities for process improvement and automation.

Key Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports and dashboards.
• Collect, consolidate, validate, and analyze data from multiple sources.
• Develop automated reports and dashboards using Advanced Excel, SQL, and Google Sheets.
• Write and optimize SQL queries to extract, filter, join, and analyze data from databases.
• Develop and maintain Google Apps Script solutions for automation of repetitive tasks and reporting processes.
• Automate data collection, report generation, email notifications, data transfers, and other routine activities using Apps Script.
• Create dynamic dashboards and management reports to track KPIs, productivity, sales, operations, and performance metrics.
• Use advanced Excel functions such as XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, Pivot Tables, Power Query, and advanced formulas.
• Identify data discrepancies, perform data validation, and ensure accuracy of MIS reports.
• Maintain structured databases, spreadsheets, trackers, and reporting systems.
• Develop automated workflows between Google Sheets, Forms, Gmail, Drive, and other Google Workspace applications.
• Analyze trends, variances, and performance data and highlight key findings to management.
• Work closely with different departments to understand reporting requirements and deliver customized MIS.
• Improve existing reporting processes through automation and standardization.
• Reduce manual reporting efforts by developing efficient data and reporting solutions.
• Maintain proper documentation of reports, SQL queries, scripts, and automated processes.
• Ensure data confidentiality, accuracy, and timely availability of reports.
• Handle ad-hoc data analysis and reporting requirements from management.

Technical Skills Required

Advanced Excel

• Advanced formulas and functions
• Pivot Tables & Pivot Charts
• XLOOKUP / INDEX-MATCH
• SUMIFS / COUNTIFS
• Conditional formatting
• Data validation
• Power Query
• Data cleaning and consolidation
• Dashboard creation

SQL

• Strong knowledge of SQL queries
• SELECT, WHERE, GROUP BY, ORDER BY
• JOINs
• Subqueries
• CASE statements
• Aggregate functions
• Data filtering and manipulation
• Query optimization and troubleshooting

Google Apps Script

• Good working knowledge of Google Apps Script
• Automation of Google Sheets-based processes
• Automated emails and notifications
• Data movement and synchronization between sheets
• Trigger-based automation
• Integration with Google Forms, Gmail, Drive, and Sheets
• Development and maintenance of automated reporting workflows

Skills: sheets,dashboards,google,apps,sql