Lockton Companies Data Analyst Interview Questions
The questions to prepare for a Lockton Companies Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Aggregate paid pharmacy claims by member and month, keeping only claims within Lockton enrollment coverage dates.
Lockton CompaniesExplain the differences between WHERE and HAVING clauses in SQL and when to use each.
Lockton CompaniesTests understanding of SQL filtering stages for row-level vs aggregated results.
Lockton CompaniesTests advanced SQL for deduplication logic and correct record selection.
Lockton CompaniesAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
WaymoTests prioritization under pressure, stakeholder management, and ownership when multiple reporting requests compete for limited analytics capacity.
Lockton CompaniesTests prioritization under pressure, stakeholder management, and ownership when multiple urgent requests compete for limited time.
Lockton CompaniesTests your analytical troubleshooting workflow for identifying drivers of cost changes.
Lockton CompaniesTests your data validation, QA, and reliability practices for client-ready outputs at Lockton Companies.
Lockton CompaniesSign up to see every question
Create a free account to unlock this list and practice real interview questions.