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 Wealth Management Data Platform is going through an extensive Data Modernization moving from On-prem infrastructure to Cloud Technologies for both Self-Serve Analytics and operational runtime needs.

We're seeking Data Engineers who will help us simplify our data landscape and solve data problems using the Lakehouse Platform.  You will work with business/ product and engineering teams, to understand their data needs and optimal data delivery mechanisms. You will then build new data pipelines and data products that help deliver meaningful data digitally to clients and their wealth advisors.

Your daily work will involve:

Design/Development: You will design and support the business’s database and table schemas for new and existing data sources for the lakehouse. Create and support the ETL in order to facilitate the movement of data into the Lakehouse.

Through your work you will ensure

The data platform is scalable for large amounts of data ingestion and processing without service degradation.Processes are built for monitoring and optimizing performanceImplement Chaos Engineering practices and measures that allow the end-to-end infrastructure to function as expected, even if individual components fail

Collaboration: You will be collaborative - working closely with Product Owners, application engineers, and other data consumers within the business in an attempt to gather and deliver high quality data for business-cases. Work closely with other disciplines/departments and teams across the business in coming up with simple, functional, and elegant solutions that balance data needs across the business

Analytics: You will play an analytical role in quickly and thoroughly analyzing business requirements and subsequently translating the emanating results into good technical data designs. Document the data solutions, develop, and maintain technical specification documentation for all reports and processes.

Skills you MUST have:

4+ years proven ability of professional Data Development experience3+ years proven ability of developing with Databricks or Hadoop/HDFS3+ years of experience with PySpark/Spark3+ years of experience with SQL3+ years of experience developing with either Python, Java, or ScalaFull understanding of ETL concepts and Data Warehousing conceptsData modeling and query optimization skills, implementation experience of Data Vault and Star SchemaExperience with CI/CDExperience with version control softwareStrong understanding of Agile Principles (Scrum)Experience with AzureExperience with Databricks Delta Tables, Delta Lake, Delta Live TablesBachelor’s Degree (Computer Science, Management Information Systems, Mathematics, Business Analytics, or STEM)

Bonus Points For Experience In The Following

Proficient with Relational Data ModelingExperience with Python Library DevelopmentExperience with Structured Streaming (Spark or otherwise)Experience with Kafka and/or Azure Event HubExperience with GitHub SaaS / GitHub ActionsExperience with SnowflakeExposure to BI Tooling (Tableau, Power BI, Cognos, 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 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.