Data analyst interview questions and answers

About the job itself

Why do you want to work as a data analyst?
What drew you to this work, what you already know about it, and something from your past that shows you will be good at it.
What do you have that this job asks for?
Employers usually look for: SQL, Excel, Power BI or Tableau. Say what you hold, with expiry dates where there are any, and bring the proof (cards, certificates, a portfolio): it is checked before you start.
What pay are you looking for?
A figure you can justify. Adverts for this job usually pay £30,000 to £45,000 a year, so check the advert, know your number and give it calmly.

Questions for it & technology

Tell me about something you built or fixed that you are proud of.
Your own part in it, the problem, the choices you made and the result.
How do you approach a problem you have never seen before?
Reproduce it, narrow it down, read the logs and docs, ask when stuck, and write down the fix.
How do you explain a technical issue to somebody who is not technical?
Plain words, what it means for them, and what happens next.
What does good security practice mean in your daily work?
Least privilege, strong authentication, patching, and never sharing credentials.
Tell me about working in a team with code reviews or tickets.
You give and take feedback well and keep tickets up to date.

The questions every interviewer asks

Why are you leaving your current job, or why did you leave the last one?
A reason that looks forward (more hours, a shorter journey, a step up), never a complaint about the old boss.
What would your last manager say about you?
Something they would actually say, with proof: "reliable, I covered the late shift for six months".
Where do you see yourself in a couple of years?
Ambition that fits the job: getting better at it, a ticket or qualification, perhaps leading a team.
What is the hardest part of this kind of work, in your view?
That you know the job as it really is, and how you handle its bad days.
Do you have any questions for us?
Always have two ready. See the list further down this page.

Questions to ask them

At the end you will be asked whether you have any questions. Have two ready:

What does a normal day or shift look like?
What would good work look like after the first three months?
Who would I work with, and who would I report to?
What training will I get at the start?
When can I expect to hear back, and what is the next step?

For the employer: what you must not ask

The same questions work from your side of the table. These do not, because UK law forbids them or makes them a risk:

Age, date of birth or when somebody left school. Age is a protected characteristic under the Equality Act 2010. Ask whether they meet any legal minimum age, nothing more.
Marriage, children, pregnancy or plans for a family. Protected characteristics. Ask everybody the same question about whether they can work the hours.
Health or sickness absence before a job offer. Section 60 of the Equality Act 2010 bans it, except to make adjustments for the interview, to check they can do a task that is intrinsic to the job, or for monitoring.
Religion, nationality or where somebody is "really" from. Protected characteristics. Check the right to work for every candidate in the same way, after the interview, not by guessing from a name or an accent.
Spent convictions. Under the Rehabilitation of Offenders Act 1974 a spent conviction need not be disclosed, except for roles exempt from the Act, where a standard or enhanced DBS check applies.
Trade union membership. Refusing work because somebody is or is not in a union is unlawful (Trade Union and Labour Relations (Consolidation) Act 1992, section 137).

Ask every candidate for the same job the same core questions, and write the answers down. It is fairer, and it is your best evidence if a decision is ever challenged.