Aller au contenu

Data Analyst : les attentes du poste

Certains contenus de cette page (compétences, questions) sont actuellement disponibles uniquement en anglais.

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.

Profil de compétences : Karnamo curated v1 (original, not ESCO-derived). Il décrit un poste type ; les employeurs ont des attentes différentes. Vérifiez toujours la description de l’offre concernée.

Compétences essentielles

Attendues dès le premier jour. Les lacunes à ce niveau déterminent souvent votre accès à l’entretien.

  • SQL

    niveau cible : expertise approfondie, capacité à former

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

  • Data Analysis

    niveau cible : expertise approfondie, capacité à former

    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, gratuit)
  • Data Visualization

    niveau cible : expertise approfondie, capacité à former

    Presenting data clearly in charts and dashboards.

    • Rebuild a misleading chart honestly and write down which choices you changed and why (practice, gratuit)
  • Communication

    niveau cible : maîtrise solide et autonome

    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, gratuit)

Compétences importantes

Attendues durant la première année ; les candidatures solides en démontrent déjà certaines.

  • Spreadsheets & Excel

    niveau cible : expertise approfondie, capacité à former

    Using spreadsheets for modelling, analysis and reporting.

    • Build a three-statement style budget model in a spreadsheet with scenarios and input checks (practice, gratuit)
  • Statistics

    niveau cible : maîtrise solide et autonome

    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, gratuit)
  • Stakeholder Management

    niveau cible : maîtrise solide et autonome

    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, gratuit)
  • Presentation Skills

    niveau cible : maîtrise solide et autonome

    Structuring and delivering talks and demos for different audiences.

    • Record a ten-minute presentation, watch it back and note three concrete improvements (practice, gratuit)

Compétences souhaitables

Des atouts qui vous distinguent, mais dont l’absence est rarement bloquante.

  • Python

    niveau cible : maîtrise solide et autonome

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

  • Product Analytics

    niveau cible : maîtrise solide et autonome

    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, gratuit)
  • A/B Testing & Experimentation

    niveau cible : connaissances pratiques

    Designing and interpreting controlled experiments for product decisions.

    • Design an experiment on paper: hypothesis, primary metric, sample size, guardrails and decision rule (practice, gratuit)
  • Data Protection & GDPR

    niveau cible : connaissances pratiques

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

Exemples de questions d’entretien

  1. Technique ou métier

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

    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. Technique ou métier

    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. Programmation ou étude de cas

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

  6. Jury

    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.

Toutes les questions d’entretien : Data & analytics · Choisir votre étape et votre niveau d’expérience

Transitions professionnelles proches

Les postes dont les profils de compétences recoupent le plus celui-ci. Ce recoupement amorce une réflexion, sans constituer une recommandation.

Comparez votre CV aux offres de Data Analyst à l’aide d’une grille transparente.

Essayer l’analyseur d’adéquation