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


Next step: If your leaders lack reliable weekly numbers, meet a vetted bilingual data analyst in your time zone. Book a discovery call →
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.
A data analyst turns raw data into decisions. In a typical week, the work follows the same loop:
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.
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:
Requirements:
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.
“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:
| Level | Main output | Core tools | SQL | Closest US wage reference |
|---|---|---|---|---|
| 1. Report | Dashboards and recurring KPI reports that leaders read every week | Excel or Sheets, Power BI or Looker Studio, Google Analytics, the CRM | Nice to have | Market research analysts: $37.87/hr median |
| 2. Question | Answers to specific business questions: why sales dropped, which promotion worked, how much to order | Advanced spreadsheets, a BI tool, working SQL | Working level | Operations research analysts: $42.76/hr; management analysts: $48.97/hr |
| 3. Pipeline | A clean, modeled, documented database that other people can query | SQL on BigQuery, Snowflake or Postgres, Looker or Metabase, sometimes dbt or Python | Strong, required | Business 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 →
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 for | Posts |
|---|---|
| Reports or dashboards | 4 of 4 |
| SQL mentioned | 3 of 4 (required in 1) |
| Power BI | 2 of 4 |
| Excel or spreadsheets named | 2 of 4 |
| Google Analytics | 2 of 4 |
| Documentation of data or processes | 2 of 4 |
| Forecasting | 1 of 4 |
| Automating recurring reports | 1 of 4 |
| Python (as a plus) | 1 of 4 |
| Part-time (a 4-hour daily block) | 2 of 4 |
| English at C1 or above | 4 of 4 |
| Applicants per post | Median 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.
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:
| Require | Prefer | Leave out or teach |
|---|---|---|
| Advanced Excel or Google Sheets | Your exact BI tool | A specific degree |
| One BI tool at a working level | SQL, for a level 1 role | Your metric definitions |
| SQL, for a level 2 or 3 role | Python or R | Machine learning, unless it is a data science job |
| Clear written English for non-technical readers | Experience in your industry | Certificates 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.
| Data analyst | Business analyst | Data scientist | |
|---|---|---|---|
| Main question | What happened, and why? | What should the process or system do? | What will happen, and can a model predict it? |
| Main output | Dashboards, reports, analyses | Requirements, process maps, specs | Models, experiments, forecasts |
| Typical tools | Spreadsheets, BI tools, SQL | Spreadsheets, diagrams, project tools | Python or R, SQL, statistics libraries |
| Hire this one when | Leaders lack reliable numbers | A process or system change needs defining | You 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.
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 occupation | Median hourly | Median annual | Loaded with benefits |
|---|---|---|---|
| Market research analysts and marketing specialists (13-1161) | $37.87 | $78,760 | About $112,500 |
| Operations research analysts (15-2031) | $42.76 | $88,940 | About $127,100 |
| Management analysts (13-1111) | $48.97 | $101,860 | About $145,500 |
| Statisticians (15-2041) | $50.79 | $105,650 | About $150,900 |
| Business intelligence analysts (15-2051.01, reported with data scientists) | $57.80 | $120,230 | About $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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.