Jobs › Northern Trust

Specialist, Data Analytics

Northern Trust · Chicago, IL · $137,400–$240,400 a year · Full time

Posted Sep 2, 2026 · We last checked this listing on Oct 6, 2026

Apply at Northern Trust

Likely interview questions for this role

Written from this job description, not a generic list. Each one notes what the interviewer is really checking.

About your past

Tell me about a time you turned a vague business request into clear functional requirements.

What they are checking: Whether they can act as the bridge between business needs like KYC and the technical MDM design.

Describe a time you led other engineers through a technical decision you were accountable for.

What they are checking: Whether they can act as the technical leader the role calls for, guiding design choices rather than only coding.

What would you do

The KYC team says onboarding is delayed because client data is wrong in MDM. How do you find the cause?

What they are checking: Whether they trace a data quality issue back through ingestion and transformation to its real source.

A downstream team changed how they read your MDM feed without telling you, and their reports broke. How do you handle it?

What they are checking: Whether they fix the immediate problem and then put contracts or communication in place to prevent repeats.

How do you balance delivering new MDM features with fixing the data quality debt you already have?

What they are checking: Whether they protect trust in master data while still meeting business demands for new capabilities.

About the work

Walk me through how you would design the data flow for a master party record coming from several source systems.

What they are checking: Whether they understand matching, survivorship and golden record design in Master Data Management, not just moving data.

How would you decide which source wins when two systems disagree about a client's legal name or address?

What they are checking: Whether they can define survivorship rules with business owners instead of making silent technical choices about client data.

What data quality checks would you build into an MDM pipeline before data gets distributed to downstream systems?

What they are checking: Whether they catch bad data before it spreads to reporting, onboarding and regulatory processes across the enterprise.

How would you model the relationship manager hierarchy so it stays accurate when people change roles?

What they are checking: Whether they think about how hierarchies change over time and how that affects reporting and access downstream.

Write out loud a SQL approach to find likely duplicate client records across two tables.

What they are checking: Whether they have hands-on SQL skill and understand that matching needs fuzzy logic, not just exact joins.

Practice this interview out loud.

Offer builds a real interview for this exact role at Northern Trust from your resume and this job description, asks the questions one at a time, and tells you what landed. The first one is free.

Practice this out loud

The full job description

As published by Northern Trust.

About Northern Trust As a global leader in innovative wealth management, asset servicing, asset management and banking services, Northern Trust (Nasdaq: NTRS) is proud to guide the world’s most successful individuals, families, corporations and institutions. Since 1889, we have aligned our efforts with our three guiding Principles That Endure: Service, Expertise, and Integrity. Together, they reflect the three cornerstones of business conduct which we strive to instill in our employees, whom we call partners, and to provide to our clients and the communities we serve worldwide. With more than 135 years of financial experience and over 24,000 partners, we serve the world’s most sophisticated clients using leading technology and exceptional service. The Specialist, Data Analytics Engineer serves as the technical leader for Master Data Management (MDM) data integration and movement, with accountability for data ingestion, transformation, quality assurance, and distribution of master data across the enterprise. Key Responsibilities: Business Technology Bridge • Translate business needs such as KYC, client onboarding, reporting, relationship manager hierarchy, and related business processes into MDM requirements. • Work closely with business stakeholders to define functional requirements and specifications. • Serves as the functional lead for Master Party, Account, and Enterprise Reference Data domains, translating business needs into data models, business rules, and processes. Responsible for ensuring data quality, governance compliance, and alignment with client lifecycle, regulatory, and enterprise data management strategies. Data Quality & Governance Oversight • Define and monitor data quality KPIs. • Partner with Data Stewards, Data Owners, Architecture, and Data Governance teams. • Ensure master data standards, controls, and governance requirements are implemented. Salary Range: $137,400 - 240,400 USD 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. Work Authorization Applicants must be authorized to work in the U.S. without the need for employment-based visa sponsorship now or in the future. Northern Trust will not sponsor applicants for U.S. work visa status for this opportunity (no sponsorship is available for H-1B, L-1, TN, O-1, E-3, H-1B1, F-1, J-1, OPT, CPT or any other employment-based visa). Working with Us As a Northern Trust partner, you will be part of a flexible and collaborative work culture, which has a strong history of financial strength and stability. Movement within the organization is encouraged, senior leaders are accessible, and you can take pride in working for a company committed to an inclusive workplace and assisting the communities we serve. Philanthropy is deeply rooted in Northern Trust’s history and is an essential element of our culture. Employees around the world give their time and talent to work for the greater good of their communities. Reasonable Accommodation Northern Trust is committed to working with and providing adjustments to individuals with health conditions and disabilities. If you need a reasonable accommodation for any part of the employment process, please email our HR Service Center at MyHRHelp@ntrs.com , or alternatively you can discuss your individual requirements with the recruiter you are working with.

Apply at Northern Trust