Mis Executive

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

*

**Job Types**: Full-time, Regular / Permanent

**Salary**: ₹60,000.00 - ₹300,000.00 per year

**Benefits**:

- Health insurance

Schedule:

- Morning shift

Supplemental pay types:

- Performance bonus

Application Question(s):

- Total Experience as MIS Executive?
- Current CTC?
- Expected CTC?
- Notice Period?
- Are you aware of creating/functions of macros, Tableau, graphs and charts?

**Speak with the employer**

+91-XXXXXXXXXX