Bharti AXA Life Insurance - Manager - MIS - Bancassurance Segment (3-6 yrs)

Company Description:

Bharti AXA Life Insurance is a leading life insurance provider in India, offering value-for-money life insurance and savings solutions. Established in 2006, we are a wholly owned subsidiary of Bharti Life Ventures Private Limited, a prominent business group in India. With over 200 branches across India, we ensure accessibility and convenience for our customers. Recognized as a Great Place to Work for four consecutive years, we foster a positive work environment.

Job Description:

The Excel MIS Manager is responsible for developing, maintaining, and enhancing MIS reports and dashboards using advanced Excel functionalities. This role requires strong analytical skills, proficiency in data management, and the ability to translate data into actionable insights for management. The incumbent will also be responsible for ensuring data accuracy, integrity, and timeliness.

Location- Lower Parel, Mumbai

Designation- MIS Manager (Bancassurance)

Key Responsibilities:

1) Report Development & Maintenance:

- Develop and maintain advanced Excel-based MIS reports and dashboards.

- Dashboard data upload as per visualization tools / dashboards in practise

- Generate periodic and ad-hoc reports as per management requirements.

- Ensure the accuracy, timeliness, and reliability of all reports.

- Automate repetitive tasks using Excel macros and VBA scripting.

2) Data Analysis & Interpretation:

- Collect, analyze, and interpret complex datasets from various sources.

- Identify trends, patterns, and anomalies within the data.

- Develop data visualizations to effectively communicate findings.

3) Data Management & Integrity:

- Maintain databases and ensure data integrity and accuracy.

- Perform data audits and validation to ensure data quality.

- Work with stakeholders to understand data requirements and ensure data consistency.

Qualifications & Experience:

- 7+ years of experience in MIS reporting & data analysis.

- Expert in Excel (Pivot Tables, VLOOKUP, Conditional Formatting, etc.).

- Familiar with VBA scripting & SQL (a plus!).

- Experience with Tableau, Power BI, or other visualization tools.

- Strong understanding of Insurance (LI/GI/Health) or BFSI datasets.

- Understanding of insurance products, risk management principles, customer data 360 view.