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 daily.
Aggregate paid pharmacy claims by member and month, keeping only claims within Lockton enrollment coverage dates.
Lockton CompaniesTests advanced SQL for deduplication logic and correct record selection.
Lockton CompaniesTests understanding of SQL filtering stages for row-level vs aggregated results.
Lockton CompaniesExplain the differences between WHERE and HAVING clauses in SQL and when to use each.
Lockton CompaniesCalculate monthly renewal completion rates by Lockton office and account executive using joins, date formatting, and conditional aggregation.
Lockton CompaniesAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreTests 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.