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é à formerQuery language for relational databases: filtering, joins, aggregation and schema design.
- PostgreSQL tutorial: the SQL language (reading, gratuit)
- Write ten analytical queries (joins, window functions, aggregation) against a public sample dataset (practice, gratuit)
Data Analysis
niveau cible : expertise approfondie, capacité à formerExploring 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é à formerPresenting 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 autonomeConveying 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é à formerUsing 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 autonomeProbability, 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 autonomeAligning 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 autonomeStructuring 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 autonomeGeneral-purpose language common in scripting, back-end services, automation and data work.
- The Python Tutorial (official) (reading, gratuit)
Product Analytics
niveau cible : maîtrise solide et autonomeMeasuring 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 pratiquesDesigning 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 pratiquesHandling personal data lawfully, including privacy by design and data-subject rights.
- General Data Protection Regulation (official text, EUR-Lex) (reading, gratuit)
Exemples de questions d’entretien
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Data Scientist9 compétences communes (75% du profil de ce poste)
- Customer Success Manager6 compétences communes (50% du profil de ce poste)
- Financial Controller5 compétences communes (42% du profil de ce poste)
- Marketing Manager5 compétences communes (42% du profil de ce poste)
- Sales Account Executive4 compétences communes (36% du profil de ce poste)
Comparez votre CV aux offres de Data Analyst à l’aide d’une grille transparente.
Essayer l’analyseur d’adéquation