Data analyst job requirements: what employers actually ask for

By the RoleMath Editorial Team · Last updated 2026-06-18. Every figure traces to a cited source; we sell none of the options discussed. Draft pending human review.

Of every role we analyzed, data analyst had the clearest message of all: employers barely name certificates, and name tools relentlessly. In a sample of public job postings we scanned (via the Greenhouse, Lever, Ashby, The Muse, and Workday public hiring APIs) for data analyst roles (about 103 postings), a specific certification was almost absent, while a tight cluster of analysis tools appeared again and again. Here is what the real "data analyst job requirements" look like - and why a portfolio beats a badge here.

Key takeaways

• Employers almost never named a specific certificate (PMP appeared just twice) - data analyst hiring is tools-and-portfolio first.
• The tools they listed most were SQL (79), Python (55), Tableau (49), Looker (38), Excel (37), and Power BI (32).
• A professional certificate is a fine way to learn, but a few real analyses you can show beat any single credential.
• The occupation this maps to (Business Intelligence Analysts, O*NET 15-2051.01; BLS wage published under Data Scientists, SOC 15-2051) has a national median wage of $120,230 (BLS OEWS May 2025).

Why data analyst postings rarely name a certificate

In a sample of public job postings we scanned (via the Greenhouse, Lever, Ashby, The Muse, and Workday public hiring APIs), certifications were conspicuously absent - the only one with multiple mentions was PMP (2), which is a project-management credential, not an analytics one.

That is the honest headline: there is no certificate employers broadly require for data analyst roles, and anyone implying otherwise is usually selling one. This is employer language from a sample of public postings - not a measure of demand, a formal requirement, or a salary signal. A structured course or professional certificate (for example, the Google Data Analytics certificate) is a perfectly good way to learn the tools and build first projects - just understand its value is the skills and portfolio it helps you build, not a credential employers screen for.

• What the Google Data Analytics certificate covers
• Are IT certifications worth it?

Which tools do data analyst employers list most?

If certificates were absent, tools more than made up for it. Most named:

• SQL (79) - the clear number one; nearly every analyst role expects it.
• Python (55), Tableau (49), Looker (38), Excel (37), and Power BI (32).
• Plus general data analysis (18) as a theme.

The path this implies is concrete and cheap: learn SQL well, pick one visualization tool (Tableau Public and Power BI Desktop are free), add Python for heavier work, and build three or four analyses on public datasets you can talk through. That portfolio is what these postings are really asking for.

• How to become a data analyst

Degrees, portfolios, and pay

A degree was sometimes preferred in these postings but frequently not mandatory, especially when a candidate could demonstrate analysis on real data. That makes a portfolio the highest-leverage thing you can build - it substitutes for both a degree and a certificate in many screens.

Data analyst maps to the O*NET occupation Business Intelligence Analysts (15-2051.01), whose wage BLS publishes under Data Scientists (SOC 15-2051), national median $120,230 (BLS OEWS May 2025). As always we keep pay at the occupation level, not as a promise tied to a course - the cited role page has the full range and outlook.

• Data analyst salary (occupation-level, cited)
• Data analyst role overview

Frequently asked questions

What certifications do you need to be a data analyst?

Essentially none are broadly required - in our posting sample, employers almost never named a specific analytics certificate. A professional certificate like Google Data Analytics is a good way to learn the tools and build projects, but its value is the skills and portfolio, not a credential employers screen for. No certificate guarantees a job.

What skills do data analyst jobs require?

Employers listed SQL most often, followed by Python, Tableau, Looker, Excel, and Power BI. This is employer language from a sample, not a formal requirement, but SQL plus one visualization tool plus a few real analyses is the cluster these postings keep asking for.

Do you need a degree to be a data analyst?

Often not. A degree was sometimes preferred but frequently optional in the postings we scanned, especially when a candidate could demonstrate analysis on real data. A strong portfolio is the highest-leverage substitute.

Is the Google Data Analytics certificate worth it?

It can be, as a structured way to learn SQL, spreadsheets, and visualization and to build first projects. Just set expectations correctly: its value is the skills and portfolio it helps you build, not a credential employers broadly require.

Related, with the cited detail

• Data analyst role overview
• How to become a data analyst
• The cited data certification roadmap
• Start the RoleMath planner

Sources

Figures in this article are cited to the sources named in the Citation Ledger below and on each linked cited page. This page stays draft_noindex pending human citation review.

Citation Ledger