Zum Inhalt springen

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 anleiten

    Query language for relational databases: filtering, joins, aggregation and schema design.

  • Data Analysis

    Zielniveau: vertieft / kann andere anleiten

    Exploring 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 anleiten

    Presenting 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ändig

    Conveying 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 anleiten

    Using 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ändig

    Probability, 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ändig

    Aligning 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ändig

    Structuring 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ändig

    General-purpose language common in scripting, back-end services, automation and data work.

  • Product Analytics

    Zielniveau: solide, selbstständig

    Measuring 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 Praxis

    Designing 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 Praxis

    Handling personal data lawfully, including privacy by design and data-subject rights.

Beispielhafte Interviewfragen

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

Vergleiche deinen Lebenslauf anhand eines transparenten Rasters mit Stellenanzeigen für Data Analyst.

Passungsanalyse ausprobieren