BI developer interview questions

About the job itself

1. Why do you want to work as a BI developer?
   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.
2. What pay are you looking for?
   A figure you can justify. Adverts for this job usually pay £40,000 to £55,000 a year, so check the advert, know your number and give it calmly.

Questions for it & technology

1. 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.
2. How do you explain a technical issue to somebody who is not technical?
   Plain words, what it means for them, and what happens next.
3. How do you keep your skills current?
   Something real: a course, a project, a community, reading.
4. How do you handle a deadline you know you will miss?
   You say so early, with options.
5. What does good security practice mean in your daily work?
   Least privilege, strong authentication, patching, and never sharing credentials.

The questions every interviewer asks

1. Why do you want this job, here?
   That you looked at the employer: what they do, where, and one thing that appeals to you about them.
2. Tell me about a time something went wrong at work and what you did.
   A real example: what happened, what you did yourself, how it ended, and what you do differently now.
3. What would your last manager say about you?
   Something they would actually say, with proof: "reliable, I covered the late shift for six months".
4. When could you start?
   A straight answer. If you have notice to give, say how long; employers respect somebody who works their notice.
5. 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.

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.

Read more. For candidates: common interview questions, the STAR method, questions to ask at the end. For employers: how to interview candidates and interview adjustments for disabled and neurodivergent candidates.