What a data analyst does
New Zealand's careers service says data analysts help organisations collect and examine data to improve how they work. England's National Careers Service lists tasks for data analysts such as:
- gathering and organising data ready for analysis
- checking the quality of data and removing exceptions
- using tools to find patterns, trends and relationships
- preparing results in formats such as graphs
- presenting findings to help people make decisions
- storing data in line with data protection and security standards
The UK government's role framework says a data analyst collects, manages, explores and shares data to support the organisation's goals.
Skills employers look for
The profiles stress a few skills that an interview can test:
- Maths and logic. The National Careers Service lists maths knowledge and clear, logical thinking.
- Care with detail. You need to be thorough, because small errors change results.
- Explaining results. The UK framework names communicating between technical and non-technical people as a skill.
- Ethics and privacy. The same framework lists data ethics and privacy among the skills.
- Code and charts. It also lists developing code for analysis, and data visualisation.
- Curiosity. O*NET's US profile for data scientists, a related job, lists intellectual curiosity and attention to detail.
The interviews you may face
Each employer runs its own process. Ask what to expect if the invitation doesn't say. You may face some of these:
- A screening call about your background. Our guide on how phone screens work can help.
- A technical test, such as cleaning a small data set or writing a query, sometimes timed.
- A take-home analysis, where you get data, answer a question and present what you found.
- A case question about a business problem, such as why sales fell last month.
- A behavioural interview about past projects and working with others. Read our tips for behavioural questions.
If you present findings, keep to the time and lead with the answer. Our guide to assessment tasks has more on take-home work.
Questions that test each skill
These are themes, with sample wording. Real questions vary by employer.
- Data quality: "How would you check a new data set before you use it?"
- Analysis: "Sales fell 10% last month. How would you find out why?"
- Charts: "Which chart would you use to show this, and why?"
- Explaining: "Tell me about a time you explained a result to someone without a data background."
- Ethics and privacy: "What would you do if a request meant sharing personal data?"
- Impact: "Tell me about an analysis that changed a decision."
Answer "tell me about a time" questions with STAR: the situation, your task, the actions you took and the result. Our free STAR answer planner helps you shape each one.
What to prepare
- Note the tools the ad names, such as spreadsheets, a query language or a charting tool.
- Practise cleaning and summing up a public data set, and time yourself.
- Prepare one project to walk through: the question, the data, the method, the result and its limits.
- Write six to eight STAR stories, including one where the data was messy or wrong.
- Practise saying a finding in one sentence, then the detail behind it.
If a team did the work, say what your part was. Never present a group's analysis as yours alone.
An example answer about an analysis that mattered
Here is a made-up answer for a made-up person. Use it to see the shape of a strong answer, then tell your own true story.
Made-up example
Amira, a data analyst at an online shop, applying for a bigger role
Question
Situation
Task
Action
- I pulled 12 months of orders and split them into orders with and without free delivery.
- I found and removed about 400 test orders that would have thrown off the numbers.
- I compared how often each group of customers came back to buy again.
- I built one simple chart showing repeat buying for each group.
- I presented it in five minutes: the answer first, then the method and its limits.
Result
Amira's actions show the whole job: clean data, a fair comparison, a clear chart and a short talk. The result says what changed.
Questions
Do I need to code to be a data analyst?
It depends on the job. The UK government's framework lists developing code for analysis as a skill. Check the tools each ad names, and be honest about your level with each one.
How do I prepare for a take-home task?
Read the brief twice. Note the deadline and how long it should take. Say what you assumed, and show how you checked the data.
What if I have no work experience with data?
Use a project from study, a course or your own interest. Pick a public data set, ask a real question and write up what you found.
Sources
Written by Seal the Offer from these pages, last checked on . Rules change, so check the employer's own page and the job ad before you apply.