Data Analyst Job Description: Template, Duties and What a Data Analyst Does (2026)

November 20, 2026
Data Analyst Job Description: Template, Duties and What a Data Analyst Does (2026)
Contributors
Virtustant blog author
CMO at Virtustant

Alan Schultz is the Chief Marketing Officer at Virtustant, leading content, SEO, and AI search visibility for the remote and nearshore staffing category. He writes about hiring, managing, and scaling LATAM remote teams. Figures credited to Virtustant come from its placement records.

Connect with Alan on LinkedInAuthor profileHow we research and review
Published
November 20, 2026
Updated
  • A data analyst collects, cleans and analyzes data, builds dashboards and recurring reports, and explains what the numbers mean with a recommendation.
  • The Report, Question, Pipeline test: decide whether the job is mainly dashboards, answering business questions or maintaining the database, and match the tools, SQL level and pay to it.
  • In four data analyst posts run through Virtustant, all four asked for reports or dashboards; SQL was mentioned in 3 and required in 1; two were part-time, four hours a day. They drew a median of 512 applicants.
  • Only 2 of 10 analyst searches in our records were a standalone “Data Analyst”; the rest tied analysis to sales, marketing, media, operations or a store.
  • There is no single federal code for the role; the closest US medians run from $78,760 to $120,230 a year (BLS 2025 wage data).

Next step: If your leaders lack reliable weekly numbers, meet a vetted bilingual data analyst in your time zone. Book a discovery call →

Key Takeaways

A data analyst collects, cleans and analyzes a company's data to answer business questions: building the dashboards and recurring reports leaders use, spotting trends in sales, marketing or operations, and turning numbers into recommendations someone can act on. A data analyst job description should say which data the analyst works with, which tools they use, which questions they answer first, and how deep into the data pipeline the job goes.

Below you get a copy-and-paste data analyst job description template, the core responsibilities, the Report, Question, Pipeline test for deciding how technical the role really is, what data analysts earn in 2026, and what the analyst job posts run through Virtustant actually asked for. One finding to start: SQL appeared in 3 of the 4 data analyst posts we read in full, but only 1 made it a requirement. Every one of them asked for reports or dashboards.

Need a data analyst more than a job post?

Tell us your data sources and the questions you need answered on a 30-minute discovery call. Virtustant scopes the role, screens the applicants and sends a shortlist of 3 to 5 vetted, bilingual analysts within 48 hours, with zero placement fees.

Get your shortlist → See data analyst profiles

Table of contents

What Does a Data Analyst Do?

A data analyst turns raw data into decisions. In a typical week, the work follows the same loop:

  1. Collect: pull data from the systems that hold it, such as the CRM, the store, ad platforms, Google Analytics, the accounting system or a database.
  2. Clean: fix duplicates, missing values and mismatched definitions so two reports of the same number agree.
  3. Analyze: look for trends, compare periods, segment customers, test what changed and why.
  4. Report: build and maintain dashboards and recurring reports so leaders see the same numbers every week.
  5. Recommend: explain what the numbers mean in plain language and what to do next.
  6. Automate: replace the copy-paste behind recurring reports with scheduled queries and connected tools.
  7. Document: write down metric definitions and data sources so the next person can trust the numbers.

The first five steps are in nearly every data analyst job. The last two are where small companies get the most value, and where most job descriptions are silent.

Data Analyst Job Description Template

Copy the template and replace everything in brackets. Keep the “Data and tools” and “First questions” lines: they tell candidates exactly what the job is.

Job title: Data Analyst ([Reporting / Sales / Marketing / Operations]) (Remote, [Full-time / Part-time, 20 hours a week], [time zone])

About us: [Company] [does what, for whom]. Our data lives in [Shopify, HubSpot, QuickBooks and Google Analytics], and today our reports are [built by hand in spreadsheets every Monday].

Role summary: You will own our numbers: the dashboards leaders check every week, the analysis behind our biggest decisions, and the clean, documented data that makes both possible. You report to [name, title].

