219: I Analyzed 11,000 Data Jobs to See What Skills Actually Get You Hired

Speaker: 00:00:00

When I was first starting out in data

analytics, I felt extremely confused

2

: 00:00:03

about what skills I should be focusing.

3

: 00:00:06

And honestly, I wasted a lot of

hours learning the wrong ones, and

4

: 00:00:10

I don't want that to happen to you.

5

: 00:00:12

Everyone has different opinions on

what they think are the right skills,

6

: 00:00:16

but what does the data actually say?

7

: 00:00:18

So I analyzed 11,060 real data job

postings to find out what skills are

8

: 00:00:24

actually most in demand and which

ones are just a waste of your time.

9

: 00:00:28

And yes, I did a similar analysis

about a year and a half ago, and about

10

: 00:00:31

110,000 of you guys turned in, so

thank you so much for supporting me,

11

: 00:00:36

but a lot has changed since then, so

I figured it was time for an update.

12

: 00:00:39

The first of which is that many of you

told me that I was too slow to actually

13

: 00:00:43

get to the point, and thank you, I

listened, so here is the data So let's go

14

: 00:00:48

ahead and start with last year's numbers

because it's important to set a baseline

15

: 00:00:51

to see how things have changed in 2026.

16

: 00:00:54

So in the spring of 2025, I analyzed

almost 3,000 different data analyst jobs,

17

: 00:01:00

and here's what the ranking looked like.

18

: 00:01:01

We had Excel on top at 39%, SQL in

second place at 31%, Tableau in third

19

: 00:01:07

place at 21%, Python in fourth at 14%,

and then finally Power BI in fifth

20

: 00:01:13

at 13%, and R at the bottom at 8%.

21

: 00:01:16

And this is the amount of times

those skills or tools were listed

22

: 00:01:20

in all of the job descriptions.

23

: 00:01:22

Now, let's look at how these numbers

have changed since then, starting with R.

24

: 00:01:25

So last year, R was at 8%, and this

year it's actually halved to 4%.

25

: 00:01:31

I know some of you guys learned R

first, especially if you had some

26

: 00:01:34

sort of a stats or economics degree,

and really it's a fine language.

27

: 00:01:39

I really like it, especially for

statistics, but the market is clearly

28

: 00:01:43

moving away from it, so keep that in

mind because the next tool that we're

29

: 00:01:46

gonna talk about might replace literally

every single tool on this list, and

30

: 00:01:50

it wasn't even on the list last year

because it is AI, and AI and large

31

: 00:01:56

learning model skills literally didn't

have much demand say two months ago.

32

: 00:02:00

Like, there wasn't really much evidence

of it being on job descriptions,

33

: 00:02:03

and this year it's all the way up

to 11% of all data job postings.

34

: 00:02:08

So for our data set, that is

over 1,000 different jobs.

35

: 00:02:11

One in every 10 jobs have some sort of AI

or LLM mentioned in the job description.

36

: 00:02:16

And just think about that for a second.

37

: 00:02:18

A skill that really didn't even

exist 18 months ago has already

38

: 00:02:22

passed R, AWS, Snowflake in

terms of popularity and demand.

39

: 00:02:27

Analyzing data with some sort

of AI or LLM tool is only going

40

: 00:02:31

to get more and more in demand.

41

: 00:02:33

But the cool part is it's one

of the easiest things on this

42

: 00:02:36

entire list to start learning.

43

: 00:02:37

Like, you literally just use

language to actually do analysis.

44

: 00:02:41

So you have to become good at prompting,

and that's kind of it, and it's a

45

: 00:02:44

little bit more nuanced than that, you

know, knowing what to analyze when,

46

: 00:02:48

and, like, what type of analysis to

do, and how to actually double-check

47

: 00:02:51

and validate the LLM's answers.

48

: 00:02:53

Those things are really

important, but you can learn them.

49

: 00:02:55

And the cool part is

they're new to everyone.

50

: 00:02:58

Like, these are skills that

we really haven't been using,

51

: 00:03:00

even senior data analysts.

52

: 00:03:02

So we're almost all learning

it at the exact same time, and

53

: 00:03:05

almost nobody applying has these

tools listed on their resume.

54

: 00:03:08

So right now that's a big advantage

to you, and it's one of the reasons

55

: 00:03:11

I'm trying to cover AI in my

episodes, to give you the upper hand.

56

: 00:03:15

So make sure you hit subscribe

so you keep up to date on all the

57

: 00:03:18

latest of AI in data analytics.

58

: 00:03:21

All right.

59

: 00:03:21

Next we have Python, and

Python went from 14% to 20%.

60

: 00:03:26

So if you've ever been

thinking, "Oh, should I learn

61

: 00:03:28

Python or should I learn R?"

62

: 00:03:29

Well, just look at this chart.

63

: 00:03:31

The debate is kind of over.

64

: 00:03:32

If you're picking one scripting language

to learn from scratch in: 2026

65

: 00:03:36

probably gotta be Python, unless

you're going to be doing some sort

66

: 00:03:39

