What the title covers
Work that involves taking a business question, finding the data that answers it, and presenting the answer to the people making the decision. The analysis is usually done in Excel or SQL, and the output is usually a report, a dashboard, or a recommendation.
A second use of this title
At software companies and IT consulting firms, Business Analyst frequently describes a role that gathers requirements from users and documents them for engineering teams. That work involves interviews, written specifications, and process mapping rather than data analysis.
Both roles use the same title. The responsibilities section of a posting identifies which one it describes.
Where it is found
Most companies above a few hundred employees, which is why the title appears in so many different contexts.
Typical entry requirements
- Education
- Bachelor's degree, commonly economics, statistics, information science or business
- Expected
- Excel, including lookup formulas and pivot tables
- Frequently required
- SQL, at a level sufficient to write a query joining a few tables
- Often listed
- Experience with a dashboard tool such as Tableau, Power BI or Looker
- Experience
- Zero to two years. Internships and coursework projects count toward this