Data Analyst: Was die Rolle erfordert
Einige Inhalte auf dieser Seite (Kompetenzen, Fragen) sind derzeit nur auf Englisch verfügbar.
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.
Kompetenzprofil: Karnamo curated v1 (original, not ESCO-derived). Es beschreibt eine typische Rolle; einzelne Arbeitgeber unterscheiden sich. Prüfe daher immer die konkrete Stellenbeschreibung.
Kernkompetenzen
Ab dem ersten Tag erwartet. Lücken entscheiden hier oft darüber, ob du zum Interview eingeladen wirst.
SQL
Zielniveau: vertieft / kann andere anleitenQuery language for relational databases: filtering, joins, aggregation and schema design.
- PostgreSQL tutorial: the SQL language (reading, kostenlos)
- Write ten analytical queries (joins, window functions, aggregation) against a public sample dataset (practice, kostenlos)
Data Analysis
Zielniveau: vertieft / kann andere anleitenExploring 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, kostenlos)
Data Visualization
Zielniveau: vertieft / kann andere anleitenPresenting data clearly in charts and dashboards.
- Rebuild a misleading chart honestly and write down which choices you changed and why (practice, kostenlos)
Communication
Zielniveau: solide, selbstständigConveying 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, kostenlos)
Wichtige Kompetenzen
Im ersten Jahr erwartet; starke Bewerber bringen einige bereits mit.
Spreadsheets & Excel
Zielniveau: vertieft / kann andere anleitenUsing spreadsheets for modelling, analysis and reporting.
- Build a three-statement style budget model in a spreadsheet with scenarios and input checks (practice, kostenlos)
Statistics
Zielniveau: solide, selbstständigProbability, 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, kostenlos)
Stakeholder Management
Zielniveau: solide, selbstständigAligning 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, kostenlos)
Presentation Skills
Zielniveau: solide, selbstständigStructuring and delivering talks and demos for different audiences.
- Record a ten-minute presentation, watch it back and note three concrete improvements (practice, kostenlos)
Wünschenswert
Zusätzliche Stärken, die helfen, aber selten eine Voraussetzung sind.
Python
Zielniveau: solide, selbstständigGeneral-purpose language common in scripting, back-end services, automation and data work.
- The Python Tutorial (official) (reading, kostenlos)
Product Analytics
Zielniveau: solide, selbstständigMeasuring 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, kostenlos)
A/B Testing & Experimentation
Zielniveau: Grundkenntnisse für die PraxisDesigning and interpreting controlled experiments for product decisions.
- Design an experiment on paper: hypothesis, primary metric, sample size, guardrails and decision rule (practice, kostenlos)
Data Protection & GDPR
Zielniveau: Grundkenntnisse für die PraxisHandling personal data lawfully, including privacy by design and data-subject rights.
- General Data Protection Regulation (official text, EUR-Lex) (reading, kostenlos)
Beispielhafte Interviewfragen
- Technik / Fachgebiet
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.
- Verhalten und Erfahrungen
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.
- Technik / Fachgebiet
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.
- Programmierung oder Fallstudie
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.
- Abschlussgespräch
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.
- Gesprächsrunde mit mehreren Beteiligten
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.
Alle Interviewfragen für Data & analytics · Gesprächsrunde und Erfahrungsstufe selbst wählen
Verwandte berufliche Wechsel
Rollen, deren Kompetenzprofile sich mit diesem am stärksten überschneiden. Die Überschneidung ist ein Gesprächseinstieg, keine Empfehlung.
- Data Scientist9 gemeinsame Kompetenzen (75 % des Profils dieser Rolle)
- Customer Success Manager6 gemeinsame Kompetenzen (50 % des Profils dieser Rolle)
- Financial Controller5 gemeinsame Kompetenzen (42 % des Profils dieser Rolle)
- Marketing Manager5 gemeinsame Kompetenzen (42 % des Profils dieser Rolle)
- Sales Account Executive4 gemeinsame Kompetenzen (36 % des Profils dieser Rolle)
Vergleiche deinen Lebenslauf anhand eines transparenten Rasters mit Stellenanzeigen für Data Analyst.
Passungsanalyse ausprobieren