Assct Spclst, Data Analytics

085 Northern Operating Srvs Pvt Ltd; Bengaluru; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

Northern Trust in Bengaluru is seeking an experienced data analytics professional to design and deliver enterprise-grade BI/AI solutions within NTAM, focusing on Power BI reports, semantic models, and scalable data pipelines.

The role combines BI engineering with data engineering and applied ML, requires leadership, deep SQL and Python skills, and allows you to influence analytics across banking domains while collaborating with global teams.

Qualifications

• 10+ years of hands-on experience delivering AI/ML, BI and analytics solutions in enterprise or consulting environments.
• Strong banking or financial services domain experience (risk, finance, operations, client reporting, etc.).
• Expert-level SQL skills — advanced joins, CTEs, window functions, aggregations, and performance tuning.
• Hands-on knowledge of Python for analytics / ML and AI use cases.
• Strong proficiency in Microsoft Power BI, including DAX, Power Query (M), semantic modeling, and visualization best practices.
• Experience with Direct Query sources such as Snowflake, Azure SQL, or Synapse Analytics.
• Solid understanding of Power BI Service artifacts (datasets, dataflows, gateways, RLS, deployment pipelines).
• Understanding of security models relevant to banking: RBAC concepts, least privilege, auditability, and sensitive data handling.
• Working knowledge of Microsoft Fabric concepts and modern analytics architectures.
• Ability to work independently as a technical lead, solve ambiguous problems, and own solutions end-to-end.
• Strong communication skills — ability to engage effectively with both technical and non-technical stakeholders.
• Experience supporting self-service BI models and governed analytics patterns.
• Knowledge of prompt and context engineering (preferably in PBI copilot).

Responsibilities

• Apply working knowledge of data engineering and AI/ML (Python/R or similar) for targeted use cases such as forecasting, anomaly detection, and segmentation.
• Design and develop Power BI reports, dashboards, and executive scorecards aligned with business and regulatory requirements.
• Lead the design, build, and optimization of semantic models (tabular) using best practice data modeling and efficient DAX measures.
• Write, debug, and tune advanced SQL queries across platforms such as Snowflake, Azure SQL, or other enterprise data stores.
• Help drive AI driven insights generation and advanced analytics using Machine Learning techniques.
• Implement and optimize Direct Query and hybrid models, focusing on performance, query folding, and scalability.
• Collaborate with solution architects, data engineers, analysts, and business users to gather requirements and deliver end to end analytics solutions.
• Support Power BI service operations, including workspace management, publishing artifacts, refresh strategies, and Row Level Security (RLS) implementation.
• Define and promote BI engineering standards, performance best practices, and documentation for consistent offshore delivery.
• Troubleshoot and resolve complex data, model, and report level issues.
• Provide guidance, knowledge transfer, and informal mentoring to junior BI developers as needed.
• Stay current with Power BI, Microsoft Fabric, and analytics platform advancements and recommend improvements.

Skills

AI/ML

BI analytics

SQL expert

Python

Power BI

Direct Query

Snowflake

Azure SQL

RBAC security

Fabric knowledge

Technical lead

Stakeholder comms

Tools

Snowflake

Azure SQL

Synapse Analytics

Power BI Service

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

We are seeking an experienced data analytics resource to support NTAM’s key analytics initiatives with a strong focus on delivering robust, scalable, and user-centric Machine Learning, Business Intelligence and data science solutions. This role will work closely with architects, data engineers, and business stakeholders to design and develop enterprise grade reports, dashboards, semantic models, and predictive models. This resource will also perform advanced SQL based data preparation and optimization, while applying data engineering and AI/ML techniques to enhance insights. The role is primarily BI engineering focused, with data engineering and applied ML/AI responsibilities, and is designed for a senior individual contributor who can operate independently, own requirements end to end and provide technical leadership within a global delivery model. This role is ideal for a hands‑on resource who is strong in semantic modeling, performance optimization, and stakeholder engagement, and can adapt quickly across complex, multidomain analytics initiatives in the banking and financial services space. Prior Asset Management experience and a working knowledge of financial data will also be critical.

Responsibilities

