Investment Operations Analyst

Job Summary:

The Investment Operations Analyst will play a key role in supporting the Investment Management office by ensuring timely, accurate, and scalable operational and accounting workflows. This role combines traditional investment operations responsibilities with portfolio accounting, cash management, and process oversight, alongside 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 reliability and consistency of operational and financial 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, including coordination of reconciliations and data alignment with custodians and administrators.
3. Monitors accounting data integrity and reconciliation exceptions, identifies discrepancies, and ensures timely resolution with internal teams and external partners.
4. Assists in the preparation of financial and 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, ensuring alignment across operational and accounting data sources.
7. Evaluates data infrastructure and builds and maintains automated pipelines to ingest, clean, and validate data to support consistent downstream reporting and reconciliations.
8. Collaborates with technology partners to enhance data architecture, troubleshoot integration issues, and ensure system reliability for core operational and accounting functions.
9. Implements quality checks and exception reporting to improve data accuracy, financial control 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 with an emphasis on repeatable accounting processes and internal controls.
13. Performs other related duties as assigned.

Required Education & Experience:

• Bachelor’s degree in Finance, Economics, Accounting, 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:

• CPA, CAIA, FRM
• 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.
• Exposure to investment accounting concepts (e.g., cash and position reconciliations, financial reporting tie-outs, audit support).
• 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, accounting, technology, and investment analytics.
• Ability to maintain exceptional attention to detail and commitment to delivering error free work.

TCU Core Competencies:

University Core Competencies definitions may be found on the Human Resources website and in the staff performance management system.

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.

Employment Values Statement:

Texas Christian University values Integrity, Engagement, Community, and Excellence in the workplace. TCU treats applicants and employees with fairness and respect. TCU hires and promotes individuals based on their qualifications and their commitment to making a positive impact on our student-centered community. TCU is an equal opportunity employer and follows all applicable employment laws. TCU fairly considers all qualified individuals, ensuring we are a workplace free from unlawful discrimination and harassment.