We are seeking a highly motivated Data Analyst Intern to support our Analytics and transaction advisory team. The selected candidate will assist in analysing financial and operational data, preparing Information Memorandums (IMs) for stressed asset and transaction opportunities, tracking transaction progress, and generating analytical insights to support investment evaluation and resolution decisions.
The role offers hands-on exposure to distressed asset transactions, NPA resolution, financial analysis, advisory assignments, and data-driven decision-making within the financial services sector.
Requirements:
· Analyze datasets related to NPAs, distressed assets, and investment opportunities.
· Assist in creating dashboards and reports using Excel and Power BI.
· Conduct data cleaning, validation, and reconciliation activities.
· Analyze financial statements, balance sheets, and business performance metrics.
· Support investor presentations and transaction-related reporting.
· Generate insights to support strategic decision-making.
Required Skills:
· Advanced Excel (Pivot Tables, VLOOKUP/XLOOKUP, Power Query), financial variance reports
· Power BI (KPI dashboards, variance tracking, management reporting, Looker Studio)
· SQL (Data extraction, reconciliation queries, exception identification, ledger validation)
· Strong analytical and numerical skills
· Data visualization and reporting
· Understanding of Financial Statements and Ratio Analysis
Pay: ₹84,000.00 - ₹120,000.00 per year
Work Location: In person
