ACT Data Analyst Interview Questions
The questions to prepare for a ACT Data Analyst interview. Questions from real interview reports rank first. Updated daily.
Explain common SQL-friendly ways to detect outliers and how to handle them without distorting downstream analysis.
Explain how SQL fits with data analysis and visualization tools, and when to use each in an analytics workflow.
Tests controls for correctness, referential integrity, and reliable transformations at scale.
Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.
Gain Digital
TCS
Zest AIRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
Waymo
CruiseUse joins and LAG to isolate departments driving a large month-over-month spending variance.
State of California
University of Chicago
The Church of Jesus Christ of Latter-day SaintsSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests data-driven decision making, ownership, and change leadership when project metrics indicate the original plan should change.
Tests prioritization under pressure, including trade-off judgment, stakeholder alignment, and ownership of outcomes.
Tests communication of complex data to non-technical stakeholders, including clarity, stakeholder management, and actionable storytelling.
Evaluates your motivation and alignment with ACT’s mission and role expectations.
Evaluates your ability to communicate technical analysis clearly in English.