Data Engineer

Northern Trust

Chicago, IL

Full Time

Senior

96k-162k

about 1 month ago

Job Description

About the Role

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.

Key Responsibilities

Selecting and integrating any Data tools and frameworks required to provide requested capabilities
Implementing ETL process when importing data from existing data sources
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
Innovate, problem-solve, and exhibit an owner-mindset

Requirements

Bachelor's or master's degree in computer or data program or related experience
10+ years of direct relational, dimensional, and/or analytic experience (using RDBMS, dimensional, and ETL and data ingestion protocols)
Expert with SQL Server, Azure ADLS, Synapse, Databricks, Snowflake, Oracle and other similar platforms
Experience with building python API and document processing programs
Expert with T-SQL, Spark SQL and PLSQL and other similar languages
Experience with integration of data from multiple data sources
Knowledge of various ETL techniques and frameworks
Experience in team environment, communication, and presentation

Nice to Have

Experience with Data Mesh and data platform modernization
Experience with Azure (ADF, ADLS, Synapse)
Experience with Collibra and/or other Data governance tools

Qualifications

Educational background in computer or data-related fields
Significant experience in data engineering and related technologies

Benefits & Perks

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
Discretionary bonus program that may include an equity component

Working at Northern Trust

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. We value an inclusive workplace and understand flexibility means different things to different people.

Apply Now