Pallav Technologies logo

MIS Analyst (SQL + Excel) — Collections Operations | Gurgaon | 2–3 openings

Pallav Technologies

1 - 5 years

Gurugram

Posted:16 hours ago

Apply

Job Description

Fintech Forge is a fast-growing collections and lending company in Gurgaon, working with 50+ banks and NBFCs across India. We’re hiring MIS Analysts to run the reporting backbone of collections operation.


What you’ll do

  • Build and maintain daily/weekly MIS: allocation, DPD-bucket performance, PTP vs. collected, agent and TL productivity, client dashboards
  • Pull and transform data from our databases using SQL; automate recurring reports
  • Build pivot-based and formula-driven trackers in Excel/Google Sheets; keep them accurate and on time
  • Reconcile client payment files against internal records and flag mismatches
  • Support ops and client teams with ad-hoc data cuts and quick analysis

What we’re looking for

  • 1–5 years in MIS/reporting (BPO, collections, or fintech experience is a plus)
  • Strong SQL: joins, aggregations, subqueries, basic window functions
  • Strong Excel: XLOOKUP/VLOOKUP, SUMIFS/COUNTIFS, pivot tables, data cleaning; Power Query is a bonus
  • Attention to detail and comfort with tight daily deadlines



Good to have:

Details:

Apply with your resume and a short note on the most complex report you’ve built.

Skills Required

MIS SQL Excel Google Sheets MIS Reporting BPO Power Query Attention to Detail Python Power BI MIS reporting and dashboards Customer service

Learn the skills this job asks for

See your skill gap for Data Analyst →

Free courses, interview questions and practice for each skill.

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now
Pallav Technologies logo
Pallav Technologies

RecommendedJobs for You