Data Management Executive/ MIS Executive

Summary

Work Details

• 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.
• dvance 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 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.
  

• 6 days a Week (Monday to Saturday)
• Majorly Desk job