Investment Data Analyst

Overview

Job Summary The Investment Data Analyst will play a key role in supporting the Investment Management office by ensuring timely, accurate, and scalable data workflows. This role combines traditional investment operations responsibilities with modern technical skills, including light coding, API-driven data extraction, and data-warehouse management. This position is crucial to building a modern, efficient operational infrastructure that empowers the investment team with accurate, accessible data.

The Analyst will help accelerate Investment Management's shift toward automation and analytics, reducing manual processes while improving the quality and timeliness of information used for decision-making.

Investment Operations

• Onboards new investments, records transactions, and analyzes complex and non-traditional investments which involve non-standard contracts, cash flow processing, valuations, liquidity terms, various investment attributes, and document management throughout the investment lifecycle
• Supports trade processing, cash management, capital calls/distributions, and performance reporting workflows.
• Monitors data quality, identifies discrepancies, and ensures timely resolution with internal teams and external partners.
• Assists in the preparation of investment reports, dashboards, and periodic portfolio analytics.
• Maintains staff confidence and protect operations by keeping information confidential.

Data Integration & Automation

• Pulls data from various systems (e.g., custodians, fund administrators, CRM, portfolio monitoring tools) via APIs, scheduled extracts, or custom scripts.
• Evaluates data infrastructure and builds and maintains automated pipelines to ingest, clean, and validate data.
• Collaborates with technology partners to enhance data architecture, troubleshoot integration issues, and ensure system reliability.
• Implements quality checks and exception reporting to improve data accuracy and operational efficiency.

Technical / Coding Duties

• Writes and maintains light scripts (e.g., Python, SQL, or similar languages) to transform and move data between systems.
• Supports the design and maintenance of datasets used for performance measurement, risk analytics, and investment reporting.
• Creates documentation and standard operating procedures for data workflows and integrations.
• Performs other related duties as assigned.

• Bachelor’s degree in Finance, Economics, Accounting, Data Science, Computer Science, or related field.
• 2 years of experience in investment operations, financial analytics, fund administration, or a similar role.
• Experience writing basic Python and/or SQL queries or scripts.

• CFA, CAIA, FRM or CPA
• Experience with data warehouse environments (e.g., Snowflake, Redshift, Big Query, Azure SQL).
• Experience with ETL/ELT tools (e.g., Fivetran, Airflow, dbt).
• Experience improving or automating operational workflows.

• Ability to work with APIs, JSON data structures, and system-to-system integrations.

• Knowledge of portfolio accounting platforms or investment management systems.
• Understanding of reporting/visualization tools (e.g., Power BI, Tableau).

• Knowledge of various investment products (private equity, hedge funds, public markets, alternatives, etc.).
• Skill in effective written and verbal communication of complex information.
• Ability to translate technical results into clear insights for non-technical stakeholders.
• Ability and eagerness to learn new tools, APIs, and automation techniques.
• Ability to work with large data sets and troubleshooting data inconsistencies.
• Ability to work effectively across investment, technology, finance, and external partners.
• Ability to be self-motivated and willing to work both independently and collaboratively.
• Ability to manage multiple projects and meet deadlines.
• Ability to stay organized and show a strong discipline around documentation, process adherence, and data governance.
• Ability to identify root causes and implement scalable…