Enterprise Data Architect and Modeler

About the position

Northern Trust 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.

Responsibilities

• 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.
• 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.
• Determine how the various entities are related and develop entity relationship diagrams that represent the connections among the entities.
• 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.
• 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.
• Stay updated on emerging trends, best practices, and technologies in data modelling and database design.

Requirements

• 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.
• At least 8 years in data delivery and architecture.
• Minimum of Bachelor's degree in Computer Science or related experience.

Nice-to-haves

• Experience with Data Mesh is a plus.
• Ability to work independently and collaboratively in a matrix environment.
• Be able to use existing models, map to data dictionary components and extend where required.

Benefits

• 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.
• Discretionary bonus program that may include an equity component.