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 TrustTransform comma-separated employee tags, join employees to managers, and aggregate active direct reports by manager and tag.
TredenceSegment Instacart orders by region, retailer, and derived delivery outcome with aggregate operational metrics.
InstacartValidate a newly ingested dataset for row-count discrepancies, duplicates, invalid values, missing keys, and referential integrity issues.
AdswerveTests 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.