Associate, 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.
- Operates independently; has in-depth knowledge of business unit / function
- 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
- Provide L3 support and develop deep understanding of the landscape, production management and ITIL fundamentals

Knowledge/Skills
- A minimum of 3-6 years of experience in IT, with at least 2+ Years of experience working in large data warehousing projects, implementing data warehouses, data marts, ETL, BI solution 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 engineering, ETL/ELT
- Experience with Informatica, DataStage or equivalent tools
- Strong Experience in Snowflake Cloud DB
- Experience with Snowflake data ingestion, streams, tasks, secured views, stored procedures etc.
- Experience in RDBMS, writing complex SQL and performance tuning of queries
- Experience with Python
- Experience in Azure cloud services such as Azure ADF, Azure DevOps, LogicApp, Azure Functions etc.
- Experience in managing data security, access controls, and designing secure data solutions.
- Experience with Agile development methodologies and a track record of successfully delivering projects in an Agile environment.
- Familiarity with data visualization tools such as Power BI etc.
- Ability to work effectively with end users to define requirements.
- Understanding of financial market domain, market participants, securities, asset classes, mutual funds, ETF etc.
- Strong written and verbal communication skills, with the ability to communicate effectively with technical and non-technical stakeholders.

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.

Reasonable accommodation


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.