Risk & Reporting Analyst – Alternative Investments, Portfolio Analytics & Excel/SQL

Overview

Support private credit, private equity and investment reporting workflows by analysing portfolio data, calculating alternative-investment performance metrics, preparing reporting outputs and validating data quality.

What you'll do

• Prepare, review, validate and maintain recurring investment and investor-reporting outputs.
• Analyze portfolio exposure attributes, performance information, attribution data, benchmarks and related investment metrics.
• Apply and explain TWR, MWR, IRR, MOIC, TVPI, DPI and RVPI.
• Support portfolio analytics across private credit, private equity and other alternative-investment strategies.
• Review and reconcile source data, calculated metrics, reporting outputs and investor-facing information.
• Use Excel, SQL, Power BI and related tools to analyze data and produce clear reporting.
• Investigate data exceptions, calculation differences, missing information and reporting breaks.
• Maintain recurring reporting workflows, calculation logic, control procedures and supporting documentation.
• Collaborate with investment, operations, finance, fund administration, technology, risk and reporting teams.
• Own assigned workstreams from requirements clarification through analysis, validation, review and delivery.
• Support the development of dashboards, semantic models, reporting templates and repeatable analytical processes.
• Apply appropriate data controls when using approved GenAI tools for analysis, documentation or workflow support.
• Contribute to process improvement, reporting automation, data-quality enhancement and sustainable resource use.
• Ensure reporting activities support accuracy, timeliness, transparency, confidentiality and applicable governance standards.
• Track deliverables, dependencies, risks, issues and stakeholder feedback to support predictable reporting outcomes.

What you'll need

• Minimum 5 years of experience in asset management, investment banking, fund administration, financial services or a related analytical reporting role.
• Bachelor's degree in Finance, Accounting, Economics, Computer Science, Data Analytics, Business or a related field; equivalent relevant experience may be considered.
• Exposure to private credit, private equity, investment reporting, portfolio analytics, alternative investments or recurring investor-reporting workflows.
• Strong knowledge of TWR, MWR, IRR, MOIC, TVPI, DPI and RVPI, along with exposure, attribution, benchmark and investor-reporting outputs.
• Strong Excel skills, including formulas, pivot tables, lookups, Power Query and data validation.
• Experience with SQL and/or Power BI.
• Required software skills: SQL for querying, validating, joining and analyzing structured financial and portfolio data.
• Required software skills: Power BI dashboards, visualizations, data models and reporting outputs where applicable.
• Data validation tools: completeness, accuracy, consistency, reconciliation, exception and reasonableness checks.
• Investment reporting tools: recurring investor-reporting workflows, portfolio analytics, exposure reporting, performance reporting and attribution outputs.
• Reporting documentation: maintain reporting specifications, data dictionaries, calculation logic, control documentation and process procedures.
• Ability to own reporting workstreams, validate results, identify exceptions, explain calculations and deliver accurate outputs within agreed timelines.
• Understanding of confidentiality, access control, data protection and appropriate handling of investment and investor information.
• Ability to use approved GenAI tools without exposing restricted, confidential or sensitive information.
• Understanding of cloud-based data, analytics and reporting environments.
• Understanding of data lineage, definitions, source-to-report mapping, data ownership and reporting controls.
• Experience across the reporting lifecycle, including requirements analysis, data review, calculation, validation, stakeholder review, delivery and issue resolution.
• Ability to communicate complex data, performance results, assumptions, risks and recommendations clearly in written and verbal formats.

Nice to have

• Python for data analysis, reporting automation, data validation and repeatable analytical workflows.
• Approved GenAI tools: prompt engineering for analysis, documentation, workflow support or reporting activities.
• Azure or Microsoft Fabric, including semantic models and reporting environments.
• Exposure to deployment and release processes for reporting, data or analytical solutions.
• Jira and Confluence for work-item management, process documentation and knowledge sharing.
• eFront-style or comparable investment and portfolio reporting platform workflows.
• Familiarity with alternative-investment accounting concepts, side-letter requirements and ILPA reporting standards.
• Experience with semantic models, data marts, data warehouses or analytical data platforms.
• Familiarity with financial-services risk, compliance and audit requirements.
• CFA, FRM, CAIA, CIPM, Chartered Accountant or other industry-relevant professional credentials.

Details

• Location: Hyderabad, Eco Park.