Business Intelligence Consultant

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

Job summary

Northern Trust is hiring an Associate Consultant to design and maintain data-driven reporting and analytics solutions using Power BI in Bengaluru. The role emphasizes transforming business requirements into scalable BI designs with strong data modeling, ETL, and advanced analytics skills.

The successful candidate will collaborate with stakeholders to deliver performant dashboards, enforce data governance, and optimize existing reports for accuracy and speed.

Qualifications

• Experience in designing and developing data-driven reporting and analytics solutions.
• Strong ability to translate business requirements into scalable BI solutions.
• Proficient in data modeling, ETL, and DAX calculations.

Responsibilities

• Design, develop, and deploy Power BI dashboards meeting business needs and performance targets.
• Build robust data models and perform ETL using Power Query and related tools.
• Create complex DAX measures, calculated columns, and KPIs for advanced analytics.
• Engage with stakeholders to gather requirements and translate them into technical specs.
• Maintain data governance, including Row-Level Security and access controls in Power BI Service.
• Monitor and optimize reports for performance and usability.

Skills

Power BI

Data analytics

Stakeholder communication

Problem solving

Tools

MS SQL Server

Azure SQL

Snowflake

Power Query

Job description

Associate Consultant

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

Role Overview

The Consultant will be responsible for designing, developing, and maintaining data-driven reporting and analytics solutions using Power BI. The role requires strong technical expertise in data modeling, ETL processes, and advanced analytics, along with the ability to collaborate with business stakeholders to translate requirements into scalable and performant BI solutions.

Key Responsibilities

1. Reporting & Dashboard Development Design, develop, and deploy interactive and visually compelling dashboards using Power BI. Ensure dashboards meet business requirements, usability standards, and performance expectations.
2. Data Modeling & ETL Extract, transform, and load (ETL) data using Power Query and other tools. Develop robust and scalable data models to support reporting and analytics needs.
3. DAX & Advanced Analytics Develop complex DAX measures, calculated columns, and KPIs to support advanced analytical requirements. Optimize calculations for performance and accuracy within Power BI models.
4. Stakeholder Engagement Collaborate with business stakeholders to gather requirements and translate them into technical specifications. Provide insights and recommendations based on data analysis to support decision-making.
5. Data Governance & Security Ensure data integrity, quality, and consistency across reports and dashboards. Implement and maintain Row-Level Security (RLS) and manage access controls within Power BI Service.
6. Performance Optimization & Support Monitor and optimize existing reports for performance, scalability, and usability. Troubleshoot data, performance, and visualization issues in Power BI solutions.

Required Skills & Qualifications

Experience For internal applications - 24 months as Associate Consultant 8-10 years of experience in Business Intelligence / Data Analytics roles.

BI Tools

• Power BI Desktop
• Power BI Service
• Power BI Report Server

Technical Skills

• SQL
• DAX (Data Analysis Expressions)
• Power Query (M language)
• Data Platforms

Experience working with relational and/or multidimensional databases such as:

• MS SQL Server
• Azure SQL
• Snowflake

Key Competencies

• Strong analytical and problem-solving skills
• Effective stakeholder communication and requirement translation
• Attention to detail and data accuracy
• Ability to work independently and collaboratively in a team environment

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.

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.

Experience Level Mid Level