Lead, Arch Solutions
Job Location:
Chicago, IL - USA
Yearly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
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 worlds 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 24000 partners we serve the worlds 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.
- Developlakehouseand data warehouse solutions using layered data patterns such as Bronze Silver and Gold with appropriate dimensional normalized or Data Vault modeling techniques.
- Evangelize moderndatamodelinganddata qualitypractices
- 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 indesigning 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 PythonPySpark 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 andlakehousedata 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:
$114500 - 194700 USDSalary 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 Trusts 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 or alternatively you can discuss your individual requirements with the recruiter you are working with.
About Company
Guided by founding principles of service, expertise and integrity, our experts help the world’s most successful individuals, families and institutions achieve their goals.
