Mis Executive

Krazy Bee Services; Bengaluru; On-site; INR 450,000 - 650,000; Full time

Job summary

Krazy Bee Services is seeking an MIS Executive to manage, analyze, and optimize data for its two-wheeler lending/subscription portfolio. You will track sales pipelines, dealer networks, credit approvals, and collection metrics to drive strategic decision-making.

Responsibilities include data management, reporting, dashboard maintenance, and cross-functional support. The ideal candidate has 2–4 years in MIS in Fintech/NBFC or retail auto-finance, with strong SQL and BI tool experience.

Qualifications

• Proficiency in VLOOKUP, HLOOKUP, Pivot Tables, Macros and Power Query.
• SQL proficiency; experience with Power BI or Tableau is a plus.

Responsibilities

• Manage, analyze, and optimize business data for lending/subscription portfolio.
• Track sales pipelines, dealer networks, credit approvals, and collection metrics.
• Generate dashboards and automate recurring reports to reduce errors and TAT.
• Reconcile loan data between LMS and bank partners.

Skills

VLOOKUP

HLOOKUP

Pivot Tables

Macros

Power Query

SQL

Power BI

Tableau

Job description

Role & responsibilities

We are looking for a data-driven MIS Executive to manage, analyze, and optimize business data for our Two-Wheeler lending/subscription portfolio. You will track sales pipelines, dealer networks, credit approvals, and collection metrics to drive strategic decision-making.

Data Management & Reporting - Maintain daily, weekly, and monthly business performance dashboards.Track loan originations, login-to-disbursement ratios, and rejection rates.Monitor dealer-wise performance, payouts, and subvention schemes.

Portfolio & Collection - Tracking Generate reports on portfolio health (Bounce rates, NPA, and DPD buckets).Analyze collection efficiency across different regions and customer segments.Track vehicle repossession and asset management metrics.

Cross-Functional Support - Provide actionable insights to Sales, Credit, Risk, and Operations teams.Automate recurring reports to minimize manual errors and turn-around time (TAT).Reconcile loan data between the internal Loan Management System (LMS) and bank partners.

Preferred candidate profile

Required Skills & Qualifications: VLOOKUP, HLOOKUP, Pivot Tables, Macros, and Power Query.Database & BI: Proficiency in SQL is highly preferred; experience with Power BI or Tableau is a plus.

Experience: 2-4 years of experience as an MIS Executive, ideally in a Fintech, NBFC, or retail auto-finance company.