Associate, Reporting & Portfolio Analytics (Emerging Markets)

BuzzClan; Hyderabad; Hybrid; INR 1,500,000 - 2,300,000; Full time

Job summary

BuzzClan is seeking a data engineering lead for Risk & Reporting in Hyderabad. You will own data pipelines, dashboards, and automated reporting for Emerging Markets Debt, collaborating with US stakeholders and the Hyderabad team.

You will apply CI/CD, Git, and IaC practices, ensuring data quality and auditable processes. Strong SQL, Python, Power BI skills are essential for this role.

Qualifications

• 5+ years in data engineering, BI development, or analytics engineering.
• Strong knowledge of SQL, Python, Power BI, and data validation.
• Experience with cloud data platforms (Azure, AWS) and dashboards.
• Familiarity with investment reporting metrics and controls.

Responsibilities

• Lead build, automation, refresh support, and controls for EM dashboards.
• Design and maintain data pipelines and dimensional models.
• Automate ingestion from internal systems, vendors, Salesforce, and more.
• Create dashboards, semantic models, and paginated reports.
• Troubleshoot data refreshes, gateway, and publishing issues.
• Partner with multiple teams to resolve data gaps and improve reliability.

Skills

SQL

Python

Power BI

DAX

Power Query/M

semantic models

paginated reports

production data validation

Git

CI/CD

data orchestration

Education

Bachelor's or Master's degree in Computer Science / Data Science / Engineering / Finance

Tools

Geneva

IPS

Salesforce

Workday

AXON

eFront

Jira

Confluence

Azure

Job description

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.
• 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 OneLake 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 GenAI 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, eFront-style platforms, Jira, and Confluence.
• Exposure to private credit, opportunistic credit, Emerging Markets Debt, portfolio construction, investment performance, or client reporting.

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.

Location: Hyderabad, India (Hybrid Schedule; 3 days in office)

Working Hours: 2 PM to 11 PM IST