Data · Job description template

Data Analyst job description template

Most companies already hold the data to answer their biggest questions, but nobody has time to pull it together. The Data Analyst turns existing data into clear answers: agreed metrics, reliable dashboards and analyses that lead to decisions. They are accountable for the business trusting its numbers and using them.

First-year outcomes

What should be visibly different a year from now. Results, not tasks.

  • The core metrics of the company each have one written definition, agreed by leadership and used in every report.
  • Leadership reviews weekly performance in a self-serve dashboard, and one-off requests for those numbers fall by at least half.
  • Routine data requests from teams are answered within 3 working days, with the query and method saved so the work can be repeated.
  • At least three analyses lead to a recorded business decision, such as changing a price, cutting a marketing channel or fixing a step in the sales process.
  • Automated data quality checks run on the main tables and catch broken or missing data before it reaches a report.

The work

Recurring work

  • Write SQL queries to answer questions from sales, marketing, product and operations.
  • Maintain dashboards in a BI tool such as Power BI, Tableau or Looker Studio.
  • Check data quality and investigate numbers that look wrong.
  • Present findings to the teams that asked for them.

Projects

  • Write the metrics dictionary and get leadership to agree it.
  • Build the weekly leadership dashboard.
  • Run a deep-dive analysis on a key question, such as why customers leave.

Decisions they own

  • How to structure an analysis and which data to use.
  • How to present results so the audience can act on them.
  • Which requests to prioritise when several arrive at once, within agreed rules.

People they work with

  • Leadership, to agree metric definitions and what the dashboard must show.
  • Team leads in sales, marketing and operations, who bring questions.
  • Engineers, to get access to data and fix tracking or data issues.
  • Finance, to make sure revenue and cost figures match the accounts.

Requirements

Essential on day one

  • Strong SQL for joining, filtering and aggregating data across tables.
  • Advanced Excel or Google Sheets skills.
  • Experience building dashboards that people use.
  • The ability to explain findings in plain language and say how sure you are.

Helpful, but can be learned

  • The specific BI tool the company uses.
  • How the databases and tracking of the company are structured.
  • Python or R for analysis that goes beyond SQL.

How to assess it

One piece of evidence for each first-year outcome.

OutcomeEvidence to look for
One agreed definition for each core metricAsk how they settled a dispute about what a metric meant. Good describes writing the definition down and getting sign-off.
Self-serve dashboard that cuts one-off requestsAsk to see a dashboard they built, with data removed. Good is simple, answers a clear question and they can say who used it.
Routine requests answered within 3 days and repeatableWork sample: a one-hour SQL exercise on a small sample database. Good is correct, readable and includes a note on assumptions.
Three analyses that lead to recorded decisionsAsk for one past analysis that changed a decision. Good names the question, the finding and what the business did differently.
Data quality checks that catch broken dataAsk about a time a report showed wrong numbers. Good explains how they found the cause and added a check to catch it next time.

Opening for the job ad

We have the data. What we need is someone who turns it into numbers everyone agrees on and answers that change what we do. In your first year you will define our metrics, build the dashboards leadership uses and lead analyses that drive real decisions.

Turning this into an ad? See how to write a job ad that gets applicants.

Next: interview for these outcomes

Eight structured questions for this role, each tied to an outcome above.

Data Analyst interview questions

Similar roles

Your next hire, start to finish, in one place.

Free workspace. No card. Full scoring free for 7 days.