Sr. Associate, SW Eng

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.