About the Role
We are looking for an experienced and detail-oriented Senior Data Analyst to join our team. The ideal candidate should have strong analytical capabilities, hands-on experience in MIS preparation, business intelligence, data management and performance analytics.
The candidate will be responsible for analysing business data, developing management reports, identifying trends, generating actionable insights and supporting senior management in strategic and operational decision-making.
Key Responsibilities
MIS & Reporting
- Prepare, maintain and analyse daily, weekly and monthly MIS reports.
- Develop comprehensive dashboards and performance reports for management.
- Consolidate data from multiple sources and ensure accuracy and consistency.
- Prepare business performance reports covering disbursements, collections, portfolio quality and branch-wise performance.
Business & Data Analytics
- Analyse business performance, identify trends, patterns and deviations.
- Conduct variance analysis and identify gaps against business targets.
- Develop analytical models to support business planning and decision-making.
- Provide actionable insights to improve operational efficiency and business performance.
Data Management & Automation
- Work extensively with MS Excel, Advanced Excel, Power BI and SQL.
- Automate recurring MIS reports and improve reporting processes.
- Develop interactive dashboards for real-time business monitoring.
- Ensure data integrity, accuracy and timely reporting.
Business Performance Monitoring
- Monitor branch-wise, region-wise and product-wise business performance.
- Analyse sales productivity, collection efficiency, portfolio performance and operational metrics.
- Identify underperforming branches and highlight key business concerns.
- Support management with data-backed recommendations and analytical reports.
Management Support
- Prepare presentations and analytical reports for senior management.
- Coordinate with Business, Finance, Operations and other departments for data requirements.
- Handle ad-hoc analytical assignments and special projects as required by management.
Required Skills & Qualifications
- Graduate/Postgraduate in Commerce, Finance, Statistics, Mathematics, Economics, Business Analytics or a related discipline.
- 57 years of relevant experience in Data Analytics, Business Analytics or MIS.
- Strong hands-on expertise in Advanced MS Excel, including Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, Power Query and complex formulas.
- Working knowledge of Power BI, dashboard creation and data visualisation.
- Knowledge of SQL and database management.
- Strong analytical, numerical and problem-solving abilities.
- Excellent presentation skills and the ability to interpret complex data into meaningful business insights.
- Ability to independently manage end-to-end MIS and analytical reporting.
Preferred Candidate Profile
- Candidates from NBFC, Banking, Financial Services or Fintech backgrounds will be preferred.
- Experience in handling large datasets and multi-location business operations.
- Ability to interact with senior management and present analytical findings.
- Strong ownership, attention to detail and a result-oriented approach.
Interested candidates to share their resume at hr@dugar.co.in or 9092807676