Data and tools: [Excel / Google Sheets], [Power BI / Looker Studio / Looker], [SQL on BigQuery / Postgres], [Google Analytics 4, HubSpot]. [Python is a plus.]

First questions you will answer: [Which channels bring our most profitable customers?] [Where do trial users drop off?] [How much inventory do we need for Q1?]

Responsibilities:

  • Build and maintain dashboards for [sales, marketing and operations] in [Power BI], refreshed [daily].
  • Deliver a weekly KPI report to the leadership team every [Monday by 10:00 a.m.].
  • Pull, clean and join data from [our CRM, store and ad platforms].
  • Analyze trends and run ad hoc analyses within [2 business days] of a request.
  • Automate recurring reports to remove manual spreadsheet work.
  • Maintain a data dictionary: every metric's definition, source and owner.
  • Present findings in plain language with a recommendation, not just a chart.

Requirements:

  • [2+] years in data analysis, business intelligence or a similar role.
  • Advanced [Excel / Google Sheets] and one BI tool ([Power BI / Looker Studio / Tableau]).
  • [Working / strong] SQL. [Required only if the job includes database work.]
  • Clear written English (C1 or above) for explaining findings to non-technical people.
  • Attention to detail: you check a number before you share it.

Schedule: [Monday to Friday, 9:00 a.m. to 1:00 p.m. Eastern, 20 hours a week], with [a weekly review] with [name].

Pay: [$ to $ per hour or per year]. [Benefits, if any.]

What success looks like at 90 days: the weekly KPI report goes out on time with no manual copy-paste; [three] dashboards are live and used; the data dictionary covers every metric in them; one analysis has changed a decision.

How to apply: Send your resume and a short answer: [here is a sample of our monthly sales data; what are the first three things you would check, and why?].

Several US states and cities, including California, Colorado, Illinois, New York and Washington, require a pay range in job postings, so check the rules where you hire. This is not legal advice.

The template is the easy part. Expect 500 applicants.

The data analyst posts in our records drew a median of 512 applicants each, and up to 754. Virtustant screens them against your data, tools and questions and sends only 3 to 5, within 48 hours of your first call.

Book a discovery call → See pricing

The Report, Question, Pipeline Test

“Data analyst” covers three levels of technical depth, and the level decides the tools, the experience and the pay. The easy mistake is to ask for level three in the requirements and offer level one in the work, or the reverse. Before you write the job description, decide which of the three the first six months will mostly be:

LevelMain outputCore toolsSQLClosest US wage reference
1. ReportDashboards and recurring KPI reports that leaders read every weekExcel or Sheets, Power BI or Looker Studio, Google Analytics, the CRMNice to haveMarket research analysts: $37.87/hr median
2. QuestionAnswers to specific business questions: why sales dropped, which promotion worked, how much to orderAdvanced spreadsheets, a BI tool, working SQLWorking levelOperations research analysts: $42.76/hr; management analysts: $48.97/hr
3. PipelineA clean, modeled, documented database that other people can querySQL on BigQuery, Snowflake or Postgres, Looker or Metabase, sometimes dbt or PythonStrong, requiredBusiness intelligence analysts: $57.80/hr

Write the level into the title (“Data Analyst, Reporting”) and match the requirements to it. If the honest answer is “level 1 now, level 2 later,” say that, and require SQL only at the working level. In the four posts we read in full, two were mainly Report work, one was Question work (trade promotions and demand forecasts), and one was Pipeline work (rebuilding a BigQuery database). Only that last one required strong SQL.

Not sure which level you need? Bring your data sources and your top three questions to a 30-minute call; we will tell you the level and what it costs. Book the call →

What Real Data Analyst Job Posts Asked For

We looked at every analyst search US companies opened through Virtustant between October 2025 and September 2026, and read in full the four that were mainly data roles: three titled “Data Analyst” and one sales analyst. The companies included a workforce training platform, a consumer e-commerce company, an analytics firm and a packaged-food brand. The sample is small, so read it as a pattern.

