Senior Lead MDM & ETL Engineer

ntrs; Chicago (IL); On-site; USD 115,000 - 195,000; Full time

Job summary

Northern Trust is a global leader in wealth management and financial services. The Sr. Lead Software Engineer will own the Master Data Management data pipeline from source through mastering and downstream distribution, using Azure-based technologies.

The role also emphasizes designing scalable ETL solutions, establishing data quality and validation rules, and ensuring batch processing meets SLAs. You will mentor the ETL team and drive modernization to improve scalability and efficiency.

Responsibilities

• End-to-End Data Pipeline Ownership: Own and maintain accountability for the complete MDM data pipeline, ensuring seamless data flow from source systems through mastering and downstream distribution.
• ETL Solution Design & Transformation Leadership: Lead the design, development, and implementation of scalable ETL solutions, ensuring efficient and reliable data integration processes.
• Data Quality & Validation Framework: Define and oversee data contracts, data quality standards, validation rules, and control frameworks to ensure the accuracy, completeness, and integrity of master data.
• Batch Processing & SLA Management: Own the execution and performance of batch processing operations, ensuring adherence to service level agreements (SLAs) and timely issue resolution.
• Platform Optimization & Modernization: Drive the modernization of ETL capabilities by leading the adoption of Azure-based technologies, improving scalability, performance, automation, and operational efficiency.
• Technical Leadership & Team Development: Provide technical direction, mentorship, and oversight to the ETL team, promoting engineering best practices and continuous improvement.

Job description

Northern Trust is a global leader in wealth management and financial services. The Sr. Lead Software Engineer will own the Master Data Management data pipeline from source through mastering and downstream distribution, using Azure-based technologies.

The role also emphasizes designing scalable ETL solutions, establishing data quality and validation rules, and ensuring batch processing meets SLAs. You will mentor the ETL team and drive modernization to improve scalability and efficiency.