Data Analyst: what the role asks for
Turns business questions into queries, analyses and reports that inform decisions. Cleans and combines data from several sources and presents findings through dashboards and written summaries. Works closely with business stakeholders to define metrics.
Skill profile: Karnamo curated v1 (original, not ESCO-derived). It describes a typical role; individual employers differ, so always check the job description in front of you.
Core skills
Expected from day one. Gaps here usually decide whether you get to the interview.
SQL
target: deep / can teach othersQuery language for relational databases: filtering, joins, aggregation and schema design.
- PostgreSQL tutorial: the SQL language (reading, free)
- Write ten analytical queries (joins, window functions, aggregation) against a public sample dataset (practice, free)
Data Analysis
target: deep / can teach othersExploring data, finding patterns and turning them into decisions.
- Analyse a public dataset end to end and write a one-page summary with a clear recommendation (project, free)
Data Visualization
target: deep / can teach othersPresenting data clearly in charts and dashboards.
- Rebuild a misleading chart honestly and write down which choices you changed and why (practice, free)
Communication
target: solid, independentConveying information clearly and listening effectively, in writing and speech.
- Write a one-page memo of a complex topic for a non-expert and have someone summarise it back to you (practice, free)
Important skills
Expected within the first year; strong candidates show some already.
Spreadsheets & Excel
target: deep / can teach othersUsing spreadsheets for modelling, analysis and reporting.
- Build a three-statement style budget model in a spreadsheet with scenarios and input checks (practice, free)
Statistics
target: solid, independentProbability, inference and experimental reasoning for sound conclusions from data.
- Work through confidence intervals, p-values and power on a simulated dataset and explain each result in plain language (practice, free)
Stakeholder Management
target: solid, independentAligning expectations and communication with people who influence or are affected by your work.
- Map the stakeholders of a current project by influence and interest and plan how to communicate with each (practice, free)
Presentation Skills
target: solid, independentStructuring and delivering talks and demos for different audiences.
- Record a ten-minute presentation, watch it back and note three concrete improvements (practice, free)
Nice to have
Differentiators that help but rarely block.
Python
target: solid, independentGeneral-purpose language common in scripting, back-end services, automation and data work.
- The Python Tutorial (official) (reading, free)
Product Analytics
target: solid, independentMeasuring product usage and outcomes with metrics, funnels and cohorts.
- Define a metric tree for a product you use: one north-star metric, inputs and guardrails (practice, free)
A/B Testing & Experimentation
target: working knowledgeDesigning and interpreting controlled experiments for product decisions.
- Design an experiment on paper: hypothesis, primary metric, sample size, guardrails and decision rule (practice, free)
Data Protection & GDPR
target: working knowledgeHandling personal data lawfully, including privacy by design and data-subject rights.
- General Data Protection Regulation (official text, EUR-Lex) (reading, free)
Sample interview questions
- Technical / domain
A metric dropped 15 percent week over week. How do you investigate?
Start with data quality and definition checks, then segment by dimensions and time, and form hypotheses to test before presenting a cause.
- Behavioral
Describe a time you discovered an error in your own analysis after sharing it.
Good answers show quick, transparent correction and a check that prevents repeats, rather than quiet fixes.
- Technical / domain
Explain the difference between correlation and causation and how you would test for a causal effect.
Shows an accurate grasp of confounding and randomised experiments, plus alternatives when experiments are not possible.
- Coding or case study
Here is a dataset with a surprising result. Explore it and tell me what you would check before trusting it.
Checks for data quality, selection effects and confounding before offering explanations, and states confidence honestly.
- Final
How do you make sure the insights you produce are actually used?
Shows early involvement of decision makers, clear recommendations, follow-up and feedback loops.
- Panel
Present an analysis you did and explain its limitations to a mixed technical and non-technical audience.
Shows you tailor depth to the audience and state limitations and confidence clearly.
All Data & analytics interview questions · Pick your own round and seniority
Related career moves
Roles whose skill profiles overlap most with this one. Overlap is a starting point for a conversation, not a recommendation.
- Data Scientist9 shared skills (75% of that role's profile)
- Customer Success Manager6 shared skills (50% of that role's profile)
- Financial Controller5 shared skills (42% of that role's profile)
- Marketing Manager5 shared skills (42% of that role's profile)
- Sales Account Executive4 shared skills (36% of that role's profile)
Compare your own CV against Data Analyst job postings with a transparent rubric.
Try the job-fit analyzer