Data Solutions Architect - Asset Management

001 Northern Trust Company - Chicago, IL

Full-time - Mid Level

Chicago, IL

10,001+ employees

About the position

The Data Solutions Architect for Northern Trust Asset Management is a pivotal role focused on designing and implementing data-driven solutions to meet complex business needs. This position requires strong collaboration across teams, effective communication, and a problem-solving mindset to engage with business leaders and provide innovative solutions. The architect will oversee the overall data architecture, including data acquisition, ETL processes, and data warehouse applications, ensuring smooth business operations.

Responsibilities

• Drive adoption of strategic data platform with strong understanding of IBOR/ABOR dataset sourced from Aladdin, CDG, Eagle and Custodial systems.
• Provide design level functional and technical expertise along with best practices.
• Understand and implement the latest delivery approaches based on data architecture.
• Manage relationships with all stakeholders, focusing on setting expectations and maintaining ongoing client satisfaction through effective communication.
• Lead technology proof of concepts to ensure feasibility of architecture solutions.
• Mentor engineering team on data input, use and analysis leveraging technical patterns.
• Drive continuous technology transformation to minimize technical debt and improve efficiency and effectiveness of the architecture.
• Look for opportunities to capitalize on technology advances through analysis of key industry and technology trends.
• Contribute to a fast-paced Agile team and participate in planning, documentation, execution, testing, and launch of projects.
• Examine data, processes, and technologies to determine the current state and critical problems of internal business functions.

Requirements

• Expertise in designing data driven solutions on Snowflake for complex business needs.
• Background working with key data domains such as account, holding, and performance within the asset management space.
• Design the database, data models, ETL processes, and data warehouse applications using best practices.
• Expert level understanding of relational and dimensional database concepts, database architecture and design, ontology, and taxonomy design.
• Knowledge of ETL patterns for data ingestion, processing, distribution, and reporting.
• Bachelor's degree in Engineering, Economics, Business, Finance, or equivalent experience.
• Intellectual curiosity, inclination for independent and self-directed work, and attention to detail.

Nice-to-haves

• Strong communication skills and a problem-solving mindset.
• Experience in managing relationships with stakeholders and executive leadership.

Benefits

• Flexible and collaborative work culture.
• Opportunities for movement within the organization.
• Access to senior leaders.
• Commitment to community service and sustainability.