Northern Trust Data Analyst Interview Questions
The questions to prepare for a Northern Trust Data Analyst interview. Questions from real interview reports rank first. Updated daily.
Explain how you used PostgreSQL SQL queries and aggregations to extract analysis-ready data from a single dataset.
Northern TrustExplain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.
Northern TrustExplain how to validate SQL data before reporting, including null checks, duplicates, outliers, and aggregation reconciliation.
Northern TrustExplain how to profile, clean, and standardize missing or dirty data before analysis.
Northern TrustAudit claims for missing members, invalid amounts, and payment totals that exceed billed amounts.
Healthfirst (New York)
PhysicsXBBritvic Soft DrinksIdentify repeated Epsilon event records by business-key values and report duplicate and removable row counts.
EpsilonAudit user, application, and event relationships to validate completeness and referential integrity.
Mercer France
bet365Tests resilience after a setback, including ownership, recovery under ambiguity, and how effectively the candidate regains momentum.
Northern TrustEvaluates your incident response, troubleshooting, and recovery approach for data pipelines.
Northern TrustAssesses your understanding of core banking concepts and interest rate effects on bond pricing.
Northern TrustTests your ability to turn data into actionable insights for stakeholders.
Northern TrustSign up to see every question
Create a free account to unlock this list and practice real interview questions.