Risk & Reporting Analyst – Alternative Investments, Portfolio Analytics & Excel/SQL

Job Summary
Synechron is seeking a Risk & Reporting Analyst with experience in asset management, investment banking, fund administration, or financial services. The role will support private credit, private equity, investment reporting, portfolio analytics, and recurring investor-reporting workflows.
The position will analyze portfolio data, calculate alternative-investment performance metrics, prepare reporting outputs, validate data quality, and translate complex information into clear analysis for internal and external stakeholders.
The role will contribute to business objectives by improving reporting accuracy, strengthening data controls, supporting informed investment decisions, and delivering timely, consistent, and transparent portfolio and investor insights.
Software Requirements
Required Software Skills
Microsoft Excel: Strong hands-on experience with formulas, pivot tables, lookups, Power Query, data validation, reconciliation, and reporting automation.
SQL: Working experience querying, validating, joining, and analyzing structured financial and portfolio data.
Power BI: Experience creating or supporting dashboards, visualizations, data models, and reporting outputs is required where applicable.
Data validation tools: Ability to apply completeness, accuracy, consistency, reconciliation, exception, and reasonableness checks.
Investment reporting tools: Experience supporting recurring investor-reporting workflows, portfolio analytics, exposure reporting, performance reporting, and attribution outputs.
Reporting documentation: Ability to maintain reporting specifications, data dictionaries, calculation logic, control documentation, and process procedures.
Preferred Software Skills
Python: Experience with data analysis, reporting automation, data validation, and repeatable analytical workflows.
Approved GenAI tools: Experience with prompt engineering for analysis, documentation, workflow support, or reporting activities, subject to applicable controls.
Azure or Microsoft Fabric: Familiarity with cloud-based data, analytics, semantic models, and reporting environments.
Deployment pipelines: Exposure to deployment and release processes for reporting, data, or analytical solutions.
Jira and Confluence: Working knowledge of work-item management, process documentation, requirements tracking, and knowledge sharing.
Investor-platform workflows: Familiarity with eFront-style workflows or comparable investment and portfolio reporting platforms.
Version and Experience Guidance
Specific software versions are not mandated in the requirements.
Candidates should have experience with current, production-supported versions of Excel, SQL, Power BI, Python, and relevant reporting or analytics tools.
Candidates should be able to assess data and reporting-tool compatibility, document changes, validate outputs, and follow controlled release practices.
Experience should include practical delivery of recurring reports, portfolio analysis, financial data validation, or related reporting outputs.
Overall Responsibilities
Prepare, review, validate, and maintain recurring investment and investor-reporting outputs.
Analyze portfolio exposure attributes, performance information, attribution data, benchmarks, and related investment metrics.
Apply and explain alternative-investment performance measures, including:Time-Weighted Return (TWR)Money-Weighted Return (MWR)Internal Rate of Return (IRR)Multiple on Invested Capital (MOIC)Total Value to Paid-In (TVPI)Distributions to Paid-In (DPI)Residual Value to Paid-In (RVPI)
Support portfolio analytics across private credit, private equity, and other alternative-investment strategies.
Review and reconcile source data, calculated metrics, reporting outputs, and investor-facing information.
Use Excel, SQL, Power BI, and related tools to analyze data and produce clear reporting.
Investigate data exceptions, calculation differences, missing information, and reporting breaks.
Maintain recurring reporting workflows, calculation logic, control procedures, and supporting documentation.
Collaborate with investment, operations, finance, fund administration, technology, risk, and reporting teams.
Own assigned workstreams from requirements clarification through analysis, validation, review, and delivery.
Support the development of dashboards, semantic models, reporting templates, and repeatable analytical processes.
Apply appropriate data controls when using approved GenAI tools for analysis, documentation, or workflow support.
Contribute to process improvement, reporting automation, data-quality enhancement, and sustainable resource use.
Ensure reporting activities support accuracy, timeliness, transparency, confidentiality, and applicable governance standards.
Track deliverables, dependencies, risks, issues, and stakeholder feedback to support predictable reporting outcomes.
Technical Skills (By Category)
Programming Languages
Essential
SQL for data extraction, transformation, reconciliation, validation, and analysis.
Ability to interpret calculation logic and translate investment metrics into repeatable analytical processes.
Ability to work with formulas, structured data, validation rules, and reporting calculations in Excel.
Ability to document analytical logic and reproduce reporting results.
Preferred
Python for data analysis, reporting automation, validation, and workflow improvement.
Experience developing reusable scripts or utilities for data preparation and report generation.
Familiarity with programming concepts that support analytical model testing and deployment.
Databases/Data Management
Essential
Experience working with structured and unstructured financial, portfolio, investment, or investor-reporting data.
Understanding of portfolio exposure attributes, investment records, performance data, benchmarks, attribution data, and reporting hierarchies.
Ability to perform data reconciliation, validation, completeness checks, exception analysis, and reasonableness testing.
Understanding of data lineage, definitions, source-to-report mapping, data ownership, and reporting controls.
Ability to maintain data quality and integrity across recurring reporting processes.
Preferred
Experience with semantic models, data marts, data warehouses, or analytical data platforms.
Familiarity with alternative-investment accounting concepts and investment-platform workflows.
Knowledge of side-letter requirements, ILPA reporting standards, and related reporting considerations.
Experience with data pipelines, metadata management, data dictionaries, and automated data-quality checks.
Cloud Technologies
Essential
Understanding of cloud-based data, analytics, and reporting environments.
Ability to work with controlled access, data protection, reporting environments, and managed analytical services.
Preferred
Familiarity with Azure or Microsoft Fabric.
Experience with semantic models, cloud data platforms, analytical workspaces, and reporting deployment pipelines.
Exposure to cloud-based workflow automation and scheduled reporting.
Understanding of resource-efficient data processing and sustainable reporting operations.
Frameworks and Libraries
Essential
Excel reporting and analytical capabilities, including Power Query.
Power BI reporting, visualization, and dashboard capabilities where applicable.
SQL querying and data-analysis tools.
Financial and investment-performance calculation methodologies.
Reporting and reconciliation frameworks that support recurring investor and portfolio outputs.
Preferred
Python data-analysis libraries and automation frameworks.
Semantic modelling and reporting frameworks.
Tools supporting data-quality monitoring, workflow automation, and report validation.
Investor-platform or eFront-style workflows.
Tools and processes aligned with ILPA reporting standards.
Development Tools and Methodologies
Essential
Experience across the reporting lifecycle, including requirements analysis, data review, calculation, validation, stakeholder review, delivery, and issue resolution.
Strong Excel-based analytical and reporting practices.
Experience using SQL and/or Power BI for portfolio reporting and analysis.
Ability to document requirements, calculation methodologies, validation procedures, reporting controls, and operational processes.
Familiarity with structured workstream ownership, issue tracking, review cycles, and delivery management.
Understanding of Agile, iterative delivery, or controlled reporting-development practices.
Preferred
Experience with Jira and Confluence for work-item tracking, documentation, and team collaboration.
Experience with deployment pipelines for reporting, data, or semantic-model changes.
Familiarity with Python-based automation, scheduled workflows, and repeatable reporting processes.
Exposure to prompt engineering wi

Skills
SQL, Excel, Python, Azure, Data Analysis, Power BI, Agile, Jira, Confluence, Process Improvement