Data Architect

Northern Trust Corporation

Chicago, IL, USA

Full time



Aug 27

Title: Data Architect

Northern Trust Asset Management business unit is looking for Data Architect candidate with strong expertise in relational and cloud databases. The candidate would be part of very dynamic and fast paced team in build strategic data services for the group.

Key Skills Required For The Role

  • Expertise in designing data solution on Snowflake Data Warehouse on Azure.
  • Investment management or Asset Management Experience recommended.
  • Design the database, data models, ETL processes, and data warehouse applications through the use of best practices and tools.
  • Responsible for overall data architecture for all areas and domains of the enterprise, including data acquisition, data warehouse, data provisioning, and ETL.
  • Expert level understanding of relational database concepts, dimensional database concepts and database architecture and design, ontology and taxonomy design
  • Strong understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies
  • Azure cloud solution architect to provide technology solution to business problems. With strong understanding of various services available on azure.
  • Experience in configuration, maintenance and optimization of snowflake databases
  • Knowledge of ETL patterns for data ingestion, processing and distribution using pipelines on Azure cloud services.
  • Deep understanding of relational as well as NoSQL data stores methods and approaches Star, Vault and Snowflake dimensional modelling
  • Rich Experience of designing and implementation of database models (LDM & PDM), data flow diagrams, database schema, DB scripts.

Roles And Responsibilities

  • Document data program roadmap, architecture and patterns.
  • Interface and communicate with global teams to collaborative work on business deliveries (planning and execution).
  • Provide design level functional and technical expertise along with best practices.
  • Own and manage data models, architecture, and maintenance processes
  • Understand and implement the latest delivery approaches based on data architecture

About Northern Trust

Northern Trust, a Fortune 500 company, is a globally recognized, award-winning financial institution that has been in continuous operation since 1889.

Northern Trust is proud to provide innovative financial services and guidance to the world’s most successful individuals, families and institutions by remaining true to our enduring principles of service, expertise and integrity. With more than 130 years of financial experience and over 22,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service.

Working With Us

As a Northern Trust partner, greater achievements await. You will be part of a flexible and collaborative work culture in an organization where financial strength and stability is an asset that emboldens us to explore new ideas. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to assisting the communities we serve! Join a workplace with a greater purpose.

We’d love to learn more about how your interests and experience could be a fit with one of America’s best banks and most sustainable companies! Build your career with us and apply today. #MadeForGreater

Additional Information

Apply for this position Back to job

You must be logged in to apply to this job.