of specialized government contract

work or pure statistics or biology or

67

: 00:03:43

pharmaceuticals or something like that.

68

: 00:03:44

But otherwise, you're going

to be choosing Python.

69

: 00:03:46

I think Python is the scripting

language to learn right now Next

70

: 00:03:49

up, we have Tableau, and Tableau

is up slightly from 21% to 24%.

71

: 00:03:54

It's still a great in-demand

business intelligence tool.

72

: 00:03:57

And just keep track of this number for one

second because the next tool right above

73

: 00:04:01

it is something I kind of need to come

clean about and admit to you because last

74

: 00:04:04

year, Power BI was near the bottom at 13%.

75

: 00:04:07

And I literally told you in the video,

if you think Power BI is more common

76

: 00:04:11

than Tableau, well, then argue with

me in the comments because that's

77

: 00:04:14

not the case according to the data.

78

: 00:04:16

Well, according to the data this

year, I was wrong last year.

79

: 00:04:19

Power BI somehow has doubled from

13% to 26%, meaning one in every

80

: 00:04:25

four data analyst jobs mention Power

BI, and it just surpassed Tableau.

81

: 00:04:29

My read on why, it's probably because

Microsoft Power BI is bundled into the

82

: 00:04:34

stack that most companies already pay for,

like their 365 subscription or everything.

83

: 00:04:37

So it's just, like, free, and

Tableau's kind of expensive.

84

: 00:04:40

Plus, Power BI is doing a pretty

decent job of integrating AI,

85

: 00:04:43

more than Tableau for sure.

86

: 00:04:45

And I still think learning Tableau

is really valid because who knows?

87

: 00:04:48

Like, next year, Tableau might be

slightly more popular than Power BI.

88

: 00:04:51

You never know.

89

: 00:04:52

And you still can't really

use Power BI on a Mac, and the

90

: 00:04:55

free version's super confusing.

91

: 00:04:56

So I personally, like, don't

really give a whole lot of

92

: 00:04:59

credence to just 2% more popular.

93

: 00:05:01

I still think Tableau's a little

bit easier to get started with.

94

: 00:05:03

All right, moving on to number

two, and it is SQL, which is moving

95

: 00:05:07

up from 31% to 38% of listings.

96

: 00:05:11

And SQL is really the backbone of

basically every data job that exists.

97

: 00:05:15

Data analysts, data scientists,

data engineers, they all use

98

: 00:05:18

SQL, and it's a great tool, and

it's not going anywhere at all.

99

: 00:05:21

And the good news here is it's not super

hard to learn, which actually brings us

100

: 00:05:25

to something that's super easy to learn,

and that is number one, which is Excel.

101

: 00:05:29

And Excel is now at 49%,

when it was at 39% last year.

102

: 00:05:34

It is by far the analytics tool king.

103

: 00:05:37

It didn't only just hold the top spot.

104

: 00:05:39

It grew more popular and pulled even

further away from SQL in second place.

105

: 00:05:43

Basically, every other data job, one

in two data jobs literally list Excel.

106

: 00:05:48

So it's maybe boring, it may

be old, but it's getting more

107

: 00:05:52

important, not less important.

108

: 00:05:53

Spreadsheets have been around

for 50-plus years, and they've

109

: 00:05:56

survived that long for a reason.

110

: 00:05:58

I think they're going to be part of

our future, even with AI and all the

111

: 00:06:01

other things that are coming out.

112

: 00:06:02

And now, since I was able to

actually build out the data pipeline

113

: 00:06:05

of getting all these jobs from my

own job board, findadatajob.com,

114

: 00:06:09

and do a little bit better analysis

than I was 18 months ago, we actually

115

: 00:06:12

also included a bunch of other

things that we're tracking now,

116

: 00:06:15

things like Snowflake, DBT, SAS.

117

: 00:06:18

And I don't really talk about

these for a specific reason.

118

: 00:06:21

There's really not in that demand for most

entry-level and intermediate data jobs.

119

: 00:06:25

But is…

120

: 00:06:26

Here's the numbers if you're curious.

121

: 00:06:28

You have AWS at 8%, Snowflake at

6%, Azure at 5%, Looker at 5%.

122

: 00:06:34

There's R all the way down there at

4%, followed by SAS at 4%, Databricks

123

: 00:06:39

at 3%, and Google Analytics at 3%.

124

: 00:06:42

And if you're listening audio only and

you're like, "I can't see any of these

125

: 00:06:45

charts," well, you can actually pause the

episode and go to dataanalystskills- .com

126

: 00:06:50

to see basically these exact charts

that I'm showing for the audio audience.

127

: 00:06:54

So even with all that data

and all that information, what

128

: 00:06:57

should you actually be focusing?

129

: 00:06:58

And honestly, let's make it dead simple.

130

: 00:07:00

All those other opinions you've heard from

Reddit, from your buddies, from random

131

: 00:07:04

YouTubers and podcasters, in my opinion,

here is the optimal order backed by data.

132

: 00:07:08

Start with Excel.

133

