Sr. Associate, SW Eng

Northern Trust Corp; Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Northern Trust is seeking a skilled data engineering professional in Bengaluru to design and implement large-scale data warehouse solutions, optimize SQL, and develop ETL/ELT processes for trading applications. The role emphasizes cross-functional leadership, platform transformation, and advanced data architectures.

Ideal candidates have experience with Snowflake/Databricks, Python, and BI tools like Power BI or Tableau, along with cloud exposure (Azure/AWS/GCP) and Agile practices.

Qualifications

• 5 years of experience in large data warehousing projects, implementing data warehouses, data marts, ETL, BI solutions etc.
• Understanding of star and snowflake schemas, building facts, dimensions, implementing SCD, various types of facts and dimensions etc.
• Familiarity with data architectures, data lake, data lakehouse, medallion architecture etc.
• Strong experience in data engineering, ETL/ELT
• Strong experience with RDBMS, writing complex SQL and SQL Optimization
• Working Experience in Snowflake or Databricks
• Working experience in Python.
• Experience with scheduling and batch orchestration tools like Control-M
• Exposure to Data Visualization tools like Power BI or Tableau
• Experience with cloud computing platforms such as Azure, AWS, or GCP.
• Familiarity with Agile development methodologies
• Exposure to Gen and Agentic AI tools and solutions

Responsibilities

• Consults with Business Unit and IT management and staff on all phases of the project development cycle.
• Helps to design major systems and their subsystems utilizing a solid understanding of available technology, tools and existing designs.
• Design and develop high-performance programming language components used by trading applications.
• Provide technical expertise to support and enhance core brokerage application.
• Operates independently; has in-depth knowledge of business unit / function As subject area expert, provides comprehensive, in-depth consulting and leadership to team and partners at a high technical level
• Carries out activities that are large in scope, cross-functional and technically difficult.
• Role is balanced between high level operational execution and development, and execution of strategic direction of business function activities.
• Ensure code meets standards and tested appropriately in the platform.
• Be part of platform transformation journey and help in reengineering and improve the current set of applications.

Skills

Data Warehousing

Star/Snowflake Schema

ETL/ELT

SQL & Optimization

Snowflake

Databricks

Python

Control-M

Power BI/Tableau

Cloud Platforms

Agile

Gen AI tools

Agentic AI tools

Tools

Snowflake

Databricks

Control-M

Power BI

Tableau

Azure

AWS

GCP

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.

Major Duties

• Consults with Business Unit and IT management and staff on all phases of the project development cycle.
• Helps to design major systems and their subsystems utilizing a solid understanding of available technology, tools and existing designs.
• Design and develop high-performance programming language components used by trading applications.
• Provide technical expertise to support and enhance core brokerage application.
• Operates independently; has in-depth knowledge of business unit / function As subject area expert, provides comprehensive, in-depth consulting and leadership to team and partners at a high technical level
• Carries out activities that are large in scope, cross-functional and technically difficult.
• Role is balanced between high level operational execution and development, and execution of strategic direction of business function activities.
• Ensure code meets standards and tested appropriately in the platform.
• Be part of platform transformation journey and help in reengineering and improve the current set of applications.

Knowledge/Skills

• 5 Years of experience working in large data warehousing projects, implementing data warehouses, data marts, ETL, BI solutions etc.
• Understanding of star and snowflake schemas, building facts, dimensions, implementing SCD, various types of facts and dimensions etc.
• Familiarity with data architectures, data lake, data lakehouse, medallion architecture etc.
• Strong experience in data engineering, ETL/ELT
• Strong experience with RDBMS, writing complex SQL and SQL Optimization
• Working Experience in Snowflake or Databricks
• Working experience in Python.
• Experience with scheduling and batch orchestration tools like Control-M
• Exposure to Data Visualization tools like Power BI or Tableau
• Experience with cloud computing platforms such as Azure, AWS, or GCP.
• Familiarity with Agile development methodologies
• Exposure to Gen and Agentic AI tools and solutions

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

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 reasonable accommodations to individuals with 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. This includes human resources' decisions relating to recruitment, terms and conditions of employment, transfers, promotions, access to education and training, and learning and development.

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.

EEO Know Your Rights (U.S.)