Investor Reporting Analyst — Data-Driven, Excel & VBA

Oak Hill Advisors; Fort Worth (TX); Hybrid; USD 70,000 - 90,000; Full time

Benefits offered by this job

Health and Welfare benefits

Retirement plan contributions

Wellness programs

Discounted voluntary benefits

Flexible work schedule

Job summary

Oak Hill Advisors L.P. seeks an Analyst to join its Investor Reporting team in Fort Worth, TX.

You will analyze large financial data for investor reporting, portfolio attribution, risk and performance reporting across the firm’s funds, with a strong focus on accuracy and process improvement. You will collaborate with Client Coverage, Client Accounting, Trading, Legal and Compliance; review reporting packages; onboard new clients; and build investor presentations using Excel (Power Query).

Qualifications

• 2–5 years of relevant experience in finance or accounting roles.
• Bachelor’s degree in Accounting or Finance preferred.
• Expert level Excel including modeling and pivot tables.
• Strong verbal and written communication.
• Demonstrated analytics, critical thinking and problem solving skills.
• Proficiency in MS Office and Adobe; VBA/SQL skills a plus.
• Self-starter with the ability to manage multiple tasks.
• Attention to detail and organization.

Responsibilities

• Liaise with Client Coverage, Client Accounting, Trading, Legal, and Compliance on investor inquiries.
• Support Client Coverage and Marketing teams.
• Review investor reporting packages.
• Assist with regulatory reporting and filings.
• Onboard new clients and manage reporting relationships.
• Set up, review, and distribute investor reporting in CRM.
• Build reporting and investor presentations using Excel tools (Power Query).
• Identify and resolve data discrepancies.
• Create and manage Capital Calls, Distribution Notices, Monthly Reporting, and Statements.
• Review new LPAs/IMAs to assist onboarding.
• Independently manage projects from start to finish.
• Assist with distribution software and external reporting.
• Other duties as assigned.

Skills

Advanced Excel

Pivot tables

VBA

SQL

Power Query

MS Office

Analytical thinking

Communication skills

Education

Bachelor's degree in Accounting or Finance

Tools

MS Office

Adobe

Job description

Oak Hill Advisors L.P. seeks an Analyst to join its Investor Reporting team in Fort Worth, TX.

You will analyze large financial data for investor reporting, portfolio attribution, risk and performance reporting across the firm’s funds, with a strong focus on accuracy and process improvement. You will collaborate with Client Coverage, Client Accounting, Trading, Legal and Compliance; review reporting packages; onboard new clients; and build investor presentations using Excel (Power Query).