Enterprise Data 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 Enterprise Data Modeler.  This role will involve collaborating with various teams within the organization to gather relevant information and ensure enterprise data models are designed/maintained to accurately represent the organization data.

Expectations:

• 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.
• 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.
• 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 software delivery and architecture.
• Minimum of Bachelor's degree in Computer Science or related discipline.

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.