What the title covers
What stays constant is that you work with the company's data and produce something another person acts on. What changes is which part of that you spend your time doing. Reporting work builds and maintains dashboards so people can see numbers without having to ask. Analysis work takes one question and answers it, which means locating the data, deciding whether it can be trusted, and explaining what it does and does not show. Pipeline work builds the routes that move data out of the systems that create it and into somewhere it can be queried. Most postings mix two of the three. In every version, a large share of the day is spent discovering that the data is wrong.
A second use of this title
The tools named in a posting tell you which version it is, more reliably than the description does. SQL alongside Tableau, Power BI or Looker describes reporting work. Python or R alongside statistics, experiments or testing describes analysis work. Airflow, dbt, warehouses or the letters ETL describe pipeline work. A posting listing all of them is either a small team where one person does everything or a company that has not decided what it wants.
The difference matters because the three lead to different places. Reporting leads toward business intelligence and eventually toward running an analytics team. Statistical analysis leads toward data science. Pipeline work leads toward data engineering, which pays the most of the three and is the hardest to move into later if you did not start there.
Where it is found
Every industry now employs them, which is why the title has stretched to cover so much.
Typical entry requirements
- Education
- Bachelor's degree. Statistics, economics, mathematics, business and computer science are common, though people arrive from many majors
- Expected
- SQL. This appears in nearly every posting regardless of which version of the job it is
- Frequently required
- A dashboard tool such as Tableau, Power BI or Looker
- Often listed
- Python or R, most seriously at employers where the work leans toward statistics
- Experience
- Zero to two years. A portfolio built on real public data carries unusual weight here, sometimes more than the degree