Open-End Fund Analytics Specialist

Job Summary

Synechron is seeking an Analytics – Open-End Fund professional with expertise in performance and attribution reporting, portfolio exposure monitoring, alternative investments, and data analytics.

The role will support the analysis and reporting of open-end fund portfolios, including performance results, attribution, risk metrics, portfolio characteristics, and exposure information. The position will combine investment knowledge with practical experience in Python, SQL, and data visualization tools such as Power BI.

This role will contribute to business objectives by improving reporting accuracy, strengthening portfolio insight, supporting investment decision-making, and delivering clear and timely analytics to cross-functional stakeholders.

Software Requirements

Required Software Skills

• Python, SQL, and/or data visualization tools: At least 3 years of working proficiency using one or more of these technologies 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, visualizations, and analytical outputs.

• Performance reporting tools: Experience supporting investment performance reporting and related analytical workflows.

• Attribution reporting tools: Experience supporting performance attribution analysis and reporting.

• Project management tools: Basic familiarity with Jira, Confluence, or equivalent tools is preferred.

Preferred Software Skills

• Experience using more than one of Python, SQL, and Power BI.

• Familiarity with data models, reporting automation, data validation, and repeatable analytical workflows.

• Exposure to project-management, documentation, and collaboration tools such as Jira and Confluence.

• Familiarity with tools used for risk reporting, portfolio analytics, investment data management, and reporting controls.

Version and Experience Guidance

• Specific software versions are not mandated in the requirements.

• Candidates should have experience with current, production-supported versions of Python, SQL, Power BI, and related analytics tools.

• Candidates should be able to validate data, document calculation logic, manage reporting changes, and maintain reproducible analytical outputs.

• The required technology experience should be applied to investment, portfolio, performance, attribution, or related financial analysis.

Overall Responsibilities

• 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.

• Apply knowledge of open-end fund structures to interpret portfolio data, fund activity, exposure information, and reporting requirements.

• Use Python, SQL, Power BI, and related tools 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, automation, and efficient use of analytical resources.

• Ensure reporting outputs are accurate, timely, consistent, traceable, and aligned with applicable governance standards.

• Contribute to measurable outcomes such as improved reporting quality, reduced manual effort, stronger data controls, and timely delivery of portfolio insights.

Technical Skills (By Category)

Programming Languages

Essential

• At least 3 years of working proficiency in Python, SQL, and/or data visualization tools.

• Ability to use Python for data preparation, analysis, validation, reporting, and workflow automation.

• Ability to use SQL for data extraction, transformation, reconciliation, and analysis.

• Ability to document analytical logic, calculations, assumptions, and data dependencies.

Preferred

• Experience using both Python and SQL for investment data analysis.

• Experience developing reusable scripts, analytical utilities, or automated reporting processes.

• Familiarity with programming practices that support testing, validation, reproducibility, and controlled deployment.

Databases/Data Management

Essential

• Experience working with structured investment, portfolio, fund, performance, attribution, and risk data.

• Understanding of portfolio exposure attributes and portfolio characteristics.

• Ability to perform data completeness, accuracy, consistency, reconciliation, and reasonableness checks.

• Understanding of data lineage, source-to-report mapping, data definitions, and reporting controls.

• Ability to maintain data quality and integrity across recurring analytics and reporting processes.

Preferred

• Experience with data warehouses, analytical data models, semantic models, or data marts.

• Familiarity with alternative-investment data structures and reporting outputs.

• Experience with data pipelines, data dictionaries, metadata management, and automated data-quality checks.

• Exposure to data governance, retention, and lifecycle management practices.

Cloud Techno