Senior Lead Data Engineer: Oracle to Snowflake on Azure

Northern Trust Corp.; Chicago (IL); On-site; USD 115,000 - 195,000; Full time

Benefits offered by this job

401k and pension

Health and welfare benefits

Discretionary bonus

Job summary

Northern Trust is seeking an accomplished data engineering leader to architect and deliver scalable data platforms on Oracle/Snowflake/Azure. You will mentor engineers, drive modernization efforts, and collaborate with product stakeholders to ensure reliable, high-performance data solutions.

The role emphasizes hands-on design, architecture, and governance across data pipelines, APIs, and near real-time data synchronization, with a focus on production reliability and strategic data initiatives.

Qualifications

• 15+ years of experience in Data Engineering or Software Engineering.
• Strong expertise in database design, performance tuning, and data modeling.
• Hands-on experience with Snowflake, Azure, Data Warehousing, ETL/ELT, and cloud data platforms.
• Experience with Oracle-to-Snowflake migration and data modernization initiatives.
• Experience with Astronomer Airflow.
• Experience with Kafka, MQ, CDC, or similar event-driven technologies.
• Experience with REST APIs, JSON, and integration patterns.
• Unix Shell Scripting and Control-M (or equivalent scheduling tools).
• Azure DevOps, Git, CI/CD, and Agile delivery practices.
• Strong leadership, problem-solving, and communication skills.

Responsibilities

• Lead the architecture, design, and implementation of data engineering solutions leveraging Oracle, Snowflake, and Azure.
• Drive Oracle modernization and migration initiatives, including data movement, ETL/ELT, CDC, and cloud-based data platforms.
• Provide technical leadership, mentor engineers, conduct code reviews, and establish engineering best practices.
• Build and support scalable data pipelines, APIs, and near real-time data synchronization solutions.
• Collaborate with product owners, architects, and business stakeholders to deliver high-quality solutions.
• Drive performance tuning, operational excellence, production support, and reliability improvements.

Skills

Data engineering

Leadership

Problem-solving

Communication

Data modeling

Performance tuning

Mentoring

Tools

Snowflake

Azure

Oracle

Astronomer Airflow

Kafka

REST APIs

JSON

Unix Shell Scripting

Control-M

Azure DevOps

Git

CI/CD

Job description

Northern Trust is seeking an accomplished data engineering leader to architect and deliver scalable data platforms on Oracle/Snowflake/Azure. You will mentor engineers, drive modernization efforts, and collaborate with product stakeholders to ensure reliable, high-performance data solutions.

The role emphasizes hands-on design, architecture, and governance across data pipelines, APIs, and near real-time data synchronization, with a focus on production reliability and strategic data initiatives.