MIS Executive

Job Information
• Department Name

Support
• Industry

Insurance
• City

Mumbai
• State/Province

Maharashtra
• Country

India
• Zip/Postal Code

4000++

About us
ImpactGuru.com, India’s leading healthcare financing platform for patients raises money online for medical expenses via crowdfunding. It aggregates a large number of online payments to allow any individual requiring financial assistance to raise funds for medical expenses - be it cancer, transplant, accident, or any medical emergency. ImpactGuru.com has already helped mobilize Rs 1,500 cr / US$200mm via crowdfunding along with its partners.

ImpactGuru.com was incubated at Harvard Innovation Lab in the USA in 2014. ImpactGuru.com recently announced a $2mm Series A round, led by Apollo Hospitals Group, Currae Healthtech Fund, RB Investments (Singapore based VC Fund), Shorooq Investments (Middle East based VC Fund), Venture Catalysts (India’s #1 angel investor group) with participation from various other investors from the USA, Southeast Asia, and the Middle East.

ImpactGuru.com was recently awarded Best Technology Solution for Social Good by Economic Times Intelligent Health & Tech Awards, selected among the top 5 early-stage startups in India by TiE, fe atured multiple times on CNBC Young Turks. ImpactGuru.com was ranked among the top 21 Startups Globally to Watch in the space in which it operates by CB Insights. ImpactGuru’s senior management is led by Harvard, Wharton, Parsons, IIT, and IIM alumni with the founders recently being profiled in Fortune 40 under 40.

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