HR Analyst

Key Responsibilities

• Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
• Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
• Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
• Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
• Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
• Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
• Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
• Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
• Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.

Required Skills & Qualifications

• Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.

• Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
• Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
• Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
• Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
• Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.

Position : Executive / Sr. Executive / Assistant Manager – MIS & Reconciliation

Industry : Fintech

Job Location : Gurgaon

Experience :

• Executive / Sr. Executive : 3–6 Years
• Assistant Manager : 5–8 Years

Role Overview :

We are looking for a detail-oriented and analytical MIS & Reconciliation professional to manage management reporting, account reconciliations, data validation, and periodic MIS activities.

The role will be responsible for preparing accurate and timely MIS reports, identifying and resolving reconciliation discrepancies, maintaining data integrity, and coordinating with cross-functional teams. The position will also contribute to process improvement and reporting automation initiatives.

Mandatory Skills :

MIS Reporting, Account Reconciliation, Advanced Excel (VLOOKUP, HLOOKUP, XLOOKUP, Pivot Tables, COUNTIF/COUNTIFS, SUMIF/SUMIFS), Data Analysis, Data Validation, Financial Reporting, and Discrepancy Resolution.

Key Responsibilities :

• Collect, consolidate, validate, and analyze data from multiple sources for MIS reporting.
• Prepare and circulate daily, weekly, monthly, and periodic MIS reports for management review.
• Perform account, transaction, and ledger reconciliations and investigate discrepancies.
• Identify data mismatches, exceptions, and reconciliation breaks and ensure timely resolution.
• Maintain high standards of data accuracy, completeness, and integrity across reporting activities.
• Coordinate with Finance, Operations, Business, and other internal teams to collect and validate required information.
• Maintain and update MIS dashboards, trackers, and reporting formats as required.
• Support audit requirements by preparing relevant reports, reconciliations, schedules, and supporting documentation.
• Ensure adherence to defined reporting processes, controls, and timelines.
• Identify opportunities to improve reporting processes and reduce manual efforts through automation and standardization.
• Assist in developing and maintaining automated MIS reports using advanced Excel and other relevant tools.
• Track key operational and financial metrics and highlight significant variances or exceptions to management.
• Maintain proper documentation of reports, reconciliation workings, processes, and controls.

Key Performance Indicators / Success Criteria :

• Accuracy and timely submission of MIS reports.
• Timely completion and accuracy of account/transaction reconciliations.
• Effective identification and resolution of discrepancies and exceptions.
• Data integrity and adherence to reporting standards.
• Quality of coordination with cross-functional stakeholders.
• Reduction in manual reporting efforts through process improvement and automation.
• Timely support for audits and management reporting requirements.

Mandatory Skills :

Advanced Excel

Strong hands-on experience with Microsoft Excel, including :

• VLOOKUP / HLOOKUP
• XLOOKUP
• COUNTIF / COUNTIFS
• SUMIF / SUMIFS
• Pivot Tables
• Conditional Formatting
• Data Validation
• IF / Nested IF
• INDEX-MATCH
• Data cleaning and consolidation
• Large-data-set handling and analysis

MIS & Reconciliation

• Strong experience in MIS preparation and management reporting.
• Hands-on experience in account / transaction / ledger reconciliation.
• Ability to identify, analyze, and resolve data discrepancies.
• Good understanding of data validation and reporting controls.

Preferred / Additional Skills :

• Basic knowledge of Macros / VBA.
• Experience with Tally ERP 9 or similar accounting/ERP tools.
• Basic understanding of accounting principles and financial transactions.
• Exposure to reporting automation and process improvement.
• Experience working with large volumes of financial or transactional data.
• Good analytical and problem-solving skills.
• Strong communication and stakeholder coordination skills.

Educational Qualification :

Minimum Qualification :

• Bachelor's degree in B.A. / B.Com or equivalent.

Preferred Qualification :

• B.Com
• B.A.
• MBA – Finance / Accounting

Ideal Candidate Profile :

The ideal candidate should have strong hands-on experience in MIS reporting, reconciliation, Excel-based data analysis, and management reporting, preferably within the Fintech, BFSI, financial services, payments, or transaction-driven environment.

The candidate should be highly detail-oriented, comfortable working with large datasets, capable of independently identifying discrepancies, and proactive in improving reporting and reconciliation processes.