Analyst - Risk & Reporting - SQL, Python, and Power BI

Job Title - Analyst - Risk & Reporting Job Location - HITEC City, Hyderabad, Telangana 500081 (hybrid in-office 3 days a week, working the 2pm 11pm IST shift). Position – 1 The Opportunity The Risk & Reporting (R&R) team delivers technology-enabled performance analytics and investor reporting across Oaktree's closed-end, open-end and evergreen strategies, including Private Credit, Opportunistic Credit, Asset-Backed Finance, Special Situations, and Real Estate. The team partners across investments, client, finance, valuation, data, technology, legal, and compliance groups to produce accurate performance, exposure, allocation, and client-reporting data. As an Analyst Contingent Worker, you will support R&R deliverables, validate investment-level data, and convert complex information into clear analysis, dashboards, and investor-ready materials. What You'll Do Performance & Reporting Prepare, refresh, and validate strategy- and investment-level track records, including IRR, MOIC, TVPI, DPI, and RVPI, across recurring and ad hoc cycles; Analyze investment-level performance drivers and tie deployments, valuation changes, exits, distributions, exposure movements, and return drivers to approved source reports; Support strategy, portfolio, investment-performance, exposure, attribution, client-template, and meeting-pack workflows across R&R-supported strategies; Refresh portfolio analytics covering loss, default, recovery, watchlist, leverage, yield, sector, geography, currency, fair value, and benchmark / PME analysis. Investor Reporting Support investor-reporting data packs, RFP / DDQ inputs, capital-account and transaction schedules, and ILPA-style templates; Validate bespoke client-template data, including exposure-by-GICS, BIS / Basel fields, instrument classifications, issuer details, fair-value exceptions, and bank-loan, CLO, and derivative economics; Maintain LP, consultant, and internal trackers / reporting packs, including owners, due dates, side-letter, parallel-fund, and exclusion-list requirements. Technology & Automation Use Excel, SQL, Python, and Power BI to convert large datasets and manual reports into reusable extracts, checks, dashboards, and paginated-report workflows; Build fluency in Oaktree's in-house systems, governed reporting datasets, Microsoft Fabric, semantic models, Power Query / M, DAX, and secure data-access patterns; Document, test, and version-control recurring outputs, using approved GenAI tools to improve analysis, documentation, and quality. Partnership & Ownership Partner across investment, client, finance, valuation, data, technology, legal, and compliance teams to deliver accurate, deadline-driven R&R outputs. What You'll Bring Required 3+ years in asset management, investment banking, fund administration, or financial services, with exposure to private credit, private equity, investment reporting, or portfolio analytics; Working knowledge of alternative-investment performance metrics, portfolio exposure attributes, and recurring investor-reporting workflows; Familiarity with return and performance concepts such as TWR, MWR, IRR, MOIC, TVPI, DPI and RVPI, plus exposure, attribution, benchmark, and investor-reporting outputs; Strong Excel skills, including formulas, pivot tables, lookups, Power Query, and data validation, plus SQL and/or Power BI experience; Strong written and verbal communication skills, with the ability to work cross-functionally and turn complex data into clear analysis. Preferred Python for data analysis / automation, prompt engineering with approved GenAI tools, and familiarity with Azure or Microsoft Fabric, semantic models, and deployment pipelines; Working knowledge of alternative-investment accounting concepts, investor-platform or eFront-style workflows, side letters, ILPA reporting standards, and Jira / Confluence. How You Work High initiative, strong work ethic, and independent ownership of short- and long-term goals; Curious, rigorous, organized, and team-oriented, with a builder's mindset focused on automation, quality, and continuous improvement. Education & Credentials Bachelor's degree required. Industry-relevant professional credentials are a strong plus, including the CFA, FRM, CAIA, and CIPM designations, and/or a Chartered Accountant (CA) qualification. Position – 2 The Opportunity The Risk & Reporting (R&R) team delivers technology-enabled performance analytics and investor reporting across Oaktree's closed-end, open-end and evergreen strategies, including Private Credit, Opportunistic Credit, Asset-Backed Finance, Special Situations, and Real Estate. The team partners across investments, client, finance, valuation, data, technology, legal, and compliance groups to produce accurate performance, exposure, allocation, and client-reporting data. As an Analyst Contingent Worker, you will support R&R deliverables, validate investment-level data, and convert complex information into clear analysis, dashboards, and investor-ready materials. What You'll Do Performance & Reporting Prepare, refresh, and validate strategy- and investment-level track records, including IRR, MOIC, TVPI, DPI, and RVPI, across recurring and ad hoc cycles; Analyze investment-level performance drivers and tie deployments, valuation changes, exits, distributions, exposure movements, and return drivers to approved source reports; Support strategy, portfolio, investment-performance, exposure, attribution, client-template, and meeting-pack workflows across R&R-supported strategies; Refresh portfolio analytics covering loss, default, recovery, watchlist, leverage, yield, sector, geography, currency, fair value, and benchmark / PME analysis. Investor Reporting Support investor-reporting data packs, RFP / DDQ inputs, capital-account and transaction schedules, and ILPA-style templates; Validate bespoke client-template data, including exposure-by-GICS, BIS / Basel fields, instrument classifications, issuer details, fair-value exceptions, and bank-loan, CLO, and derivative economics; Maintain LP, consultant, and internal trackers / reporting packs, including owners, due dates, side-letter, parallel-fund, and exclusion-list requirements. Technology & Automation Use Excel, SQL, Python, and Power BI to convert large datasets and manual reports into reusable extracts, checks, dashboards, and paginated-report workflows; Build fluency in Oaktree's in-house systems, governed reporting datasets, Microsoft Fabric, semantic models, Power Query / M, DAX, and secure data-access patterns; Document, test, and version-control recurring outputs, using approved GenAI tools to improve analysis, documentation, and quality. Partnership & Ownership Partner across investment, client, finance, valuation, data, technology, legal, and compliance teams to deliver accurate, deadline-driven R&R outputs. What You'll Bring Required 3+ years in asset management, investment banking, fund administration, or financial services, with exposure to private credit, private equity, investment reporting, or portfolio analytics; Working knowledge of alternative-investment performance metrics, portfolio exposure attributes, and recurring investor-reporting workflows; Familiarity with return and performance concepts such as TWR, MWR, IRR, MOIC, TVPI, DPI and RVPI, plus exposure, attribution, benchmark, and investor-reporting outputs; Strong Excel skills, including formulas, pivot tables, lookups, Power Query, and data validation, plus SQL and/or Power BI experience; Strong written and verbal communication skills, with the ability to work cross-functionally and turn complex data into clear analysis. Preferred Python for data analysis / automation, prompt engineering with approved GenAI tools, and familiarity with Azure or Microsoft Fabric, semantic models, and deployment pipelines; Working knowledge of alternative-investment accounting concepts, investor-platform or eFront-style workflows, side letters, ILPA reporting standards, and Jira / Confluence. How You Work High initiative, strong work ethic, and independent ownership of short- and long-term goals; Curious, rigorous, organized, and team-oriented, with a builder's mindset focused on automation, quality, and continuous improvement. Education & Credentials Bachelor's degree required. Industry-relevant professional credentials are a strong plus, including the CFA, FRM, CAIA, and CIPM designations, and/or a Chartered Accountant (CA) qualification .