
Associate Consultant, Total Portfolio Solutions
Northern Trust
full-time
Posted on:
Location Type: Office
Location: Chicago • Arizona • Illinois • United States
Visit company websiteExplore more
Salary
💰 $55,200 - $88,400 per year
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