Dataford
Top 20
Prep plan
Updated weekly · Last refresh Aug 30

American Technology Consulting Data Analyst Interview Questions

The questions to prepare for a American Technology Consulting Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

20questions
~3htotal time
Track your progressSign up free to work through all 20 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 3 questions · ~24 min
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityAmerican Technology Consulting
Handling Missing Data in PipelinesMedium

Approach for handling missing data in an ML data pipeline, including validation, imputation, and safe downstream consumption.

InfrastructureETLBatch ProcessingAmerican Technology Consulting
Analyzing Unstructured DataMedium

Tests ability to process and extract insights from unstructured data sources.

Data ModelingPipelinesQualityAmerican Technology Consulting
2
Behavioral & Leadership13 questions · ~104 min
Mentoring a Colleague to GrowEasy

Tests mentorship through a concrete example, including how you supported a colleague’s growth and the measurable outcome.

MentorshipCommunicationLeadershipAmerican Technology Consulting
More Behavioral & Leadership questions with a free account
3
More topics4 questions · ~32 min
Design Test for New FeatureMedium

Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.

experiment designfeature evaluationA/B TestingAmerican Technology Consulting
SQL for Complex QueriesMedium

Tests ability to write and reason about complex SQL for analytics use cases.

SQL & Data ManipulationJoinsAggregationsAmerican Technology Consulting
Data Visualization ImpactEasy

Tests understanding of visualization principles and how analytics drives decisions.

User NeedsValue PropositionAmerican Technology Consulting
Designing an Executive Tableau DashboardMedium

Tests dashboard design thinking, executive communication, and Tableau best practices.

User NeedsUse CasesAmerican Technology Consulting

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Contact Center Agent Performance MetricsHard
Practice
Practice drill

Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.

ETLAggregationsData ModelingADP
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Resolve Conflicting Customer AttributesMedium
Practice
Practice drill

Use joins, CTEs, and row ranking to resolve conflicting customer profile values across ACME House systems.

JoinsData WranglingQualityRamsey SolutionsACME House
The finish line: interview-readyComplete all 20 questions plus 3 hands-on drills to finish this plan.