Enterprise Data Architect and Modeler

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.

The Enterprise Data & Analytics (EDA) team is looking to hire an experienced Enterprise Data Architect and Modeler to focus on Risk and Enterprise Data.  This role will involve collaborating with various teams within the organization to architect an organizational view into Risk Management and ensure enterprise risk data models are designed/maintained to accurately represent the organization and enable risk aggregation and risk reporting.  The right candidate will be able to stretch and support multiple areas inclusive of Data Architecture strategy, Data Modeling, Information Architecture, and as needed data centric solution architect. 

Expectations:

• Work across the organization to champion value driven data architecture practices
• Develop/Maintain Enterprise conceptual and Enterprise logical data models that reflect the organization's data requirements and business processes – specific focus will support Risk Management inclusive of non-financial risk
• As needed, own Enterprise architecture of Data Domains that support overarching NT Taxonomy
• Conduct business requirements sessions with Data Domain Leads, Data Owners, and Data SMEs to gather and analyze requirements for new data models or modifications to existing ones or new information organization.
• Determine how the various entities are related and develop entity relationship diagrams that represent the connections among the entities.
• Identify each entity's characteristics and properties and ensure that the entities can be differentiated within the model.
• Maintain appropriate Version Control on data models.
• Develop a logical data model and validate the model to ensure that it serves the needs of the business application and its consumers.
• Apply normalization techniques to ensure data integrity and minimize redundancy, while also considering denormalization where necessary to improve query performance.
• Create and maintain documentation for data models, including entity-relationship diagrams (ERDs), data dictionaries, and metadata definitions integrating with Collibra
• Work closely with cross-functional teams, including software developers, data scientists, and business stakeholders, to align data models with business requirements and technical constraints.
• Engage the business users to assess their information needs.
• Review the business process and conceptualize the entities that interoperate within the business process.
• Stay updated on emerging trends, best practices, and technologies in data modelling and database design, and proactively recommend improvements to existing processes and methodologies.

Experience:

• Proven experience in data modelling, database design, and development.
• Proficiency in SQL and database management systems (e.g., Oracle, MySQL, PostgreSQL, SQL Server).
• Familiarity with data modelling tools such as Erwin or ER/Studio.
• Strong analytical and problem-solving skills, with the ability to translate complex business requirements into data models.
• Experience with Agile development methodologies and version control systems (e.g., Git) is a plus.
• Be able to work independently and collaboratively in a matrix environment.
• Be able to use existing models, map to data dictionary components and extend where required.
• Working experience with Data Mesh is a plus.
• At least 8 years in data delivery and architecture.
• Minimum of Bachelor's degree in Computer Science or related experience.

Salary Range:

Salary 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.

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 the world’s most admired and sustainable companies! Build your career with us and apply today. #MadeForGreater 

Reasonable accommodation

Northern Trust is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at MyHRHelp@ntrs.com.

 
We hope you’re excited about the role and the opportunity to work with us. We value an inclusive workplace and understand flexibility means different things to different people.

Apply today and talk to us about your flexible working requirements and together we can achieve greater.