Data Analyst

Job Description – MIS & Automation Executive Position MIS & Automation Executive Department MIS / Data Analytics / Business Process Automation Job Type Full-Time Job Overview We are looking for a highly skilled MIS & Automation Executive with strong expertise in Advanced Excel, Google Sheets, Google Apps Script, JavaScript, HTML, CSS, Google API Integration, and Looker Studio. The candidate should be capable of developing automated MIS systems, dashboards, web-based forms, reporting solutions, and business process automation tools. This is not a routine MIS reporting role. The candidate will be expected to understand business requirements, develop solutions independently, automate manual processes, and build practical reporting systems. Key Responsibilities  Develop and maintain daily, weekly, and monthly MIS reports.  Build automated reporting systems using Google Sheets and Google Apps Script.  Develop web-based forms, data-entry systems, and internal business tools.  Automate repetitive business processes and reporting activities.  Develop interactive dashboards using Looker Studio.  Integrate Google Sheets with other Google Workspace applications and external systems.  Develop solutions using Google APIs and third-party APIs.  Perform data cleaning, validation, reconciliation, and analysis.  Develop KPI, sales, inventory, operations, and management reports.  Convert business requirements into practical automated solutions.  Identify manual processes and implement automation wherever possible.  Troubleshoot and improve existing MIS systems and automation scripts.  Work with different departments to understand their reporting and operational requirements.  Provide management with accurate and timely reports and dashboards. Mandatory Technical Skills The following skills are COMPULSORY: 1. Advanced Excel  Advanced formulas  XLOOKUP / INDEX-MATCH  SUMIFS / COUNTIFS  FILTER / UNIQUE  Pivot Tables & Charts  Conditional Formatting  Data Validation  Power Query  Dynamic & Array Formulas 2. Google Sheets  Advanced Google Sheets formulas  QUERY  IMPORTRANGE  ARRAYFORMULA  FILTER / UNIQUE  Complex data manipulation  Automated reporting structures 3. Google Apps Script  Strong hands-on experience with Google Apps Script  Automation of Google Sheets and Google Workspace  Custom functions  Triggers  Automated emails and notifications  Automated report generation  Data processing and transformation  Web Apps using Apps Script  Form and workflow automation 4. JavaScript  Strong understanding of JavaScript  DOM manipulation  Functions, arrays, objects, loops, conditions  Asynchronous operations  API handling  JSON  Event handling  Writing clean and reusable JavaScript code 5. HTML & CSS – Full Stack Web Development Mandatory Candidate must have practical knowledge of:  HTML5  CSS3  Responsive web design  Forms and input handling  JavaScript integration  Front-end development  Web-based business applications  Google Apps Script Web Apps  Client-side and server-side interaction 6. Google API Integration – COMPULSORY Candidate must have practical knowledge of integrating Google APIs and external APIs with business applications. Expected knowledge includes:  Google Sheets API  Google Drive API  Gmail API  Google Calendar API  Google Forms / Workspace integration  REST APIs  JSON  Authentication and API requests  Fetching and sending data through APIs Looker Studio – Required Skills Candidate should be able to: 1. Create interactive management dashboards. 2. Connect Google Sheets and other data sources. 3. Create calculated fields and KPIs. 4. Apply filters, controls, charts, and interactive components. 5. Design professional dashboards for management reporting. Preferred Skills  Experience developing complete MIS automation systems.  Experience creating web-based internal business applications.  Knowledge of ERP/CRM data structures.  Experience with inventory, sales, operations, HR, or finance MIS.  Understanding of business process automation.  Experience working with APIs and third-party integrations.  Strong logical and problem-solving skills. Experience 2–5 years of relevant experience in MIS, Automation, Data Analytics, Business Reporting, or Business Process Automation. Candidates with strong practical project experience may also be considered. Educational Qualification Bachelor's degree in B.Com, BBA, BCA, Computer Applications, Data Analytics, or a related field. Candidate Profile We are looking for someone who:  Is technically strong and not limited to routine Excel reporting.  Can independently develop MIS systems and automation solutions.  Can convert business requirements into functional applications.  Has strong logical and analytical thinking.  Enjoys automation and process improvement.  Can work independently with minimum supervision.  Can troubleshoot and improve existing systems.  Understands both business requirements and technical implementation. Important – Pre-Interview Skill Requirement Candidates applying for this position should have practical working knowledge of the following before appearing for the interview: Advanced Excel + Google Sheets + Google Apps Script + JavaScript + HTML + CSS + Google API Integration + Looker Studio The interview will include practical/technical assessment based on these skills. Candidates with only basic Excel/MIS reporting experience and without hands-on experience in Apps Script, JavaScript, HTML/CSS, and API Integration may not be suitable for this position. Performance Expectations The selected candidate will be expected to work towards: Data → Automation → Web Application → Dashboard → Management Reporting with the objective of reducing manual work, improving data accuracy, and creating scalable business reporting solutions.