Open-End Fund Analytics Specialist – Performance, Attribution, Python & SQL

Overview

Analyze and report on performance, attribution, exposures and risk for open-end fund portfolios, combining investment knowledge with Python, SQL and Power BI.

What you'll do

• Prepare, analyze, validate and maintain performance and attribution reporting for open-end fund portfolios.
• Monitor portfolio exposures and analyze portfolio characteristics across relevant investment strategies.
• Produce and review performance reporting, risk metrics, portfolio analytics and related investment-reporting outputs.
• Use Python, SQL and Power BI to extract, transform, analyze, reconcile and visualize investment data.
• Investigate data quality issues, reporting exceptions, calculation differences and inconsistencies in portfolio analytics.
• Support the development and enhancement of dashboards, analytical models, reporting templates and repeatable reporting processes.
• Collaborate with investment, risk, operations, finance, technology and reporting teams to clarify requirements and resolve issues.
• Translate complex investment information into clear analysis for technical and non-technical stakeholders.
• Maintain documentation covering data sources, calculation methodologies, reporting definitions, validation procedures and process controls.
• Support process improvement, reporting standardization and automation.
• Ensure reporting outputs are accurate, timely, consistent, traceable and aligned with applicable governance standards.

What you'll need

• Bachelor's degree in Finance, Accounting, Economics or a related field, or equivalent relevant experience.
• CFA or CIPM candidacy with at least one exam level passed.
• Minimum 5 years of experience at an asset management firm, investment bank, financial services organization or a related investment analytics environment.
• At least 3 years of working proficiency using Python, SQL and/or data visualization tools to support data analysis and reporting.
• Python: experience preparing, transforming, analyzing, validating or automating investment and portfolio data.
• SQL: experience querying, joining, validating and analyzing structured investment and portfolio datasets.
• Data visualization: experience using Power BI or an equivalent tool to create dashboards, reports and analytical outputs.
• Experience supporting investment performance reporting and related analytical workflows.
• Experience supporting performance attribution analysis and reporting.
• Solid knowledge of performance and attribution reporting.
• Solid understanding of open-end fund structures, including portfolio exposure monitoring.
• Strong knowledge of alternative investments and related reporting outputs, including performance reporting, risk metrics and portfolio characteristics.
• Ability to perform data completeness, accuracy, consistency, reconciliation and reasonableness checks.
• Demonstrated ability to communicate investment analysis clearly and work effectively across functions.
• Understanding of confidentiality, access control, data protection and appropriate handling of fund and portfolio information.

Nice to have

• Experience using more than one of Python, SQL and Power BI.
• Basic familiarity with Jira, Confluence or equivalent project-management and documentation tools.
• Familiarity with data models, reporting automation, data validation and repeatable analytical workflows.
• Familiarity with tools used for risk reporting, portfolio analytics, investment data management and reporting controls.
• CA designation, CFA designation, CA Inter qualification and/or an MBA with a Finance focus.
• Experience supporting portfolio analytics, investment performance, fund reporting, risk reporting or alternative-investment operations.

Details

• Location: Hyderabad Eco Park.