Mis Executive

Job Information
- Department Name

Support
- Industry

Insurance
- City

Mumbai
- State/Province

Maharashtra
- Country

India
- Zip/Postal Code

400099

About us

If you are interested in being a part of a dynamic startup working at the intersection of financial services and healthcare which is also making a significant positive social impact to society, then Impact Guru is the right place for you.

**Job Description**:
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.

*

*
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.

*
Analyze the actual sales versus the projected ones for each department.

*
Supporting the field sales team regarding his performance, new product information, upcoming product internal support etc.

*
Utilize graphic design tools and software to develop create custom PowerPoint presentations and templates from pre-generated content

*
Manage the library of PowerPoint creative materials.

*
Built effective database solutions using Microsoft Access based on unique needs.

*
Developed and maintained Microsoft Access database.

*
Create powerful queries to extract large database information from Excel to Access.

Indicative KRA’s

*
Advanced MS Excel Knowledge (Conditional Formatting, V-lookup, H-lookup, IF Function, Count Function, Sum Function, Index Match, Data Validation, Data Sorting)

*
Logical understanding of the data prepared and its requirement.

Professional Experiences

*
Minimum a years of experience as an MIS Executive in data analyses and reporting.

**Qualifications**:
*
Bachelor’s degree/Graduate in any equivalent field.

Functional & Behavioural Competencies

*
Technology development team management

*
Project management

*
Multiple stakeholder management

*
Growth mind-set

*
Aggressive delivery targets-oriented mind-set

*
Entrepreneurial mind-set

*
Ability to deliver in high pace environment

*
Excellent communication

*
Dynamic personality

What do we offer?

*
Attractive salary & performance-linked bonuses

*
Health Insurance benefits

*
An opportunity to be in leadership position of a high-growth start-up

*
Fun, casual & flexible work environment

*
Entrepreneurial, forward looking, growth-driven & open work culture