What the post asked forPosts
Reports or dashboards4 of 4
SQL mentioned3 of 4 (required in 1)
Power BI2 of 4
Excel or spreadsheets named2 of 4
Google Analytics2 of 4
Documentation of data or processes2 of 4
Forecasting1 of 4
Automating recurring reports1 of 4
Python (as a plus)1 of 4
Part-time (a 4-hour daily block)2 of 4
English at C1 or above4 of 4
Applicants per postMedian 512 (279 to 754)

Across all 10 analyst searches in the period, only 2 were a standalone “Data Analyst”. The other 8 tied the analysis to a function or a second job: a Shopify developer and data analyst, a media and data analyst, and marketing, sales, operations, automation and supply chain analysts. Three lessons for your own post. First, small companies hire analysts for a function, so name it in the title. Second, require SQL only when the work is in the database; otherwise list it as a plus and you will not lose strong reporting analysts. Third, half the data analyst posts were part-time, four hours a day, which is often enough for a level 1 role. Client names, rates and budgets from these records are not published.

Skills and Tools to Require

The three skills that matter most in a data analyst are accuracy (checking a number before sharing it), business sense (knowing which number matters) and explanation (saying what it means in a sentence a manager can act on). Sort the rest by level:

RequirePreferLeave out or teach
Advanced Excel or Google SheetsYour exact BI toolA specific degree
One BI tool at a working levelSQL, for a level 1 roleYour metric definitions
SQL, for a level 2 or 3 rolePython or RMachine learning, unless it is a data science job
Clear written English for non-technical readersExperience in your industryCertificates as a substitute for a work sample

The best screen is a work sample: give candidates a small, anonymized data extract and ask for three findings and one recommendation. It tests every row of the table in an hour.

Analysts already tested for accuracy and English

Every Virtustant candidate passes cognitive (IQ), skills and English testing before you meet them. Tell us your tools and we test for those too.

Meet 3 to 5 in 48 hours → See profiles

Data Analyst vs Business Analyst vs Data Scientist

Data analystBusiness analystData scientist
Main questionWhat happened, and why?What should the process or system do?What will happen, and can a model predict it?
Main outputDashboards, reports, analysesRequirements, process maps, specsModels, experiments, forecasts
Typical toolsSpreadsheets, BI tools, SQLSpreadsheets, diagrams, project toolsPython or R, SQL, statistics libraries
Hire this one whenLeaders lack reliable numbersA process or system change needs definingYou have the data and need prediction

For the other two roles, see our business analyst and data scientist pages. If the work is mostly typing records into systems rather than analyzing them, you need a data entry specialist, not an analyst.

What a Data Analyst Costs in 2026

The federal occupation codes have no single “data analyst” line, so the salary you see quoted depends on which neighboring occupation the source picked. Using BLS 2025 wage data via O*NET:

Closest US occupationMedian hourlyMedian annualLoaded with benefits
Market research analysts and marketing specialists (13-1161)$37.87$78,760About $112,500
Operations research analysts (15-2031)$42.76$88,940About $127,100
Management analysts (13-1111)$48.97$101,860About $145,500
Statisticians (15-2041)$50.79$105,650About $150,900
Business intelligence analysts (15-2051.01, reported with data scientists)$57.80$120,230About $171,800

Loaded cost assumes benefits at about 30% of total compensation (BLS Employer Costs for Employee Compensation). A level 1 reporting analyst sits near the top line, a level 3 pipeline analyst near the bottom one. Virtustant scopes data analyst rates on the first call, because the level and tools decide the profile; the rate is all-in, with zero placement fees and month-to-month terms. How the rate works: if you pay your agent $10/hr, we give them $9 and keep the dollar in the middle. See pricing.

Get a real number for your data analyst

Tell us the level, the tools and the hours. You leave the call with a rate and a timeline, whether or not you hire.

Get a quote → See profiles

