Associate Consultant

Northern Trust
Bengaluru
Workplace: OnsiteFull timeFunction: Data Analytics & Business IntelligenceExperience: 4+ yearsEducation: mastersSkills: ["Analytical skills","Consultative approach","Communication","Judgment","Attention to detail"]

Support Securities Lending front office teams with client reporting, internal MI statistics, and NT & Borrower performance analysis. Coordinate with account/relationship managers and trading desk stakeholders to assess securities lending fee/revenue estimates for new prospects, RFP/RFI, and existing clients. Build and analyze risk and business reports using Access/SQL/Power BI and develop reports with SQL/Power BI/VBA, while handling inquiries and assigned projects.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Northern Trust
Northern Trust
1 day ago

Associate Consultant

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 5 hours agoStatus: Live
Reposted: similar role first listed 1 month ago

Job Summary

Support Securities Lending front office teams with client reporting, internal MI statistics, and NT & Borrower performance analysis. Coordinate with account/relationship managers and trading desk stakeholders to assess securities lending fee/revenue estimates for new prospects, RFP/RFI, and existing clients. Build and analyze risk and business reports using Access/SQL/Power BI and develop reports with SQL/Power BI/VBA, while handling inquiries and assigned projects.
Location: Bengaluru
Workplace: Onsite
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence
Seniority: Mid level

Key Responsibilities

  • •Support Securities Lending front office teams with client reporting, internal MI statistics, and NT & Borrower performance analysis.
  • •Coordinate with account/relationship managers, equity and fixed income trading desk teams, and stakeholders on fee/revenue estimates for prospects and RFP/RFI work.
  • •Work with Risk, Compliance, Operations, and Short Duration Fixed Income teams to produce risk-related reports for Securities Lending.
  • •Review and generate daily/weekly/monthly BAU reports, including retrieving data via SQL queries.
  • •Recommend process improvements using root-cause analysis and respond to internal and external inquiries.

Key Requirements

  • •4+ years of relevant experience and ability to analyze and interpret queries/tables in Access/SQL/Power BI.
  • •Proficient knowledge of Excel macros, MS Access, SQL, and Power BI.
  • •Expected to work and review daily/weekly/monthly BAU reports and retrieve data by writing SQL queries.
  • •Graduate or Postgraduate (MBA or equivalent).
  • •Securities Lending/portfolio management/database management experience is preferred; open to shifts as per business requirements.
Experience:4+ yearsSecurities lendingPortfolio managementDatabase management
Education:Master's
Skills:Analytical skillsConsultative approachCommunicationJudgmentAttention to detail
Tech Stack:SQLAccessPower BIExcel macrosVBAMS Access

Company Brief

Northern Trust
Global financial services firm providing wealth management, asset servicing, asset management, and banking solutions to institutions, corporations, and affluent individuals, with a focus on custody, investment management, and technology-driven services.
Industry: Asset Management
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: Chicago, United States
Founded: 1889
Glassdoor
Glassdoor: 3.9
WebsiteLinkedIn