Job Summary Indus Valley Promoters Ltd. is seeking a highly skilled and motivated Google Apps Script Coder and Advanced Excel Expert to join our team. The ideal candidate will possess a strong analytical mindset and a proven ability to manage and analyze data, create insightful reports, and automate processes using Excel and Google Apps Script. This role is crucial in developing and maintaining our Management Information Systems (MIS) dashboards and ensuring efficient data management across the Responsibilities Dashboard Development and Maintenance : Design, develop, and maintain interactive and dynamic MIS dashboards using Excel and Google Sheets to track key performance indicators (KPIs) and provide actionable insights. Ensure data accuracy, consistency, and timeliness in all dashboards. Collaborate with various departments to understand their reporting needs and translate them into effective dashboard Management : Manage and organize large datasets in Excel and Google Sheets, ensuring data integrity and accessibility. Develop and implement data validation and cleaning procedures to maintain data quality. Optimize data storage and retrieval processes for Creation and Automation : Create regular and ad-hoc reports using Excel and Google Sheets, presenting data in a clear and concise manner. Automate report generation and distribution processes using Google Apps Script to improve efficiency and reduce manual effort. Develop and maintain report templates and Apps Script Development : Develop, implement, and maintain custom solutions using Google Apps Script to automate workflows, integrate applications, and enhance productivity. Write clean, efficient, and well-documented code. Troubleshoot and debug Google Apps Script Analysis : Analyze data to identify trends, patterns, and insights that can inform business decisions. Interpret data and provide meaningful recommendations to management. Prepare data visualizations to communicate findings and Skills : Bachelor's degree in a relevant field (e.g., Computer Science, Business, Statistics, or related field). 3 to 4 years of experience in a similar Excel Skills : Proficiency in advanced Excel functions (e.g., VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, OFFSET) . Experience with PivotTables, PivotCharts, and data analysis tools. Ability to create complex formulas and use array functions. Knowledge of data validation, conditional formatting, and other data manipulation Sheets Expertise : Strong working knowledge of Google Sheets functions and features. Ability to create and manage spreadsheets, including complex formulas and data Apps Script Proficiency : Solid experience in developing and implementing solutions using Google Apps Script. Ability to automate tasks, manipulate data, and integrate with other Google Workspace applications. Understanding of JavaScript fundamentals and best Analysis Skills : Strong analytical and problem-solving skills. Ability to interpret data, identify trends, and provide insights. Experience with data visualization tools and techniques. Excellent communication and interpersonal skills. Ability to work independently and as part of a team. Strong attention to detail and a commitment to accuracy. Ability to manage multiple tasks and prioritize effectivel (ref:hirist.tech) Show more Show less