: 00:07:09

It's literally the most in-demand

data tool that there is, and

134

: 00:07:12

it's also the easiest to learn.

135

: 00:07:14

Then move to a business intelligence

tool like Power BI or Tableau.

136

: 00:07:17

They're both highly in demand

and pretty easy to learn, drag

137

: 00:07:20

and drop, clicking type stuff.

138

: 00:07:21

But just choose one.

139

: 00:07:22

Don't try to do both of

them at the same time.

140

: 00:07:24

They're basically the same, and

once you master one, picking up

141

: 00:07:27

the other will be fairly easy.

142

: 00:07:28

Next, learn SQL.

143

: 00:07:29

It's obviously a little bit harder than

Excel, Power BI, or Tableau, but it's

144

: 00:07:33

very in demand, and it's much easier than

a scripting language like Python or R.

145

: 00:07:37

Speaking of which, I recommend

that you skip both when you're

146

: 00:07:39

trying to land your first data job.

147

: 00:07:41

Hot take, I know.

148

: 00:07:42

They both have a steep learning curve,

and they're really not all that in demand

149

: 00:07:45

right now, so just skip them right now.

150

: 00:07:46

Finally, don't forget to start playing

with AI tools because personally, even

151

: 00:07:51

though they're only at eleven percent

right now, I think down the road, that's

152

: 00:07:54

going to probably double by the end of

the year and be twenty percent, and who

153

: 00:07:57

knows what the next year will bring.

154

: 00:07:58

Now, you might be listening and

being like, "Ah, Avery, how do

155

: 00:08:01

you actually know all this?"

156

: 00:08:02

Like, "Where do you

actually get this data?

157

: 00:08:03

Is it valid?

158

: 00:08:04

Can I trust this data?"

159

: 00:08:05

And the truth is, I really got this

data from the real world because a

160

: 00:08:09

couple of years ago, I launched my free

data job board called finddat job.com,

161

: 00:08:14

which is where you can find data jobs.

162

: 00:08:17

I mean, an original name, I know.

163

: 00:08:19

And I set it up where I literally analyze

the keywords, the tools mentioned in each

164

: 00:08:23

one of the different job descriptions for

every job that we post on our job board.

165

: 00:08:27

And that's where I got these

real percentages instead of just

166

: 00:08:30

kinda like my meager opinions.

167

: 00:08:32

And keep in mind that I might consider

a data analyst job different from

168

: 00:08:35

what you may or someone else may.

169

: 00:08:37

Really, I dump the whole data

analyst job in the data job family.

170

: 00:08:41

So I lump in financial analyst

roles, business analyst roles,

171

: 00:08:43

healthcare analyst roles, etc.

172

: 00:08:45

I don't include data scientist

roles or data engineer roles

173

: 00:08:47

because those are different enough.

174

: 00:08:48

But basically, any sort of data

analyst role, despite the many

175

: 00:08:52

names for data analyst, will

be included in this data set.

176

: 00:08:54

And based off that knowledge, you

might be thinking, "Avery, that's dumb.

177

: 00:08:57

I don't like the way that you did that."

178

: 00:08:58

And in fact, I got several comments

that basically just said the

179

: 00:09:02

same thing from my last episode.

180

: 00:09:04

And my reply was, "Okay, great.

181

: 00:09:06

That's fine.

182

: 00:09:07

Go out there and do your own analysis

and let me know what you find."

183

: 00:09:09

None of those commenters

took me up on that.

184

: 00:09:11

But guess what?

185

: 00:09:12

Now you can take me up on that because

I made it easier for you to do it.

186

: 00:09:16

So you can actually go

to dataanalystskills.com,

187

: 00:09:19

which gives you the ability to

Look at this data set in a couple

188

: 00:09:22

different bar chart ways and split

it by a couple different filters.

189

: 00:09:25

For instance, different job families.

190

: 00:09:27

Like, maybe you just want to

see what's the most in-demand

191

: 00:09:29

role for a healthcare analyst.

192

: 00:09:30

You can look that up.

193

: 00:09:31

Uh, maybe you want to see, like, oh, this

is for all data analyst experience levels,

194

: 00:09:34

but what about senior data analysts?

195

: 00:09:36

Well, that's available

at dataanalystskills.com.

196

: 00:09:39

You can even do it by, oh, what about

remote versus in person, or different

197

: 00:09:43

locations inside the United States?

198

: 00:09:45

That way you can see the

stats for whatever subset or

199

: 00:09:47

filters you're interested in.

200

: 00:09:48

Plus, that actually has live data

that updates every day, so if anything

201

: 00:09:53

changes from now until, you know,

who knows when, you'll be able to see

202

: 00:09:56

those live changes on the website.

203

: 00:09:58

So please make sure to bookmark it

right now, dataanalystskills.com,

204

: 00:10:01

which is hosted on my personal job board

for finding data jobs, findadatajob.com.

205

: 00:10:06

I hope both will help you

find your next data job

Share Episode

Shownotes

Transcripts

Follow

Links

Chapters

Video

More from YouTube