Associate Consultant - Client Solutions, FOS

Northern Trust - Chicago, IL

Full-time - Entry Level

Chicago, IL

10,001+ employees

Real Estate

About the position

The Associate Consultant - Client Solutions at Northern Trust is responsible for managing investment data and providing clients with comprehensive data sets to meet their stakeholder requirements. This role involves assisting in the research of solutions for data challenges faced by institutional clients and requires a strong understanding of investment operations and data management.

Responsibilities

• Acts as point of initial entry for all investment data, including investment transactions and valuations.
• Responsible for preparing all investment reconciliations, including cash, positions, performance, and transactions.
• Import, normalize, and configure large amounts of historical data sets from multiple systems into the FOS technology platform.
• Initial review of NAV, allocation, and underlying client performance for alternative investments.
• Serves as initial reviewer of investment and composite performance calculations, including time-weighted return and IRR calculations.
• Responsible for the input of all historic data entry and initial preparation of all reconciliations during client onboarding.
• Participates in ongoing process improvements based on specialized skills, knowledge, and experience.

Requirements

• Knowledge of the investment industry, including markets and instruments.
• Basic investment concepts knowledge: IRR, time-weighted return, NAVs, accruals, etc.
• Investment operations knowledge: hedge fund accounting, private equity funds, performance reporting, etc.
• Advanced understanding of Microsoft Suite (Excel, Word, PowerPoint, Visio), with particular emphasis on Excel.
• Advanced Excel skills (Excel Pivot Tables, Charts, V-lookup, etc.).
• Analytical skills and ability to prioritize, multi-task, and perform effectively under deadlines.

Nice-to-haves

• Functional/industry knowledge of complex asset allocators such as endowments, foundations, and pension funds.
• Understanding of alternative investment custodians, administrators, and service providers.
• Experience using VBA, Python, or other programming languages to format large data sets.
• Client servicing experience and ability to communicate directly with clients.

Benefits

• Flexible work culture
• Opportunities for professional development
• Commitment to diversity and inclusion
• Access to senior leaders
• Community service involvement