Lead, SW Eng

About Northern Trust
Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889.

Northern Trust is proud to provide innovative financial services and guidance to the world's most successful individuals, families, and institutions by remaining true to our enduring principles of service, expertise, and integrity. With more than 130 years of financial experience and over 22,000 partners, we serve the world's most sophisticated clients using leading technology and exceptional service.

Northern Trust is looking for a Developer to join its Global Brokerage team. This individual as part of an Agile development team, will be Responsible for designing, developing, testing and deploying software solutions for Brokerage. Assist with the proposal of new designs and modifications to existing ones to continuously improve performance, functionality, and stability of the system. Works with business leaders and business unit partners to define priorities and deliver custom solutions to solve business problems or address business needs. Acts as a business/technical consultant to other partners and coordinates implementation of new processes and techniques.

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.

Provide technical expertise to support and enhance core data services platform

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
10+ Years of experience working in large data warehousing projects, implementing data warehouses, data marts, ETL, BI solutions etc.

Strong understanding of dimensional design techniques, star and snowflake schemas, building facts, dimensions, implementing SCD, various types of facts and dimensions etc.

Experience in data modeling practices in designing optimized solutions in 3NF, Data Vault and Dimensional models.

Ability to lead the creation and review of reusable, config driven and efficient ETL/ELT pipelines. Ensure that ETL processes are highly optimized for performance, cost-efficiency and scalability

Ability to guide and lead a team of data engineers and drive the implementation of data ingestion, curation and delivery from end to end

Ability to work closely with Data Governance team to ensure compliance, alignment with data governance policies and guidelines, data security, privacy regulations etc. Maintain a strong focus on data quality, data lineage and data access controls.

Strong experience with RDBMS, writing complex SQL and SQL Optimization

Strong and Proven Hands-On Experience in Snowflake Cloud DB, Databricks

Expertise in PL/SQL or equivalent scripting, Unix Shell scripting, Python etc.

Experience with scheduling and batch orchestration tools like Control-M

Experience in Azure cloud services such as Azure ADF, Azure DevOps, Logic App, Azure Functions , Azure Databricks, Azure Storage etc. or equivalent services in AWS or GCP.

Experience in managing data security and designing secure data solutions.

Experience with Agile development methodologies and a track record of successfully delivering projects in an Agile environment.

Experience with data visualization tools such as Power BI, Tableau etc.

Working experience in creating AI/ML solutions

Understanding of Asset Management, Financial Markets, Investment Vehicles, Market Participants, Investment Management and Accounting, ESG Investment etc.

Working With Us
As a Northern Trust partner, greater achievements await. You will be part of a flexible and collaborative work culture in an organization where financial strength and stability is an asset that emboldens us to explore new ideas.

Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to assisting the communities we serve Join a workplace with a greater purpose.

We'd love to learn more about how your interests and experience could be a fit with one of the world's most admired and sustainable companies Build your career with us and apply today. #MadeForGreater

Reasonable accommodation
Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at

We hope you're excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people.

Apply today and talk to us about your flexible working requirements and together we can achieve greater.

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.