Lead Arch Solutions

Northern Trust

Confirmed live yesterday High trust

Quick summary

Work type
On-site
Location
Chicago, IL
Salary
$114,500–$194,700 / yr
Posted
2 days ago
Freshness
Confirmed live yesterday

Market check

Salary context

Below market

How this pay compares to similar roles

Similar $182k
This role $155k
$101k most similar roles pay here $238k

This role pays less than 75% of similar roles. Most pay $154,475–$208,883 — the shaded band above. At the midpoint, this role pays about $155k versus about $182k for comparable roles.

Based on 240 similar postings.

Employer

About Northern Trust

Northern Trust is a leading provider of wealth management, asset servicing, asset management, and banking services to corporations, institutions, and high-net-worth individuals. Industry: Financial Services & Asset Management

Northern Trust currently has 48 open roles on FindRole.

Listed pay typically runs $114,500–$194,700 across 43 roles with salary data.

Most-posted roles

View all roles at Northern Trust

At a glance

TL;DR · Lead Arch Solutions

Lead, Arch Solutions joins the Corporate Architecture team to design, build, and operate secure, scalable cloud data solutions across Corporate Services. This role involves translating business requirements into production-ready data products for analytics, reporting, and advanced use cases while modernizing legacy platforms through reusable engineering patterns and automated delivery. The candidate will develop batch and near-real-time pipelines, implement lakehouse and warehouse models using Bronze, Silver, and Gold layers, and build metadata-driven frameworks. Key technical requirements include expertise in Azure Data Factory, Azure Databricks, Azure Data Lake Storage Gen2, Spark, Python, SQL, and Delta Lake. The role also requires proficiency in ETL/ELT patterns, CI/CD via tools like Azure DevOps or GitHub Actions, and infrastructure-as-code using Terraform or Bicep to solve complex data integration and governance challenges within the corporate service domain.

What you'll do

  • Translate business requirements into functional and non-functional data specifications for production-ready products.
  • Design and implement scalable batch and near-real-time data pipelines to ingest, transform, and validate data.
  • Build cloud-native solutions using Azure Data Factory, Databricks, Spark, Python, and SQL.
  • Develop lakehouse and warehouse solutions using Bronze/Silver/Gold layers and dimensional or Data Vault modeling.
  • Create reusable, metadata-driven frameworks and parameterized pipelines to reduce duplication and ensure consistency.
  • Build automated unit, integration, regression, and data-validation tests in coordination with quality teams.
  • Implement CI/CD and infrastructure-as-code practices for repeatable deployments across all environments.

What we're looking for

  • Proven expertise in designing, developing, and supporting enterprise-grade data pipelines and analytics platforms in Azure.
  • 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 reusable component development.
  • Experience building relational, dimensional, and lakehouse data models using star schemas and conformed dimensions.
  • Hands-on experience with relational, analytical, columnar, and NoSQL technologies such as Oracle, PostgreSQL, Azure SQL, or Snowflake.
  • 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.
  • Work Authorization.

More like this

Similar roles

Senior Data Engineer

CoStar Group

Richmond, VA 22 days ago $133,000$172,000
SQL Python Scala C#/.NET Databricks Spark Snowflake BigQuery Redshift Airflow dbt Kafka AWS Azure GCP Terraform CI/CD ETL ELT Delta Lake Apache Iceberg Apache Hudi Fivetran Debezium Great Expectations S3 Glue EMR Lambda
5+ yrs exp

Lead Solutions Architect

Booz Allen Hamilton

Atlanta, GA 10 days ago $112,800$257,000
Azure SQL Java Python C# .NET Scala Microservices Containerization DevSecOps Data Pipelines Relational Databases Event-Driven Architecture System Design
6+ yrs exp

Lead Platform Engineering

MongoDB

Gurugram, India 51 days ago
Go AWS Kubernetes Crossplane Terraform Helm Drone Prometheus Grafana OpenTelemetry CI/CD Linux TCP/IP OAuth OIDC MongoDB Distributed Systems
5+ yrs exp Hybrid

Lead II Software Development

S&P Global

New York, NY 36 days ago $125,000$155,000
AWS .NET C# Angular SQL Server RESTful APIs Microservices CI/CD Terraform Docker Kubernetes GitHub GitLab Splunk JavaScript RAG MQ Event-driven Architecture
10+ yrs exp Hybrid

Lead Engineering

MongoDB

Gurugram, India 101 days ago
Distributed Systems Python Golang Java Rust Kubernetes Containerization AI Frameworks MongoDB Data Processing Monitoring Operations
8+ yrs exp Hybrid

Lead Materials Associate

Anduril Industries

Costa Mesa, CA 72 days ago
WMS Lean Manufacturing 6-Sigma 5S AS9100 OSHA Critical Path Analysis Material Management Office
3+ yrs exp