Lead, Data Engineer

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.

The Data Engineer will be on the Technology Data and Analytics team, who will work on the collecting, storing, processing, and analyzing multiple sets of data from multiple data sources. The primary focus will be on choosing optimal solutions to use for these purposes, then maintaining, implementing, and monitoring them. You may also be responsible for integrating them with the architecture used across the company.

Responsibilities

- Selecting and integrating any Data tools and frameworks required to provide requested capabilities

- Implementing ETL process when importing data from existing data sources and processing that data

- Create solutions for timely data provisioning and publishing, including real-time

- Work with data suppliers, data mesh, and data consumers to conform with standards and business requirements

- Monitoring performance and advising any necessary infrastructure changes

- Building data ingestion processes

- Coding data transformations in SQL and/or python

- Troubleshoot/correct any data process bugs/defects

- Maintain data processes and documentation

- Lead/mentor junior data team members

- Implementing data retention policies

- Implementing data governance policies

Skills and Qualifications

- Bachelor’s or master’s degree in computer/data science technical or related experience.

- 10+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, and ETL and data ingestion protocols).

- Expert with SQL Server, Oracle, Azure ADLS, Synapse, Databricks, Snowflake

- Experience with building python API and document processing programs

- Expert with T-SQL, Spark SQL and PLSQL

- Extensive experience with integration of data from multiple data sources

- Knowledge of various ETL techniques and frameworks

- Experience in team management, communication, and presentation.

- Experience with Azure (ADF, ADLS, Synapse) a plus

- Experience with Collibra and/or other Data governance tools a plus

- Experience with Data Mesh and data platform modernization a plus

Salary Range:

Salary range is a good faith estimate of base pay. Northern Trust provides a comprehensive benefits package including retirement benefits (401k and pension), health and welfare benefits (medical, dental, vision, spending accounts and disability), paid time off, parental and caregiver leave, life & accident insurance, and other voluntary and well-being benefits. Northern Trust also provides a discretionary bonus program that may include an equity component.

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 MyHRHelp@ntrs.com.

 
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.