Assistant Vice President - Risk & Reporting
On-siteHyderabad, Telangana, India
Job Summary
Design and maintain cloud-ready data pipelines, dimensional models, and automated ingestion workflows using SQL, Python, Power BI, and Microsoft Fabric/Azure to support enterprise reporting for alternative investment strategies. Build performant ELT/ETL processes for investment, portfolio, and cash activity data while creating institutional dashboards, semantic models, and paginated reports with row-level security. Troubleshoot production refresh failures, data quality exceptions, and transformation errors, applying Git, CI/CD, and infrastructure-as-code principles to ensure auditability and repeatability. Partner with investment teams, Investor Relations, and Finance groups to translate business requirements into technical specifications, reduce ad hoc requests, and improve pipeline data integrity across closed-end, open-end, and evergreen strategies.
Required Qualifications
- 10+ years in data engineering, BI development, reporting automation, or analytics engineering
- preferably in asset management, investment banking, fund administration, financial services or another data-rich domain with comparable rigor
- Exposure to alternative investments
- domain experience in asset-based finance, structured credit, private credit, opportunistic credit, emerging markets debt or origination vehicle solutions
- Strong hands-on proficiency with SQL, Python, Power BI, DAX, Power Query / M, semantic models, paginated reports, and data validation for recurring production reporting
- Working knowledge of cloud data platforms and architecture, including Microsoft Fabric / Azure and/or AWS services such as S3, Glue, Lambda, Redshift, Snowflake or Aurora
- Hands-on experience developing Microsoft Fabric pipelines, dataflows, Lakehouse and data warehouse solutions
- PySpark notebooks for distributed data processing in Fabric, Databricks or Synapse Spark environments
- Working knowledge of the broader Azure data stack, including Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, Azure DevOps, and SQL Server Management Studio for querying, data modeling and performance optimization
- Experience designing scalable, reusable Power BI solutions using common data models, common measures, standardized layouts and consistent navigation
- semantic-model security including row-level and object-level security
- Understanding of data governance, reporting standards and compliance frameworks
- nonnegotiable focus on data integrity, accuracy, clear naming and documentation
- Familiarity with return and performance concepts such as TWR, MWR, IRR, MOIC, TVPI, DPI and RVPI
- exposure, attribution, benchmark, and investor-reporting outputs
- Strong written, verbal and presentation skills
- ability to translate investment, reporting and data-control requirements into durable technical solutions
- explain technical design choices and trade-offs to senior stakeholders and deal-team partners
- Bachelor's or Master's degree in Computer Science, Data Science, Data Analytics, Engineering, Statistics, Mathematics, Finance, Accounting or a related analytical field
- or equivalent deep work experience building data / BI solutions in investment management
- For those applying for a position in the city of Los Angeles, qualified applicants with a criminal history
Desired Qualifications
- Experience with schema design, CDC, orchestration, IAM / secure data-access patterns, Git, CI/CD, CodeBuild / CodePipeline, GitHub Actions, testing, and release controls
- Familiarity with Oaktree-style reporting systems and workflows such as Geneva, IPS, Salesforce, Workday, AXON, eFront-style investor platforms, Jira, and Confluence
- Experience supporting collateral performance, credit metrics, exposure analysis, portfolio construction, investment performance, fund-level reporting, client reporting or reporting operations
- Experience partnering directly with investment or deal teams through working sessions, borrower calls and vendor-data validation to understand the decisions dashboards need to support and to iterate based on live feedback
- Strong BI design judgment across filter placement, page focus, navigation, drill-through structure, dynamic titles, footnotes, visual conventions, refresh cadences and controls over user interactions
- Experience contributing to BI strategy, governance standards and adoption of best practices
- judgment to surface trade-offs that could compromise scalability, maintainability or correctness
- AWS Data Analytics, Power BI Data Analyst, Azure / Fabric, CFA, FRM, CAIA or CIPM credentials
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.