"Investment Data Analyst"

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.

Duties & Essential Job Functions:

Investment Operations

1. 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
2. Supports trade processing, cash management, capital calls/distributions, and performance reporting workflows.
3. Monitors data quality, identifies discrepancies, and ensures timely resolution with internal teams and external partners.
4. Assists in the preparation of investment reports, dashboards, and periodic portfolio analytics.
5. Maintains staff confidence and protect operations by keeping information confidential.

Data Integration & Automation

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

Technical / Coding Duties

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

Required Education & Experience:

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

Preferred Education & Experience:

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

Required Licensure/Certification/Specialized Training:

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

Preferred Licensure, Certification, and/or Specialized Training:

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

Knowledge, Skills & Abilities:

• 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 solutions.
• Ability to adjust to rapid changes and execute fluid management of multiple priorities in a dynamic setting.
• Ability to work comfortably at the intersection of operations, technology, and investment analytics.
• Ability to maintain exceptional attention to detail and commitment to delivering error free work.

Physical Requirements (With or Without Accommodations):

• Visual acuity to read information from computer screens, forms and other printed materials and information.
• Able to speak (enunciate) clearly in conversation and general communication.
• Hearing ability for verbal communication/conversation/responses via telephone, telephone systems, and face-to-face interactions.
• Manual dexterity for typing, writing, standing and reaching, flexibility, body movement for bending, crouching, walking, kneeling and prolonged sitting.
• Lifting and moving objects and equipment up to 10 lbs.

Work Environment:

• Work is indoors and sedentary and is subject to schedule changes and/or variable work hours.
• This role is an on campus, in-person position but may require some travel.
• There are no harmful environmental conditions present for this job.
• The noise level in this work environment is usually moderate.