MIS Executive - Google Sheet Automation

Role overview

MIS reporting and automation

• Maintain and consolidate accurate business data; prepare daily, weekly, monthly, and ad-hoc reports for business, financial, HR, and operational performance.
• Analyze trends and discrepancies; produce management dashboards, performance trackers, and reporting templates.
• Automate reports and trackers with advanced Google Sheets formulas, including QUERY, ARRAYFORMULA, IMPORTRANGE, FILTER, VLOOKUP, XLOOKUP, and Pivot Tables.
• Improve processes, troubleshoot formula and data errors, and document spreadsheet logic and automation workflows.

Assets, SIMs, systems, and accounts

• Maintain asset registers and track equipment allocation, transfers, returns, repairs, replacements, and availability; coordinate onboarding and offboarding asset handovers.
• Reconcile assets and report missing or damaged equipment; coordinate IT support and vendors.
• Coordinate SIM procurement, assignment, transfer, replacement, and deactivation; maintain records and liaise with telecom providers.
• Support CRM and application integrations, monitor synchronization, investigate data errors, and assist with workflow testing and documentation.
• Coordinate employee email account setup, access changes, troubleshooting, and deactivation; maintain account records.

Coordination and documentation

• Work with HR, Finance, Operations, IT, vendors, and service providers to understand requirements and resolve issues.
• Collect, validate, and consolidate departmental data; maintain organized records and handle confidential information responsibly.
• Identify process gaps and recommend practical improvements.

Required qualifications and skills

• Proven experience in MIS reporting, data management, or Google Sheets automation; advanced knowledge of specified formulas and Pivot Tables.
• Experience building automated reports, dashboards, trackers, and data validation systems.
• Strong analytical, numerical, problem-solving, and documentation skills with careful attention to data accuracy.
• Basic understanding of IT asset management, inventory, device allocation, SIM records, business email administration, and user accounts.
• Ability to coordinate, manage multiple tasks, meet deadlines, and work independently.
• Familiarity with CRM systems, integrations, APIs, and workflow automation is an advantage.

Preferred qualifications

• A bachelor's degree or diploma in IT, Computer Science, Business Administration, Data Analytics, or a related field is preferred.
• Google Workspace and business reporting tools experience, Google Apps Script or other automation exposure, CRM integration experience, and experience with HR, Finance, or Operations teams are preferred.

Performance expectations

Workplace

• Work location is in person in Dubai, UAE.