Job Description

Location

Cincinnati, OH, 45202 (On-Site, Remote not available)

Position Summary

The Investment Data Analyst is a member of the Portfolio Management Team and is accountable for supporting the development and maintenance of investment data pipelines, validating data across systems, and helping with reconciliations. The position ensures that internal and proprietary systems have clean, reliable, and timely data to support investment decision-making.

Data Management & Systems QA

• Assist in maintaining investment data pipelines and database processes that feed portfolio monitoring tools.
• Help validate data accuracy, reconcile discrepancies, and elevate issues for resolution.
• Collaborate with Operations and technology to ensure smooth data flow across systems.
• Contribute to workflow documentation and quality checks to reduce manual errors and improve reliability.

Portfolio Implementation & Trading Support

• Assist with portfolio rebalancing workflows by preparing trade files, reviewing model outputs, and validating account-level data.
• Support the PM team with IPS target reviews, allocation checks, and benchmark alignment across client accounts.
• Help prepare materials for Asset Allocation Studies and Dynamic Asset Allocation updates.
• Coordinate with Operations to monitor trade status, resolve trade breaks, and ensure accurate settlement.

Data Integrity & Pipelines

• Support reconciliation of portfolio data across Black Diamond, SS&C, FactSet, and internal systems.
• Assist in daily checks under supervision to ensure reliable inputs for portfolio monitoring.
• Build and maintain basic data pipelines and workflows using Python, SQL, and Excel/Power BI.
• Monitor exceptions, log discrepancies, elevate issues, and track resolutions to ensure long-term reliability of internal and proprietary systems.

Youll Enjoy This Job If

• Take pride in working with investment data and ensuring accuracy down to the detail.
• Enjoy solving reconciliation challenges and learning how investment systems connect.
• Want to expand technical skills in Python, SQL, data pipelines, AI and BI tools.
• Collaborate naturally across multiple teams.

What We Expect / Qualifications

• Bachelors degree in Finance, Economics, Computer Science, Data Analytics, or related field.
• 13 years of experience in data analysis, financial operations, or investment services.
• Strong Excel skills (formulas, pivots, lookups) and working knowledge of SQL.
• Foundational experience with Python for data processing or reconciliation.

What We Offer / Benefits & Compensation

• Competitive compensation and bonus opportunities commensurate with qualifications and performance.
• Employer-paid life/STD/LTD and subsidized Medical, Dental, & Vision plans.
• Wealth Benefits including company contributions into 401(k) and ESOP programs.
• Paid Time Off (Holidays, PTO, Parental Leave) and flexible/hybrid working.
• Employee-led culture committees dedicated to enabling a happy and healthy company culture.

About the Company

FEG is an independently owned advisory firm that provides investment consulting, outsourced chief investment officer (OCIO), and research services to institutional clients such as university endowments, foundations, and family offices. Founded in 1988, FEG has served communities for over 35 years of advisory services with professionals across Cincinnati, Dallas, and Indianapolis.

Legal & Equal Opportunity

FEG Investment Advisors is an Equal Opportunity Employer. FEG Investment Advisors does not discriminate in its employment decisions based on race, religion, color, national origin, sex (including pregnancy, gender identity and sexual orientation), age (40 or older), disability, veteran or military status, genetic information, or any other basis that would violate any applicable federal, state, or local law.

Job Tags

Similar Jobs