Position
Position Title: MIS Executive & Data Analyst
Location: Mumbai. Impact Guru Head Office (Andheri East)
Reporting Manager: MIS Manager
We hustle Monday - Friday (1st & 3rd Saturday)
Industry: Insuretech
Vertical Summary
Under Impact Guru, Policy Guru/Carepal is an Insurtech startup. Insurance penetration in India is a huge problem. About only 20% of India has some form of health insurance. As an individual, you would have had some exposure to health insurance via policy bazaar, an agent who is generally a relative or your bank. Yet, you haven't bought it today. Why?
This is the problem we are trying to solve by creating innovative products in this space.
Purpose of the role
To get the raw Data, Paste it in applicable spreadsheets. Generating MIS Reporting as per company requirement. To prepare the data in excel and google sheets. Preparing reports and analyze the data as per requirements
Roles & Responsibilities
MIS Executive & Data Analyst.
Making Data of working process sheet of excel.
Prepare corresponding & sending regular reports via email.
Advanced MS Excel Knowledge (Conditional Formatting, V-lookup, H-lookup, IF Function, Count Function, Sum Function, Index Match, Data Validation, Data Sorting)
Working in excel as per data in Filter, Pivot table, & V-lookup.
Preparing Reports and Dashboards for client and central management.
MIS Preparation of Daily/Weekly/Monthly records & data management.
Maintenance & sharing of Daily /Weekly/Monthly report and as company required.
Will be required to support other internet software where logical understanding can be utilized for report preparation.
To get the raw Data, Paste it in applicable spreadsheets.
Generating MIS Reporting as per company requirement.
The technique used for collecting, compiling, and storing information and skills for contributing in the manufacturing of quality products.
Maintain and update records with accuracy.
To keep records and information about deals with clients.