MIS Specialist

Sbicap Securities; Mumbai; On-site; INR 450,000 - 650,000; Full time

Job summary

Sbicap Securities in Mumbai is seeking an experienced Advanced Excel MIS Specialist to prepare MIS reports, dashboards, and presentations. You will automate tasks with macros and design efficient MIS processes.

The role requires 4-9 years BFSI experience, strong data analysis skills, and proficiency with Excel functions like VLOOKUPs, Pivot, INDEX/MATCH. You will collaborate with stakeholders to deliver insights and drive performance.

Qualifications

• 4-9 years of BFSI experience in a similar Advanced Excel MIS role.
• Proficient in complex reports, dashboards, and presentations using Excel.
• Strong knowledge of VLOOKUPs, pivot tables, HLOOKUPs, COUNTIF, SUMIF, INDEX/MATCH.
• Experience on Incentive Calculation projects or similar analytical roles.

Responsibilities

• Prepare MIS reports, dashboards, and presentations using advanced Excel skills.
• Develop macros to automate repetitive tasks and improve efficiency.
• Create complex formulas, functions, and conditional formatting for data analysis.
• Design and implement MIS operations processes to meet business requirements.
• Collaborate with stakeholders to gather requirements and provide insights through visualizations.

Skills

Advanced Excel

MIS Reporting

Dashboard Creation

Macros

VLOOKUPs & Pivot Tables

Data Analysis

Job description

Roles and Responsibilities

• Prepare MIS reports, dashboards, and presentations using advanced Excel skills.
• Develop macros to automate repetitive tasks and improve efficiency.
• Create complex formulas, functions, and conditional formatting for data analysis.
• Design and implement effective MIS operations processes to meet business requirements.
• Collaborate with stakeholders to gather requirements and provide insights through visualizations.

Desired Candidate Profile

• 4-9 years of experience in (BFSI Industry) a similar role as an Advanced Excel MIS Specialist.
• Proficiency in creating complex reports, dashboards, and presentations using Microsoft Office tools (Excel).
• Strong understanding of VLOOKUPs, pivot tables, HLOOKUPs, COUNTIFs, SUMIFs, INDEX/ Match functions.
• Experience working on Incentive Calculation projects or similar roles requiring strong analytical skills.