MIS Executive

Job Description:

Job Summary:
We are looking for a detail-oriented and technically proficient MIS Executive to manage and optimize our data management and reporting processes. The ideal candidate should have expertise in Google Sheets, Advanced Excel, and coding to enhance data analysis and automation within the organization.

Key Responsibilities:

• Develop, manage, and maintain MIS reports using Google Sheets, Excel.
• Automate reports, dashboards, and data processes to improve efficiency and accuracy.
• Utilize Advanced Excel functions such as Pivot Tables, VLOOKUP, HLOOKUP, XLOOKUP, Macros, and VBA scripting/Apps Scripting.
• Work with Google Sheets scripts (Google Apps Script) for automation and data processing.
• Extract, clean, and analyse large datasets for business insights and decision-making.
• Coordinate with various departments to gather and consolidate data for accurate reporting.
• Develop custom scripts and applications to enhance data processing and management.
• Troubleshoot and resolve data discrepancies and ensure data integrity.
• Assist in database management.
• Generate periodic and ad-hoc reports as required by management.

Required Skills & Qualifications:

• Bachelor's degree in Computer Science, IT, Statistics, or a related field.
• 3+ years of experience in MIS reporting, data analysis, or a similar role.
• Proficiency in Google Sheets and Advanced Excel (Pivot Tables, Vlookup, Hlookup, Xlookup).
• Hands-on experience with Google Apps Script, Python, or other scripting languages for automation.
• Strong analytical and problem-solving skills.
• Ability to handle large datasets and ensure data accuracy.
• Knowledge of BI tools (Tableau, Power BI) is a plus.