Job Description

Job Title: MIS Executive

Job Summary: The MIS Executive will be responsible for managing and developing various MIS processes and tools to improve business operations. This role entails designing, generating, and maintaining reports and dashboards, automating data collection and processing tasks, and providing data-driven insights to support strategic decision-making. The MIS Executive will work closely with various departments to ensure the integrity, consistency, and accuracy of critical data while helping enhance workflow efficiency.

Key Responsibilities:

• Data Management & Analysis:
• Collect, validate, and analyse data from various sources, including Google Sheets, Looker Studio, and other business tools.
• Generate and present MIS reports, charts, and dashboards to monitor key business metrics, trends, and opportunities.
• Design and maintain scripts for data processing, such as Google Apps Scripts, to streamline data-driven operations.
• System Development & Automation:
• Develop and maintain automated systems for data entry, validation, and retrieval.
• Implement data classification and color-coding rules, conditional formatting, and automation scripts to manage large data sets efficiently.
• Create and manage HTML forms and scripts to capture and process client/project data accurately.
• Client & Project Management:
• Oversee client data systems, including client classification (good, bad, worst) and payment terms based on previous performance.
• Implement OTP-based authentication for data security and client access control.
• Maintain, track, and update client and project data in backend sheets to ensure consistent and accurate reporting.
• Collaboration & Reporting:
• Coordinate with the CRM team for timely updates and reporting on payment collection efforts.
• Collaborate with planners, employees, and service providers to enhance workflow efficiency and project task tracking.
• Prepare and present reports related to task scheduling, overdue days, and priority tasks, with automated scheduling scripts based on specified criteria.
• System & Form Design:
• Design and manage Google Apps Scripts to generate and link Google Docs based on input data from spreadsheets.
• Develop and manage forms for data collection, including dynamic fields for new/existing clients and projects.
• Integrate data capture systems into Looker Studio dashboards for effective monitoring.
• Continuous Improvement:
• Identify opportunities for process improvement through automation, system enhancements, and data analysis.
• Lead or contribute to projects aimed at improving data security, quality, and operational efficiency.

Required Skills & Qualifications:

• Minimum 1 year of experience in JavaScript development.
• Educational background: BE in Electronics & Telecommunications (E&TC)/Information Technology (IT)/Computer Science (CS) or Master of Computer Science (MCS).
• Certification in Data Analytics and SQL is a must.
• Proven experience with Google Sheets, Google Apps Script, and web development (HTML, CSS, JavaScript).
• Strong analytical and problem-solving skills with a focus on data accuracy.
• Proficiency in data visualization tools (Looker Studio) and conditional formatting.
• Excellent communication and collaboration skills.
• Detail-oriented, with a proven ability to handle complex data-driven projects.
• Strong knowledge of business intelligence and MIS practices.

Preferred Qualifications:

• Experience in workflow automation using scripts and APIs.
• Familiarity with CRM tools and customer data management systems.
• Experience in managing OTP-based client authentication systems.

Job Type: Full-time

Pay: ?13,000.00 - ?18,000.00 per month

Schedule:

• Day shift

Education:

• Bachelor's (Preferred)

Experience:

• total work: 1 year (Preferred)

Work Location: In person