• Apply working knowledge of data engineering and AI/ML (Python/R or similar) for targeted use cases such as forecasting, anomaly detection, and segmentation.
• Design and develop Power BI reports, dashboards, and executive scorecards aligned with business and regulatory requirements.
• Lead the design, build, and optimization of semantic models (tabular) using best practice data modeling and efficient DAX measures.
• Write, debug, and tune advanced SQL queries across platforms such as Snowflake, Azure SQL, or other enterprise data stores.
• Help drive AI driven insights generation and advanced analytics using Machine Learning techniques
• Implement and optimize Direct Query and hybrid models, focusing on performance, query folding, and scalability.
• Collaborate with solution architects, data engineers, analysts, and business users to gather requirements and deliver end to end analytics solutions.
• Support Power BI service operations, including workspace management, publishing artifacts, refresh strategies, and Row Level Security (RLS) implementation.
• Define and promote BI engineering standards, performance best practices, and documentation for consistent offshore delivery.
• Troubleshoot and resolve complex data, model, and report level issues.
• Provide guidance, knowledge transfer, and informal mentoring to junior BI developers as needed.
• Stay current with Power BI, Microsoft Fabric, and analytics platform advancements and recommend improvements.

Required Skills

• 10+ years of hands‑on experience delivering AI/ML, BI and analytics solutions in enterprise or consulting environments.
• Strong banking or financial services domain experience (risk, finance, operations, client reporting, etc.).
• Expertlevel SQL skills — advanced joins, CTEs, window functions, aggregations, and performance tuning.
• Hands‑on knowledge of Python for analytics / ML and AI use cases.
• Strong proficiency in Microsoft Power BI, including DAX, Power Query (M), semantic modeling, and visualization best practices.
• Experience with Direct Query sources such as Snowflake, Azure SQL, or Synapse Analytics.
• Solid understanding of Power BI Service artifacts (datasets, dataflows, gateways, RLS, deployment pipelines).
• Understanding of security models relevant to banking: RBAC concepts, least privilege, auditability, and sensitive data handling.
• Working knowledge of Microsoft Fabric concepts and modern analytics architectures.
• Ability to work independently as a technical lead, solve ambiguous problems, and own solutions end-to-end.
• Strong communication skills — ability to engage effectively with both technical and non‑technical stakeholders.
• Experience supporting self‑service BI models and governed analytics patterns.
• Knowledge of prompt and context engineering (preferably in PBI copilot).

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. Looking for greater? You found it. A global financial leader with more than 22,000 employees in 23 locations worldwide, Northern Trust empowers our employees to achieve more than just business goals. Our focus on work-life balance, career mobility and unique opportunities are just a few of the reasons we’ve been named one of the world’s most admired companies.

Terms and Conditions

Terms and Conditions Candidate Privacy Notice California Applicant Privacy Notice Pay Transparency Nondiscrimination Provision (U.S) Transparency in Coverage Disclosure - North America Northern Trust is committed to working with and providing adjustments to individuals with health conditions and disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the employment process, please email our HR Service Center or call 1-800-807-0302 (North America), [phone] (Asia Pacific), 1800-425-0333 (India), [phone] (Europe, Middle East and Africa) and let us know the nature of your request and your contact information.

APAC/INDIA EEO STATEMENT

It is the policy and practice of Northern Trust to provide equal employment opportunities to all employees and applicants. Northern Trust does not discriminate on the basis of race, colour, religion or belief, nationality, ethnic or national origin, sex, marital status, sexual orientation, disability or age. All employment decisions will be made in a non-discriminatory manner in accordance with our obligations under the law and codes of practice. This includes human resources’ decisions relating to recruitment, terms and conditions of employment, transfers, promotions and access to learning and development.

Canada EEO STATEMENT

Northern Trust is an Equal Opportunity Employer. Hiring and other employment decisions at Northern Trust are made without regard to race, colour, religion, sex, ancestry, national origin, ethnic origin, age, disability, citizenship, veteran status, sexual orientation, record of offences, marital status, family status, or any other characteristic protected by federal, provincial, or local law, regulation, or ordinance.

EMEA EEO STATEMENT

It is the policy and practice of Northern Trust to provide equal employment opportunities to all employees and applicants. Northern Trust does not discriminate on the basis of race, colour, religion or belief, nationality, ethnic or national origin, sex, marital status, sexual orientation, disability or age. All employment decisions will be made in a non-discriminatory manner in accordance with our obligations under the law and codes of practice. This includes human resources’ decisions relating to recruitment, terms and conditions of employment, transfers, promotions and access to learning and development.

USA EEO STATEMENT

It is the policy of The Northern Trust Company to afford equal opportunity in all phases of employment without regard to an individual's age, race, color, religion, creed, gender, national origin, citizenship status, marital status, pregnancy, sexual orientation, gender identity, gender expression, genetic tests and information, physical or mental disability, protected veteran status or any other legally protected status.