Associate Consultant

Northern Trust; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Northern Trust in Bengaluru seeks a Senior Analyst to support Securities Lending reporting and analytics. You will write SQL queries, build reports in Power BI and VBA, and partner with front office, risk, and operations to deliver timely insights.

The role emphasizes accuracy under pressure, data-driven decision making, and opportunities to grow within a global financial services leader.

Qualifications

• Retrieve data by writing SQL queries and develop reports using Power BI and VBA.
• Analyze BAU reports on daily/weekly/monthly cadence and provide insights.
• Coordinate with front office, Risk, Compliance and Operations on reports for Securities Lending.

Responsibilities

• Review daily/weekly/monthly BAU reports and retrieve data with SQL.
• Work on product-related projects for front office teams.
• Respond to internal/external inquiries and provide information.
• Recommend procedural changes with root cause analysis.

Skills

Excel macros

MS Access

SQL

Power BI

Analytical skills

Education

Graduate or MBA or equivalent

Job description

About Northern Trust

As a global leader in innovative wealth management, asset servicing, asset management and banking services, Northern Trust (Nasdaq: NTRS) is proud to guide the world’s most successful individuals, families, corporations and institutions.

As a global leader in innovative wealth management, asset servicing, asset management and banking services, Northern Trust (Nasdaq: NTRS) is proud to guide the world’s most successful individuals, families, corporations and institutions. Since 1889, we have aligned our efforts with our three guiding Principles That Endure: Service, Expertise, and Integrity. Together, they reflect the three cornerstones of business conduct which we strive to instill in our employees, whom we call partners, and to provide to our clients and the communities we serve worldwide. With more than 135 years of financial experience and over 24,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service. Support the Securities Lending front office teams in all matters relating to client reporting, Internal MI statistics and NT & Borrower performance analysis. Coordinate with Northern Trust Account Managers / Relationship Managers, Global Equity and Fixed Income Trading Desk and other stakeholders to help evaluate Securities Lending fee/revenue estimates for new prospects, RFP, RFI and existing clients. Assisting the company’s bid to expand clientele/business Coordinate with Risk, Compliance, Operations and Short Duration Fixed Income teams in producing various risk related reports for Securities Lending Aptitude in analyzing and interpreting queries/tables in Access/SQL/Power BI to conduct in-depth research. Respond to internal and external inquiries and requests for information. Demonstrates excellent analytical, consultative, communication and judgment skills. Handle projects assigned by the business teams. Understand business need & develop reports using SQL/Power BI/VBA.

Principal Responsibilities

Expected to work and review the daily/weekly/monthly BAU reports; Retrieve data by being able to write SQL queries and hence excellent knowledge or certifications on SQL. Aptitude in analysing and interpreting queries/tables in Access/SQL/Power BI to conduct in-depth research. Work on product related projects assigned by front office teams. Responds to internal and external inquiries and requests for information. Recommend appropriate procedural changes to existing processes to management using root cause analysis. Coordinate with Risk, Compliance, Operations and Short Duration Fixed Income teams in producing various risk related reports for Securities Lending.

Skills / Experience Required

• 24 months as Senior Analyst
• 12 months as Technical Coordinator
• 4 + years of relevant experience
• Proficient knowledge of Excel macros, MS Access, SQL & Power BI
• Graduate or Postgraduate (MBA or equivalent)
• Securities Lending/ Portfolio Management / Database Management experience is preferred
• Mathematically minded individual with strong analytical skills
• Ability to work in pressurized environment and manage priorities effectively
• Highly motivated with strong attention to detail
• Excellent written & verbal communication skills
• Open to work in shifts as per business requirements

Working with Us

As a Northern Trust partner, you will be part of a flexible and collaborative work culture, which has a strong history of financial strength and stability. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to an inclusive workplace and assisting the communities we serve. Philanthropy is deeply rooted in Northern Trust’s history and is an essential element of our culture. Employees around the world give their time and talent to work for the greater good of their communities.

Reasonable Accommodation

Northern Trust is committed to working with and providing adjustments to individuals with health conditions and disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at [e-mail], or alternatively you can discuss your individual requirements with the recruiter you are working with.

About Our Bangalore Office

The Northern Trust Bangalore office, established in 2005, is home to over 5,600 employees. In this stunning office space, we offer fantastic amenities which include our Arrival Hub - Jungle, the GameZone, and the Employee Experience Zone that appeal to both clients and employees. Learn more.