JOB TEMPLATE

Data analyst job description template

A data analyst job description template to copy for junior hires: duties, tools, skills and pay fields, with tips and a SQL test to pair with the role.

The short answer

This data analyst job description template gives you a fair, ready-to-edit starting point for hiring junior analysts: what the role involves, an example of the work, the essential requirements and how your hiring process works. Copy it, name your data, tools and pay, and keep only requirements the role truly needs.

Replace the placeholders and review the template against the actual role and local requirements before use.

Junior Data Analyst
[COMPANY NAME] · [LOCATION / REMOTE ARRANGEMENT] · [SALARY RANGE] · [EMPLOYMENT TYPE]

About the role
Find curious analysts who can query the data and explain what it actually says. You will work with [TEAM / MANAGER] to deliver [PRIMARY OUTCOME].

What you will do
- Query data in the context of our daily work.
- Check assumptions in the context of our daily work.
- Explain numerical results in the context of our daily work.
- Keep colleagues informed about progress, questions and blockers.
- Check your work and respond constructively to feedback.

An example of the work
Use a sample sales table to calculate weekly revenue and explain how you handled missing entries.

What you will need
- Evidence that you can perform the core tasks described above.
- Clear communication appropriate to the role.
- Willingness to ask questions and learn our systems.
[ADD ONLY JOB-RELEVANT REQUIREMENTS]

Nice to have
[OPTIONAL SKILLS THAT ARE NOT SCREENING REQUIREMENTS]

What we offer
[SALARY, BENEFITS, WORKING HOURS, EQUIPMENT AND DEVELOPMENT]

Our application process
Apply through [APPLICATION LINK] by [DEADLINE]. We expect [STAGES AND APPROXIMATE TIME]. Any assessment will focus on the work described here. We will explain permitted tools and monitoring before you start.

Accommodations
Contact [EMPLOYER CONTACT] if you need an adjustment or alternative format.

Privacy
Read [EMPLOYER PRIVACY NOTICE] for how your application information will be used.

Before publishing
Replace all placeholders, review pay transparency and local employment requirements, and remove any requirement that is not essential to the actual job.

How to customise this template

Start with the questions the analyst will help answer, such as which products sell best or where customers drop out. Then name the data sources and tools, the main audiences for their work and who will review it.

Be careful with tool lists. Ask for the tools the person needs in the first months and mark the rest as nice to have. A long list of languages and platforms puts off capable junior candidates who could learn them quickly.

What to include: data analyst duties

Typical data analyst duties include pulling data from databases and spreadsheets, cleaning and checking it, building simple reports and dashboards, answering questions from colleagues with numbers, spotting trends or problems and explaining results in plain language. Pick the tasks that match your team and name the tools, such as SQL, Excel or a dashboard product.

A junior data analyst job description should be realistic about the starting point. List the data analyst responsibilities in the first six months, such as maintaining weekly reports, and the ones that come later, such as designing new analyses, so candidates understand how the role grows.

Must-have vs nice-to-have

Must-have (screen on these):

  • Comfort with numbers, percentages and basic statistics
  • Querying or working with data in SQL or spreadsheets
  • Checking data for errors and missing values before drawing conclusions
  • Explaining results clearly to people who are not analysts

Nice to have (mention, but do not screen on these):

  • Experience with your dashboard or BI tool
  • Python or R for analysis
  • Knowledge of your industry or data

Keep the must-have list short. Every extra requirement removes candidates, and requirements that are not needed for the work can screen out good junior analysts unfairly. If a skill can be learned in the first few weeks, it belongs under nice to have.

Skills to test for this role

The junior data analyst assessment bundles three tests that take about 52 minutes in total:

  • Numerical Reasoning (12 minutes) shows how accurately the candidate works with percentages, rates and tables.
  • SQL Coding: Querying (30 minutes) asks for one working SQLite query, checked on hidden versions of the data, the kind of query the role needs.
  • Microsoft Excel Intermediate (10 minutes) shows how well they use lookup and conditional formulas, sorting, filtering, tables and pivot tables.

Use the same skills in three places: the requirements in the advert, the tests you send and the questions you ask. The data analyst interview questions follow the same skills, and the template's example of the work doubles as a work sample. Send every applicant who meets the essential requirements the same tests, then interview the strongest.

Writing a fair, inclusive advert

Ask only for what the job needs. Avoid requiring a degree or a set number of years of experience unless the work truly demands it, and avoid wording that suggests a particular age, gender or background. State the pay range if you can, say how candidates can request adjustments and describe the hiring process, including any skills test and how long it takes. Our hiring process for small businesses covers the advert step alongside the rest of the process.

After you publish the advert

Send every applicant who meets the essential requirements the same short skills test, then invite the strongest to a structured interview. Score each interview on the same interview scorecard, with criteria taken from the duties in this data analyst job description template, so the advert, the test and the interview all measure the same job. Our guide to structured interviews explains how to write and score the questions. For more templates, see the job description templates library.

Frequently asked questions

What should a junior data analyst advert include?+

The questions the analyst will help answer, the data sources and tools, the main duties, who reviews the work, hours and pay, and the hiring process with any test or task. Mark tools that can be learned on the job as nice to have.

What skills should a data analyst job description list?+

Comfort with numbers, querying data in SQL or spreadsheets, checking data quality and explaining results clearly. Keep the tool list to what the role uses in its first months.

Should a junior analyst role require a degree?+

Only if the work truly needs it. Many capable analysts learned SQL and spreadsheets through courses or previous jobs. A short SQL test and a data task check skill more directly than a qualification.

What tasks work as a data analyst work sample?+

A small table with a few problems, such as missing entries or duplicates, and a question to answer. Ask the candidate to explain the checks they made, then discuss the result in the interview.

How do I describe data analyst responsibilities for a junior hire?+

Separate what the analyst does from day one, such as maintaining reports and answering simple questions, from what they grow into, such as new analyses and dashboards. A clear path helps candidates judge the fit.

Turn the advert into a fair first round

Send applicants a short skills test and interview the strongest. Free for three candidates.

Start freeSee the role bundleFree plan. No credit card.

About the editorial team

Written and fact-checked by the HireValid editorial team. Sources checked . Read the editorial policy.

LESS GUESSWORK. MORE GOOD PEOPLE.

AI can polish an answer.
Hire for the ability behind it.

Explore advanced hiring assessments and integrity tools built for the AI era.

Start freeOr try a sample test No credit card. No annual commitment.