Deputy Manager - Business Intelligence and Insights Group

Axis Max Life Insurance Limited; Gurugram District; Remote; INR 1,200,000 - 2,000,000; Full time

Job summary

Axis Max Life Insurance Limited is seeking a Deputy Manager for the BIIG team to drive reporting automation and analytics. The role focuses on building end-to-end automated pipelines using Python, Power BI, SQL, and VBA to deliver timely, accurate insights for business decisions.

You will design ETL processes, develop data models, and create real-time dashboards that integrate with multiple data sources. Strong scripting, data quality, and stakeholder collaboration are essential.

Qualifications

• 3-4 years of hands-on experience in Python programming and BI automation.
• Strong analytics and ability to analyze large datasets.
• Knowledge of Python, advanced Excel, and Power Automate.
• Familiarity with macros, VB/SQL; Power BI or other visualization tools a plus.

Responsibilities

• Develop and maintain end-to-end automated reporting pipelines using Python, Power BI and SQL.
• Design automated scripts for report generation, ensuring data integrity and timeliness.
• Build data models, perform cleansing, and write complex queries for insights.
• Create interactive dashboards in Power BI and optimize Excel/VBA automation.

Skills

Python

Power BI

SQL

VBA

Excel

Macros

Education

Bachelor's or Master's in Computer Science / Data Science / Engineering

Tools

Power BI

Excel

SQL

Python

VBA

Job description

Deputy Manager - Business Intelligence and Insights Group

Home Office

|

Share Job

About Axis Max Life

Axis Max Life Insurance Limited, formerly known as Max Life Insurance Company Ltd., is a joint venture between Max Financial Services Limited (“MFSL”) and Axis Bank Limited.

Axis Max Life Insurance offers comprehensive protection and long-term savings life insurance solutions through its multi-channel distribution, including agency and third-party distribution partners. It has built its operations over two decades through a need-based sales process, a customer-centric approach to engagement and service delivery, and a well-trained human capital.

Axis Max Life has been consistently ranked among the best workplaces by the GPTW Institute, reflecting its commitment to creating a positive and empowering work environment.

#ComeAsYouAre LGBTQIA+ and PwD candidates of all ages are encouraged to apply

Job Description

Job Code: DM-MIS

Position Deputy Manager – BIIG

No. of Positions

1

Department BIIG Function BIIG

Reporting to Chief Manager – BIIG Band 5B

Location

90 C Gurgaon Last date of submission

Job Summary:

• Role: Reporting/Dashboard Automation Specialist in the Non-Distribution Patch of BIIG
• Primary Focus: Leveraging technical tools like Python, Power BI, SQL, VBA, and automation techniques to drive reporting and analytics efficiency.

Key Responsibilities:

Technical Responsibilities:

• Develop and maintain end-to-end automated reporting pipelines using Python (pandas, numpy, etc.), Power BI, and SQL.
• Design and implement automated scripts for report generation, ensuring data integrity, timeliness, and accuracy.
• Design complex ETL (Extract, Transform, Load) processes to integrate data from multiple sources, optimizing performance and reducing manual intervention.
• Build data models, perform data cleansing, and develop complex queries to provide accurate and meaningful insights.

Advanced Analytics:

• Apply statistical analysis, machine learning models, or advanced Python libraries (e.g., SciPy, scikit-learn) to identify patterns, anomalies, and insights from large datasets.
• Implement predictive models and trend analysis to assist in business forecasting and decision-making.

Dashboard Development & Visualization:

• Create interactive, real-time dashboards in Power BI, integrating with backend databases and automating data flows for dynamic reporting.
• Use DAX, Power Query, and other Power BI features to create complex metrics and KPIs.
• Develop and optimize VBA scripts and macros to automate repetitive tasks in Excel and other reporting tools.
• Integrate these solutions with other systems, enabling seamless data transfers and report generation.
• Write and optimize complex SQL queries, stored procedures, and triggers to extract data, perform calculations, and automate reporting tasks.
• Ensure data quality and consistency through rigorous database management practices.

Performance Optimization:

• Optimize Python and SQL code for performance, ensuring scalability and handling large datasets efficiently.
• Conduct troubleshooting and performance tuning of automation scripts to minimize processing time and improve reliability.

Functional Responsibilities:

• Publish automated Management Information Systems (MIS) reports and dashboards to monitor key business performance metrics.
• Work closely with business stakeholders to understand reporting needs and ensure timely delivery of actionable insights.

Trend Analysis & Decision Support:

• Provide actionable insights from data analysis, including trend identification, and suggest corrective actions for operational improvements.
• Support management in decision-making by providing high-level analytical reports and visualizations.

Process Improvement & Automation Strategy:

• Identify opportunities to streamline manual reporting processes and automate routine tasks across functions.
• Collaborate with cross-functional teams to refine reporting requirements and improve data-driven decision-making.

Collaboration & Cross-Functional Support:

• Build relationships with business teams to understand data needs and deliver customized reporting solutions.
• Provide technical expertise in data management and analysis to various functions across the organization.

Measures of Success:

• Automation Efficiency: Successful implementation of automated pipelines with minimal manual intervention.
• Data Integrity: Accuracy and quality of reports generated, ensuring consistency with source data.
• Dashboard Adoption: Frequency and user engagement with automated dashboards and reports.
• Process Optimization: Reduction in time taken to generate reports and improved process efficiency.
• Collaboration & Stakeholder Satisfaction: Positive feedback from stakeholders on data quality, visualization, and actionable insights.

DESIRED QUALIFICATIONS AND EXPERIENCE:

• 3 - 4 years of relevant experience in Python programming.
• Good analytical skills with ability to Collate and Analyze Large Amount of Data
• Understanding of Python / Advance Excel / Power Automate.
• Knowledge of Macros, VB/SQL, Python is required (Power BI or any visualization tool would be added advantage)

Desired Qualifications & Experience:

• Experience
  • 3-4 years of hands‑on experience in Python programming, SQL, and Power BI for report automation, data analysis, and business intelligence.
  • Strong background in data modeling, database management, and building complex automation workflows.
• Technical Skills
  • Programming: Python (pandas, numpy, matplotlib, etc.), VBA, SQL (complex queries, stored procedures, etc.)
  • BI Tools: Power BI (DAX, Power Query, visualizations), Advanced Excel, Power Automate.
  • Experience with automating reports and workflows using Python, VBA, and SQL‑based solutions.
  • Strong expertise in ETL processes, data cleansing, and integration with various data sources (databases, APIs, etc.).
• Education
  • Bachelor's or master’s degree in computer science, Data Science, Engineering, or a related field.
• Strong analytical and problem‑solving skills.
• Excellent communication skills to translate complex technical concepts to business stakeholders.
• Ability to work in fast‑paced environments and manage multiple technical projects simultaneously.

State

Home Office

Branch

Gurugram -90C

Department

Business Intelligence and Insights Group