MIS Executive

Bajaj Life Insurance Limited; Chennai District; On-site; INR 600,000 - 900,000; Full time

Job summary

Bajaj Life Insurance Limited is seeking a data analytics professional in Chennai to support data collection, cleaning, and reporting processes. The role will involve building and maintaining dashboards to monitor KPIs and delivering timely MIS reports for senior management.

The ideal candidate has strong Excel skills, familiarity with Power BI or Tableau, and basic SQL, paired with a keen eye for detail and the ability to clearly communicate findings to non-technical teams.

Qualifications

• Proficient in Excel: Pivot, VLOOKUP/XLOOKUP, macros, Power Query.
• Experience with BI tools to build dashboards and reports.
• Basic SQL knowledge to pull data safely.
• Attention to detail and clear communication with non-technical teams.

Responsibilities

• Data Collection & Cleaning from multiple departments.
• Generate daily, weekly, and monthly MIS reports and scorecards.
• Maintain dashboards to track KPIs using visualization tools.
• Perform data auditing to ensure accuracy across sources.
• Respond to ad-hoc data requests from senior managers.

Skills

Advanced Excel

BI Tools

SQL

Soft skills

Tools

Power BI

Tableau

Job description

Role & responsibilities

Data Collection & Cleaning: Gather raw data from sales, inventory, HR, or finance teams and fix errors.

Report Generation: Build and update daily, weekly, and monthly MIS reports and performance scorecards.

Dashboard Maintenance: Create interactive views using visualization tools to track KPIs.

Data Auditing: Check spreadsheets and databases shared by other departments to ensure accuracy.

Ad-Hoc Analysis: Answer urgent data requests from senior managers.

Required Skills

Advanced Excel: Master Pivot Tables, VLOOKUP/XLOOKUP, macros, and Power Query.

BI Tools: Know how to use Microsoft Power BI or Tableau for dashboards.

Database Basics: Understand SQL to pull data safely.

6Soft Skills: Pay close attention to detail and communicate findings clearly to non-technical teams.