Question bank

Interview questions, with guidance on how to answer

834 questions across 64 roles. Open one to see what a strong answer includes and common slips, then drill it out loud with Ava. New to answer structure? Start with the learning hub.

834 questions.

TechnicalMid levelAutomation Engineer
Walk me through integrating two systems where one sends data through webhooks and the other only accepts batch uploads.
Tests: APIs & system integration
TechnicalMid levelAutomation Engineer
How do you handle the passwords and credentials your bots need to log in to other systems?
Tests: Security & governance
BehaviouralMid levelAutomation Engineer
Tell me about a time the people doing a process described it differently from how it actually worked. How did you find out?
Tests: Stakeholder collaboration
TechnicalSeniorAutomation Engineer
How do you design automations so that a change in a vendor's website or system doesn't silently break things for weeks?
Tests: Error handling & resilience
CaseSeniorAutomation Engineer
If you were setting up an automation centre of excellence, how would you decide what gets built, who maintains it and how changes are approved?
Tests: Security & governance
BehaviouralSeniorAutomation Engineer
Tell me about an automation that didn't deliver the savings that were expected. What did you learn and what did you change?
Tests: Ownership & continuous improvement
TechnicalAny levelAutomation Engineer
How do you deal with an API that has rate limits and occasionally times out?
Tests: APIs & system integration
TechnicalAny levelAutomation Engineer
How are you using AI features, like document understanding or language models, in your automations today?
Tests: RPA & workflow tool development
TechnicalEntry levelBusiness Intelligence Developer
What is a star schema, and why do BI tools tend to work well with it?
Tests: Data modelling for analytics
TechnicalEntry levelBusiness Intelligence Developer
How would you write a query to find each customer's most recent order?
Tests: SQL development
BehaviouralEntry levelBusiness Intelligence Developer
A manager asks for a dashboard showing sales performance. What questions would you ask before building anything?
Tests: Requirements gathering
TechnicalMid levelBusiness Intelligence Developer
Tell me about a report you built in Power BI, Tableau or a similar tool that you're proud of. What made it work for its users?
Tests: BI tool development
TechnicalMid levelBusiness Intelligence Developer
Two dashboards show different revenue numbers for the same month. How do you track down why and fix it for good?
Tests: Semantic layer & metric definitions
TechnicalMid levelBusiness Intelligence Developer
A dashboard takes forty seconds to load. Walk me through how you'd speed it up.
Tests: Report performance optimisation
TechnicalMid levelBusiness Intelligence Developer
How would you set up a report so that regional managers only see data for their own region?
Tests: Data governance & security
TechnicalSeniorBusiness Intelligence Developer
How do you handle a salesperson moving to a new territory so that historical reports still show their past sales correctly?
Tests: Data modelling for analytics
TechnicalSeniorBusiness Intelligence Developer
How would you bring order to a BI environment where hundreds of reports have grown up with no standards?
Tests: Semantic layer & metric definitions
BehaviouralSeniorBusiness Intelligence Developer
Tell me about a time stakeholders kept changing what they wanted mid-project. How did you keep it on track?
Tests: Requirements gathering
BehaviouralAny levelBusiness Intelligence Developer
Before you publish a new report, how do you make sure the numbers are right?
Tests: Attention to detail
BehaviouralAny levelBusiness Intelligence Developer
Tell me about a time you caught an error in data or a report before anyone else noticed.
Tests: Attention to detail