Location: Hyderabad, India (Hybrid Schedule; 3 days in office)
Working Hours: 2 PM to 11 PM IST
Job Description
Our Risk & Reporting (R&R) team is building performance analytics, investor reporting, and reporting automation across closed-end, open-end, and evergreen strategies. In this role, you will lead the build, automation, refresh support, and controls for Emerging Markets Debt dashboards, datasets, and recurring reporting deliverables.
Data Engineering & Architecture
Design and maintain data pipelines and dimensional models using SQL, Python, Power BI, Microsoft Fabric/Azure, and relevant AWS services.
Automate data ingestion from internal systems, data warehouses, vendor files, Salesforce, and other reporting sources.
Build ELT/ETL workflows for portfolio, performance, exposure, attribution, cash activity, and reporting-control data.
Develop reusable SQL and Python tools for data engineering, integration, validation, and testing.
Business Intelligence, Automation & Controls
Create Power BI dashboards, semantic models, paginated reports, DAX measures, Power Query transformations, and deployment assets.
Troubleshoot dataset refreshes, gateway issues, transformation errors, and publishing issues.
Apply Git, CI/CD, documentation, logging, and data-quality controls to make recurring reports reliable and auditable.
Use infrastructure-as-code and orchestration tools where appropriate.
Emerging Markets Reporting
Support Emerging Markets Debt performance, exposure, portfolio, benchmark, and investor-reporting workflows.
Maintain EM dashboards and resolve Power BI and One Lake refresh or data issues.
Build checks for issuer, security, region, country, currency, valuation, cash-flow, benchmark, and performance data.
Partner with investment, R&R, Data Management, Technology, and Finance teams to resolve data gaps and improve reporting reliability.
Partnership & Delivery
Translate business needs into technical specifications, delivery plans, data dictionaries, acceptance criteria, and support playbooks.
Review work, mentor junior team members, and coordinate handoffs between US stakeholders and the Hyderabad team.
Use approved Gen AI tools responsibly for analysis, documentation, testing, and troubleshooting.
Experience Required
5+ years in data engineering, BI development, reporting automation, or analytics engineering; financial services experience preferred.
Strong hands-on skills in SQL, Python, Power BI, DAX, Power Query/M, semantic models, paginated reports, and production data validation.
Working knowledge of Microsoft Fabric/Azure and/or AWS cloud data platforms.
Familiarity with investment performance measures such as TWR, MWR, IRR, MOIC, TVPI, DPI, and RVPI, as well as exposure, attribution, benchmarks, and investor reporting.
Strong communication skills and the ability to turn reporting and data-control requirements into technical solutions.
Preferred Experience
Schema design, change data capture, orchestration, secure data access, Git, CI/CD, testing, and release controls.
Investment reporting systems and tools such as Geneva, IPS, Salesforce, Workday, AXON, e Front-style platforms, Jira, and Confluence.
Exposure to private credit, opportunistic credit, Emerging Markets Debt, portfolio construction, investment performance, or client reporting.
AWS Data Analytics, Power BI Data Analyst, Azure/Fabric, CFA, FRM, CAIA, or CIPM credentials.
Personal Attributes
Enjoys building reliable data products that replace manual reporting.
Curious and thorough when investigating source-data or production issues.
Organized and able to manage technical projects, incidents, documentation, and deadlines independently.
Collaborative, professional, and willing to mentor others.
Education
Bachelor’s or master’s degree in Computer Science, Data Science, Engineering, Finance, Accounting, or a related analytical field; equivalent deep experience building data and BI solutions in investment management may also qualify.