Role: MIS and Reporting Analyst

Location: Gurgaon
Experience: 3–5 Years
Band: BPO 3
Salary: Up to 9 LPA
Work Mode: 100% Work From Office
Shift: Night Shift (Mandatory)

Job Summary

We are looking for a highly analytical MIS and Reporting Analyst to support collections and reporting operations. The ideal candidate should have strong expertise in Excel, VBA, data analysis, reporting, and database management, with the ability to generate actionable insights and drive process improvements.

Key Responsibilities

• Monitor and manage collections data from multiple sources.

• Ensure accuracy, completeness, and integrity of data within collection management systems.

• Develop, maintain, and optimize databases and reporting dashboards.

• Generate daily, weekly, monthly, and ad-hoc reports related to collection performance, outstanding receivables, and aging accounts.

• Analyze collection trends and identify opportunities to improve collection efficiency.

• Present key findings, metrics, and insights to management stakeholders.

• Evaluate existing collection processes and recommend improvements.

• Support implementation of new reporting tools, automation initiatives, and process enhancements.

• Collaborate with IT and Finance teams to integrate and automate collections systems.

• Assist in developing collection strategies and operational policies.

• Ensure compliance with company policies and applicable regulations.

• Maintain accurate documentation for audits and regulatory reviews.

Required Skills

• Strong proficiency in MS Excel, including Advanced Excel functions.

• Expertise in VBA (Visual Basic for Applications) and Macro Development.

• Experience with Financial Modeling and Data Analysis.

• Good knowledge of Database Management Systems (DBMS).

• Strong analytical and problem-solving skills.

• Ability to interpret complex datasets and provide actionable business insights.

• Excellent reporting and presentation skills.

Preferred Skills

• Understanding of Order-to-Cash (OTC) Lifecycle.

• Exposure to B2B Collections processes.

• Experience with reporting automation and dashboard development.

Eligibility

• Experience: 3–5 Years

• Comfortable working in permanent night shifts.

• Willing to work from the Gurgaon office on all working days.

Important Notes

• Ex-TCS employees are not eligible to apply.

• PAN Card and Date of Birth (DOB) are mandatory for profile creation.

Mandatory Questionnaire

Please complete the questionnaire before applying:

Questionnaire Link: https://myglit.com/lateral/cref/a7d0a34739

Note: Filling out the questionnaire is mandatory. Applications without a completed questionnaire will not be considered for further processing.