Northern Trust Logo

Northern Trust

Lead, Arch Solutions

Posted 18 Days Ago
Be an Early Applicant
Hybrid
Chicago, IL, USA
115K-195K Annually
Entry level
Hybrid
Chicago, IL, USA
115K-195K Annually
Entry level
Design, build, and operate secure Azure data solutions, including batch and near-real-time pipelines, lakehouse and warehouse models, data quality frameworks, automated testing, CI/CD, and infrastructure-as-code. Partner with business, architecture, analytics, security, and engineering stakeholders to translate requirements into production-ready data products. Support platform modernization, reusable engineering patterns, governance, deployment automation, Agile delivery, and production operations.
The summary above was generated by AI

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.


Job Description 

We are seeking an experienced Azure Data Engineer to design, build, and operate secure, scalable, and reliable cloud data solutions across Corporate Services. As a key member of the Corporate Architecture team, this role will translate business requirements into production-ready data products that support analytics, reporting, and advanced data use cases. 

The successful candidate will combine strong software engineering and data architecture skills with hands-on expertise in Azure Data Factory, Azure Databricks, Azure Data Lake Storage Gen2, Spark, Python, and SQL. The role will contribute to the modernization of legacy data platforms through reusable engineering patterns, automated delivery, strong data governance, and operational excellence. 

 

Responsibilities 

  • Partner with business, architecture, analytics, security, and engineering stakeholders to translate business needs into clear functional and non-functional data requirements.  
  • Design and implement scalable batch and near-real-time data pipelines that ingest, transform, validate, and publish structured and unstructured data.  
  • Build cloud-native Azure data solutions using Azure Data Factory, Azure Databricks, Azure Data Lake Storage Gen2, Spark, Python, SQL, and related services.  
  • Develop lakehouse and data warehouse solutions using layered data patterns such as Bronze, Silver, and Gold, with appropriate dimensional, normalized, or Data Vault modeling techniques. 
  • Evangelize modern data modeling and data quality practices 
  • Develop reusable, metadata-driven frameworks and parameterized pipelines that reduce duplication and improve delivery consistency.   Build automated unit, integration, regression, and data-validation tests in partnership with quality-engineering teams.  
  • Implement CI/CD and infrastructure-as-code practices for repeatable deployment across development, test, and production environments. 

Required Skills 

  • Proven expertise in designing, developing, and supporting enterprise-grade data pipelines and analytics platforms in Azure.  
  • Strong hands-on experience with Azure Data Factory, Azure Databricks, Azure Data Lake Storage Gen2, and Delta Lake.  
  • Advanced proficiency in Python, PySpark, and SQL, including performance tuning and development of reusable data-processing components.  
  • Strong understanding of ETL and ELT patterns, distributed data processing, orchestration, incremental loading, change data capture, and schema evolution.  
  • Experience building relational, dimensional, and lakehouse data models, including star schemas and conformed dimensions.  
  • Hands-on experience with relational, analytical, columnar, and NoSQL technologies such as Oracle, PostgreSQL, Azure SQL, Snowflake, or equivalent platforms.  
  • Experience with Git-based development, automated testing, and CI/CD using Azure DevOps, GitHub Actions, Jenkins, or equivalent tools.  
  • Familiarity with infrastructure-as-code and deployment automation using Terraform, Bicep, ARM templates, or similar technologies.  
  • Experience working in Agile delivery environments and participating in estimation, design reviews, code reviews, release planning, and production support. 

Salary Range:

$114,500 - 194,700 USD

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.


Work Authorization


Applicants must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Northern Trust will not sponsor applicants for U.S. work visa status for this opportunity (no sponsorship is available for H-1B, L-1, TN, O-1, E-3, H-1B1, F-1, J-1, OPT, CPT or any other employment-based visa).


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. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to an inclusive workplace and assisting the communities we serve.


Philanthropy is deeply rooted in Northern Trust’s history and is an essential element of our culture. Employees around the world give their time and talent to work for the greater good of their communities.


Reasonable Accommodation


Northern Trust is committed to working with and providing adjustments to individuals with health conditions and disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at [email protected], or alternatively you can discuss your individual requirements with the recruiter you are working with.


HQ

Northern Trust Chicago, Illinois, USA Office

50 S. La Salle, Chicago, IL, United States, 60603

Northern Trust Naperville, Illinois, USA Office

Naperville, United States

Northern Trust North Chicago, Illinois, USA Office

North Chicago, United States

Similar Jobs

An Hour Ago
Remote or Hybrid
United States
85K-105K Annually
Mid level
85K-105K Annually
Mid level
Artificial Intelligence • Cloud • Payments • Software • Business Intelligence • Generative AI • Automation
Provides consultative pre-sales support for insurance software solutions. Develops product demonstrations, coordinates client site visits, prepares proposals, responds to customer requirements, and collaborates with sales and supporting teams throughout the sales cycle. Uses insurance industry and technology expertise to align client goals with product capabilities and demonstrate business value. Requires up to 25% North American travel.
Top Skills: Ai-Based ProductsApplied EpicSaaS
An Hour Ago
Hybrid
Chicago, IL, USA
125K-125K Annually
Senior level
125K-125K Annually
Senior level
Information Technology • Professional Services • Financial Services
Leads derivatives operations covering futures, options, trade allocation, clearing, physical delivery, exercise and assignment, exceptions, and operational controls. Manages teams, regulatory risk, supervisory processes, stakeholder relationships, metrics, dashboards, automation, process improvements, system implementations, and audit readiness. Partners with clients, risk, compliance, technology, exchanges, and clearing organizations while driving operational change and service quality.
Top Skills: Ai-Enabled Productivity ToolsCme PlatformsConfluenceIce PlatformsJIRAOcc PlatformsPower BISalesforceSQLTableau
2 Hours Ago
Hybrid
Chicago, IL, USA
Internship
Internship
Big Data • Fintech • Information Technology • Business Intelligence • Financial Services • Cybersecurity • Big Data Analytics
Support Argus Advisory consulting engagements for financial services clients through analytics, desktop research, and problem-solving. The internship includes training in financial services, AWS, and technical skills, with opportunities to collaborate with associates and support key client relationships. Candidates will apply quantitative and qualitative analysis, SQL, AWS, SAS, and strong communication skills in a hybrid work environment.
Top Skills: AWSSASSQL

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account