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 RequiredAdvanced 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
Job Description – MIS Executive Company Name: Winbee Solution Designation: MIS Executive Job Location: JTM Mall, Jagatpura, Jaipur, Rajasthan Salary: As per market standards (Negotiable based on experience) Working Days: Monday to Saturday Working Mode: Work from Office About the Role Winbee Solution is looking for a detail-oriented ...
... native access to Apna's 60M+ workforce, we deliver high-quality training data at unmatched scale and speed. About the Role We are looking for a detail-oriented MIS Executive to manage data reporting, data uploads, camera calibration, and hardware inventory. The ideal candidate should have a good understanding of MIS, strong ...
Job Description: Senior Sales MIS & Commercial Operations Executive Location: Bengaluru, Karnataka (On-site / Hybrid) Compensation: Up to ₹15,00,000 CTC per annum Department: Sales Operations / Revenue Operations / Commercial Excellence Experience: 5-8 years Position Overview We are looking for an experienced and analytical ...
... issues. - Track sales returns, damages, and expiry claims. - Validate debit notes and coordinate claim closure with finance. - Maintain claims ageing and closure MIS. - Ensure accuracy and consistency of data received from MT partners. - Maintain SOPs for MIS reporting and data validation. - Ensure timely circulation of reports ...
Actively hiring MIS Executive (Part Time/WFH) Home Based Job Start Date Starts Immediately CTC (ANNUAL) ₹ 3,00,000 - 5,00,000 ₹ 3,00,000 - 5,00,000 /year Experience No experience required No experience required Apply By 2 Dec' 26 Posted 1 day ago Fresher Job Part time 1000+ applicants About the job As a part-time MIS Executive ...
Actively hiring MIS Executive (Part Time/WFH) Home Based Job Start Date Starts Immediately CTC (ANNUAL) ₹ 3,00,000 - 5,00,000 ₹ 3,00,000 - 5,00,000 /year Experience No experience required No experience required Apply By 9 Dec' 26 Posted today Fresher Job Part time 35 applicants About the job As a part-time MIS Executive ...
... What you'll do - Assist in system implementation and upgrades - Support database management and user queries - Analyze data for decision-making What you need - MIS reporting Job details - Location: Bengaluru - Experience: 1–2 years - Education: Any graduate - Employment type: Full-time - Languages: English [{"name": "full_time", ...
About the Role The Maintenance MIS Executive will be responsible for managing maintenance-related data, reports, and documentation for fleet operations across multiple cities. This role supports preventive and breakdown maintenance by ensuring accurate MIS reporting, job card updates, spare parts tracking, and coordination ...
Entry-level HR role at Bahwan CyberTek in Mumbai. Open to freshers; up to 2 years, with a BBA or B.Com. What you'll do - Prepare, validate, and maintain various MIS reports related to manpower, billing, utilization, and project operations - Coordinate onboarding, deployment, and employee movement activities across departments ...