Five Mistakes in Data Analyst Job Descriptions

  1. No data sources. “Analyze data” tells a candidate nothing. Name the systems: they decide who can do the job on day one.
  2. Pipeline requirements for a reporting job. Requiring strong SQL and Python for weekly dashboards filters out the people who would do the job best.
  3. No first questions. List the three questions you want answered first. It is the fastest way to show candidates the job is real.
  4. A full-time post for a part-time job. If the work is a weekly report and a few analyses, a 20-hour role is honest and easier to fill.
  5. No work sample. A resume shows tools; a small data exercise shows judgment.

Hiring a Data Analyst Through Virtustant

Virtustant is a remote staffing agency that places vetted, bilingual professionals from Latin America with US companies. A data analyst placement is one named person working the US hours you set, full-time or part-time, inside your tools and data. Candidates come from the top 1% of applicants: 100% apply, 22% clear the recruiter screen, 9% pass cognitive (IQ), skills and English testing, 3% reach a live interview, 1% are hired. You get a shortlist of 3 to 5 within 48 hours of your first call, and your hire can start in 72 hours. Terms are month-to-month, with zero placement fees and a lifetime replacement guarantee with no time cap. See the data analyst role.

Skip the 500 applications. Meet 3 to 5 this week.

Shortlist in 48 hours, start in 72, zero placement fees, lifetime replacement.

Get your shortlist → See profiles

Frequently Asked Questions

What does a data analyst do?

A data analyst collects data from a company's systems, cleans it, analyzes it for trends, builds dashboards and recurring reports, and explains what the numbers mean with a recommendation. At smaller companies, data analysts also automate recurring reports and document metric definitions.

What should a data analyst job description include?

The job title with the function and level, remote status and hours, the data sources and tools, the first questions the analyst will answer, the responsibilities, requirements matched to the level, the schedule and time zone, the pay range and 90-day success measures. A small data exercise in the application screens better than a cover letter.

What are the main responsibilities of a data analyst?

Building and maintaining dashboards, producing recurring KPI reports, pulling and cleaning data from several systems, analyzing trends, running ad hoc analyses, automating manual reporting and documenting data definitions. In four data analyst posts run through Virtustant, all four asked for reports or dashboards.

Does a data analyst need SQL?

It depends on the level. For reporting work built on spreadsheets and BI tools, SQL is a plus; for answering ad hoc questions it should be at a working level; for maintaining a database it is required. SQL appeared in 3 of 4 data analyst posts we read, and was required in 1.

How much does a data analyst make?

There is no single federal code for the role. The closest US medians in BLS 2025 wage data run from $78,760 a year for market research analysts to $120,230 for business intelligence analysts, or about $112,500 to $171,800 loaded with benefits.

What is the difference between a data analyst and a business analyst?

A data analyst works with data to explain what happened and why, through reports, dashboards and analysis. A business analyst works with people and processes to define what a system or process should do, through requirements and process maps. The roles overlap, and small companies often combine them.

What is the Report, Question, Pipeline test?

A way to decide how technical a data analyst job is before writing the job description: a Report analyst builds dashboards and recurring reports, a Question analyst answers specific business questions with working SQL, and a Pipeline analyst models and maintains the database with strong SQL. The level sets the tools, experience and pay.

How fast can I hire a data analyst through Virtustant?

You get a shortlist of 3 to 5 vetted candidates within 48 hours of your first call, and your hire can start in 72 hours, with zero placement fees and month-to-month terms.

Method and Sources

Virtustant data. Ten analyst positions in Virtustant's recruitment system tied to data, sales, marketing, media, operations or supply chain work, opened between October 2025 and September 2026 and deduplicated by company and role, read on 20 November 2026. The four that were mainly data roles were read in full; each item counts once per post when the post states it. Finance, compliance and IT analyst roles were excluded. Client names, rates and budgets are not published.

Public data. BLS 2025 wage data via O*NET, read 20 November 2026: Market Research Analysts and Marketing Specialists, Operations Research Analysts, Management Analysts, Statisticians and Business Intelligence Analysts; BLS Employer Costs for Employee Compensation.

Calculations. Loaded cost: annual median wage ÷ 0.70, rounded to the nearest $100.

Related reads

Source