Northern Trust

Associate Consultant, Total Portfolio Solutions

Northern Trust

full-time

Posted on:

Location Type: Office

Location: ChicagoArizonaIllinoisUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $55,200 - $88,400 per year

Tech Stack

About the role

  • 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

  • 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
  • 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
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