Associate Consultant, Total Portfolio Solutions

Northern Trust

. Responsible for investment data management that will provide clients with the holistic data sets they need to fulfil their various stakeholder requirements.

Posted 3/11/2026full-timeChicago • Arizona, Illinois • 🇺🇸 United StatesJuniorMid-Level💰 $55,200 - $88,400 per yearWebsite

Tech Stack

Tools & technologies

PythonVBA

About the role

Key responsibilities & impact

Responsible for investment data management that will provide clients with the holistic data sets they need to fulfil their various stakeholder requirements.
Assist in researching solutions for data challenges for institutional clients.
Acts as point of initial entry for all investment data.
Includes entry of investment transactions (typically statement-based for alternative assets; file-based for public markets).
Includes investment valuations (typically statement-based for alternative assets; file-based for public markets).
Manager Estimates, Plan Income / Expense Items, Plan Contributions / Spending Withdrawals, Underlying Manager Exposure Data, Benchmark Data.
Responsible for preparing all investment reconciliations.
Includes reconciliation of cash, positions, performance, transactions, alternative investment metrics (unfunded commitment, etc.).
Responsible for initial and/or secondary review of NAV, allocation and underlying client performance for alternative investments.
Participates in ongoing process improvements based on specialized skills, knowledge, and experience.

Requirements

What you’ll need

A College or University degree, preferably in Finance, Accounting, Mathematics, Economics or a related field.
Minimum 1 year of industry experience.
Interest in pursuing a higher degree or certification such as: CFA, CAIA, CIPM, CPA, MBA.
Knowledge of the investment industry, including markets and instruments.
Basic investment concepts knowledge: IRR, time-weighted return, NAVs, accruals, 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.
Understanding of instances when performance issues need to be escalated to a supervisor.
Ability to prioritize, multi-task, and perform effectively under deadlines.
Commitment to project success as it may require working unconventional hours during critical project phase.
Functional /industry knowledge of and experience with complex asset allocators such as endowments, foundations, family offices, institutional asset managers, pension funds or sovereign wealth funds.
Understanding of alternative investment custodians, administrators, and service providers.
Work experience in one of the following: Alternative Asset Operations, Performance Measurement, Investment Accounting.
Technical skills / systems knowledge (Investment Administration & Portfolio Analytics Platforms).
Experience using VBA, Python or other programming language to format large data sets.
Orientation towards operational process improvement.
Client servicing experience.
Ability to work closely and collaborate with internal stakeholders.

Benefits

Comp & perks

Health and welfare benefits (medical, dental, vision, spending accounts and disability)
Retirement benefits (401k and pension)
Paid time off
Parental and caregiver leave
Life & accident insurance
Other voluntary and well-being benefits
Discretionary bonus program that may include an equity component

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

investment data managementinvestment transactionsinvestment valuationsNAVaccrualsExcel Pivot TablesExcel ChartsV-lookupVBAPython

Soft Skills

analytical skillsability to prioritizemulti-taskingperforming under deadlinescommitment to project successclient servicingcollaboration with stakeholdersprocess improvement

Certifications

CFACAIACIPMCPAMBA