Explore

Business intelligence

Data Analyst

Turning messy spreadsheets into decisions.

Typical pay

$60k-$120k

How you get in

Degree or self-taught SQL, Excel and BI tools

Outlook

Growing

Analysts pull, clean and interpret data to answer business questions. Heavy on SQL and communication, lighter on math than people assume.

A day in the life

  1. 9:00aCheck dashboards for anomalies
  2. 10:00aA stakeholder asks why signups dipped
  3. 11:00aWrite SQL, sanity-check the join
  4. 1:00pBuild the chart, write the takeaway
  5. 3:00pPresent findings, get three new questions
  6. 4:30pAutomate the report

How to get in

Degree plus SQL

Duration

4 years

Cost

$40,000-$150,000+

Credential

Bachelor's in anything quantitative

  1. Finish a degree with real statistics coursework — economics, math, business analytics
  2. Learn SQL properly, then Excel to a genuinely advanced level
  3. Build a portfolio analyzing public datasets end to end
  4. Apply to analyst roles or convert from an internship

Self-taught

Duration

3-9 months

Cost

$0-$3,000

Credential

None — your portfolio is the credential

  1. Learn SQL first — it is most of the job
  2. Add a BI tool (Tableau or Power BI) and enough Python to clean data
  3. Publish three analyses that answer a real question, not a tutorial
  4. Apply to junior analyst and reporting roles

Transfer from inside a company

Duration

1-2 years

Cost

$0

Credential

None — internal track record

  1. Work in operations, support, finance or marketing
  2. Become the person on your team who builds the reports
  3. Automate something visible enough that leadership notices
  4. Move into the open analyst role with domain knowledge others lack

What people love

  • · Entry path into tech without deep coding
  • · Visible impact on decisions
  • · Remote friendly

What wears people down

  • · Lots of ad-hoc requests
  • · Data is always messier than promised
  • · Can be undervalued

From people doing it

Add yours