MIS Executive

Master of Advanced Microsoft excel and google sheets ● In-depth knowledge of advance functions like - Pivot table, Array, Query, Vlookup, Hlookup, Mailmerge, import range other advance functions in Excel and Google sheets ● Knowledge of scripting in Google Sheets and Excel to make sheets with Email automation, WhatsApp automation, data filtering etc. ● Advance knowledge of Google Forms, JOT forms ● Make Flow chart monitoring sheets (FMS) and Project Monitoring sheets (PMS) on Google sheets ● Prepare various MIS Dashboards for the Doers and Management to check actual reports ● Responsible to generate, maintain, consolidate and track various Daily/Weekly/Monthly MIS reports ● Proactively interact with multiple internal/external stakeholders on a daily, weekly and monthly basis for the preparation of MIS reports ● Analyze data and reports from various sources and provide actionable insights and suggestions Prepare Ad hoc reports based on the requirements from the stakeholders ● Identify the op opportunities of automating the reports, snapshots and dashboards using advanced formulae, and other techniques ● Make an Intranet of the organization. ● Ensure on-time and accurate delivery of reports, analysis and service requests ● Continually monitor trends, performance & assist managers in making process improvements ● Ensure individual & process-wise performance data is captured, provide operational metrics to management as required Knowledge, Skills, and Abilities: ● Experience of a minimum of 2 years ● Working expertise in Advanced Excel (Array, query, import range, and Statistical formulas), Google sheets, Google forms ● Knowledge of Scripting in Excel and Google sheets (Email automation, WhatsApp automation, data filtering etc.) ● MIS Dashboard generation ● Knowledge of a variety of data analysis techniques, including clustering, factor analysis, and logistic regression; data/text mining, decision trees, is a plus ● Detailed oriented and meticulous - this is a key requirement ● Ability to prepare, analyse and synthesize data in an actionable and decision critical format ● Knowledge of Java Script & App Script. Others • 6 days a Week (Monday to Saturday) • Majorly Desk job