Artwork for podcast Data Career Podcast: Helping You Land a Data Analyst Job FAST
136: How I Would Become a Data Analyst In 2025 (if I had to start over again)
Episode 13619th November 2024 • Data Career Podcast: Helping You Land a Data Analyst Job FAST • Avery Smith - Data Career Coach
00:00:00 00:16:32

Share Episode

Shownotes

💌 Subscribe To My Newsletter

No fluff, no jargon; just the essentials to kick-start your data analyst career in 2025 with a strategy built for success.

💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://www.datacareerjumpstart.com/newsletter

🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://www.datacareerjumpstart.com/training

👩‍💻 Want to land a data job in less than 90 days? 👉 https://www.datacareerjumpstart.com/daa

👔 Ace The Interview with Confidence 👉 https://www.datacareerjumpstart.com//interviewsimulator

⌚ TIMESTAMPS

00:16 Understanding Different Data Roles

01:48 Essential Data Skills and Tools

04:36 Building Projects to Showcase Skills

08:13 Creating a Portfolio for Your Projects

09:06 Optimizing LinkedIn and Resume

10:46 Applying for Jobs and Networking

12:38 Preparing for Interviews

14:25 Conclusion and Final Tips

Join the Bootcamp: Data Career Jumpstart

Browse Data Jobs: Find a Data Job

Must-Learn Skills for Aspiring Analysts: Watch on YouTube

Find Free Datasets for Practice: Watch on YouTube

Stratascratch for SQL Practice: Visit Stratascratch

Prepare for Interviews: Interview Simulator


🔗 CONNECT WITH AVERY

🎥 YouTube Channel

🤝 LinkedIn

📸 Instagram

🎵 TikTok

💻 Website

Mentioned in this episode:

💌 Join 10k+ aspiring data analysts & get my tips in your inbox weekly

If you enjoy this podcast, you're going to LOVE my newsletter. Every week, I send you 1 email jam-packed with tips, tricks, and resources. Don't miss it!

💌 Subscribe To My Newsletter

Transcripts

Avery:

Here's how I would become a data analyst if I had to

2

:

start all over again in 2025.

3

:

Now, I'm lazy and I'm impatient,

so this method that I'm going to

4

:

be choosing, the SPN method, is the

fastest and it's the lowest amount

5

:

of work to actually land a data job.

6

:

But it still is a lot of work.

7

:

Step one is I'd understand the different

data roles available in the data world.

8

:

There are so many different data

roles, and it's not just data analysts.

9

:

There are so many other roles, That

are just like data analysts, but

10

:

have slightly different names and

slightly different responsibilities.

11

:

For example, business intelligence

analyst, business intelligence

12

:

engineer, technical data analyst,

business analyst, healthcare

13

:

analyst, risk analyst, price analyst.

14

:

There are so many, literally

so many different options that

15

:

you could possibly choose from.

16

:

And they're all pretty similar for

the most part, but some things are

17

:

going to be slightly different.

18

:

So for example, a healthcare analyst,

you're going to be a data analyst.

19

:

But specializing and

looking at healthcare data.

20

:

Financial analysts, same thing.

21

:

You'd be looking at financial data.

22

:

A BI analyst, like a business

intelligence analyst, and a data

23

:

analyst, really a lot of the time are

going to be doing the exact same thing.

24

:

So it's important to be looking for

all these roles, understand what these

25

:

roles do and what their slight nuances

are, because there's a chance that

26

:

your previous experience is actually

valuable and would help you get a leg

27

:

up in applying for these different jobs.

28

:

So for example, If you have a business

degree and you're trying to transfer

29

:

into business analytics, becoming a

business analyst makes a lot of sense or

30

:

a financial analyst makes a lot of sense.

31

:

If you've worked previously as

a nurse or like a CNA, maybe

32

:

you become a healthcare analyst.

33

:

Whatever you've done previously,

there's probably a good chance

34

:

that that experience is valuable in

the data world to a specific role.

35

:

So even like I have a lot of

truck drivers in my business.

36

:

Bootcamp.

37

:

Those truck drivers can be logistics

analysts, they can be operations

38

:

analysts, they can be supply chain

analysts, because their previous

39

:

experience is actually valuable.

40

:

The second thing that I would do

is figure out what is actually

41

:

required, because here's the truth.

42

:

There is actually thousands

of data skills and tools.

43

:

and programming languages out there,

but if you try to master all of them,

44

:

you're going to be like 150 before you

feel prepared to start applying to jobs.

45

:

You're going to be dead.

46

:

It is impossible to learn.

47

:

It's impossible to master

all the different data tools

48

:

and skills and languages.

49

:

So by default, have to choose a few.

50

:

Now you have a decision to make

is which ones do you choose?

51

:

And I, like I said, I am lazy and I want

to do the least amount of work possible.

52

:

So I believe in the low hanging best.

53

:

Tasting fruit analogy.

54

:

If you can imagine that there's

a tree that has some sort of like

55

:

a peach or an apple on it, right?

56

:

The easiest fruit to grab is

always going to be the closest,

57

:

so it's the lowest hanging fruit.

58

:

But not only do you want the

lowest hanging fruit, you want

59

:

the tastiest fruit, right?

60

:

So this is stuff that is not only easy

to learn, but is extremely useful.

61

:

Those are the things you want to focus on.

62

:

Out of the thousands of data skills, those

are the ones you'll want to focus on.

63

:

You can do the research on your own,

if you'd like, by looking at job

64

:

descriptions and writing down what

is actually required, but that's a

65

:

lot of work and you can take it from

someone like me, who's been in this

66

:

space for about a decade now, looked at

literally thousands of job descriptions.

67

:

I even have my own data job board.

68

:

Findadatajob.

69

:

com.

70

:

And I look at it all the time

to see what is being required.

71

:

So I've done this research for you

already, and I will have a link to

72

:

my conclusions in the show notes

down below, but basically what you

73

:

need to know in terms of low hanging

fruit, it's Excel, Tableau, and SQL.

74

:

That is it.

75

:

Those are the top three skills that you

should be learning as a data analyst

76

:

when you're just trying to get started.

77

:

And if that is too hard to remember, you

can remember every turtle swims, right?

78

:

That's easy.

79

:

Excel.

80

:

Tableau and SQL.

81

:

That is where I'd start and I

wouldn't really veer off of that

82

:

until I've landed my first data job.

83

:

Now you might have noticed that I

didn't say Python and that might

84

:

come as a surprise to many of you

because you hear so much about

85

:

Python and how cool it is and how

popular it is and it is really cool.

86

:

It can do so many different things.

87

:

It's so powerful and it's actually my

favorite data tool but it's actually only

88

:

required on 30 percent of data analyst

roles and it's really hard to learn.

89

:

It takes a long time to learn

Python because Python is hard,

90

:

but also all programming is hard.

91

:

And if you don't have a programming

background, it's going to take a

92

:

long time to just kind of even get

your foot in the door in the Python

93

:

world and understand what's going on.

94

:

What's a variable?

95

:

What's a loop?

96

:

What's a function?

97

:

Those types of things just, they take

time and so if you only need it for

98

:

30 percent of the jobs, that means 70

percent of the jobs don't require it.

99

:

And once again, I am all about doing

the least amount of work possible

100

:

and doing it as quickly as possible.

101

:

So I say save Python for after your

first day at a job because it's really

102

:

just not needed to land that first one.

103

:

Once again, I have a free video that

kind of explains what skills you

104

:

should learn and in what order and why.

105

:

I'll have that in the

show notes down below.

106

:

The third thing that I would do if I was

trying to become a data analyst is try

107

:

to figure out how I'm going to convince

a hiring manager or recruiter to hire me,

108

:

even though I have no prior experience.

109

:

There's this thing called the cycle of

doom, which basically says I can't land a

110

:

data job because I don't have experience

because I can't land a data job.

111

:

And it's this never ending cycle

of, well, you're never going to get

112

:

a job unless you have experience.

113

:

You can never get experience

unless you get a job.

114

:

It's kind of like the

chicken or the egg, you know?

115

:

So you have to figure out, how am

I going to beat the cycle of doom?

116

:

And how am I going to convince

someone that, yeah, I am a data

117

:

analyst and you should hire me.

118

:

How would I do it, personally?

119

:

I'd build projects.

120

:

Projects are a great way that

you can demonstrate your skills.

121

:

It's basically the tangible evidence

for people to know that you can do

122

:

what your resume says you can do.

123

:

If you're unfamiliar with projects,

It's like almost doing pretend work

124

:

where you're pretending that you're

working for a certain company.

125

:

You take a data set and you analyze

it and publish your results.

126

:

We'll talk about where to publish them

here in a second, but basically it's

127

:

allowing you to learn with realistic data

with realistic problems, but also you're

128

:

creating some sort of evidence, like

literally physical evidence that you can

129

:

show to hiring managers, recruiters, and

be like, Hey, look, I can do these things.

130

:

I can be a data analyst.

131

:

I can use Excel.

132

:

I can use SQL.

133

:

I can create a data

visualization in Tableau.

134

:

Once I understand those three

things, the fourth thing that I would

135

:

personally do is start learning.

136

:

And I want to emphasize

this is not the first thing.

137

:

This is not the second thing.

138

:

This is not the third thing.

139

:

It's the fourth thing that I

would do is start learning.

140

:

And I would start learning Excel,

Tableau, SQL, every turtle swims, right?

141

:

And I would do that by building projects,

because I think building projects

142

:

is the most realistic way to learn.

143

:

I'll think it's It's the funnest

way to learn because just doing like

144

:

pointless exercises on like these

like interactive online learning

145

:

things, this is not realistic.

146

:

Like in real life, you're going

to be having real data sets.

147

:

You're not going to be in some

like controlled environment.

148

:

You're actually going to have to be

analyzing real data that's messy,

149

:

that has issues that has flaws

and you have to figure it out.

150

:

And so building projects is the

best way to learn because you're

151

:

also creating this tangible evidence

that you're going to be able to show

152

:

to hiring managers and recruiters.

153

:

You might be thinking, well,

where do I get started?

154

:

Well, you need to figure out

where you can find datasets.

155

:

You have to have a good dataset.

156

:

I just did an episode on this

recently, and I'll have the link

157

:

to the show notes down below.

158

:

But the simple answer, the

one word answer is Kaggle.

159

:

Kaggle is the best

place to find a dataset.

160

:

It's not the only place, and there's

other great resources, but if

161

:

you're only looking for one, Kaggle

is usually the place I would go.

162

:

And I'd personally build projects based

off of what you want to do ultimately.

163

:

So go back to step one and think about it.

164

:

Like if you have a business degree, let's

say you want to become a business analyst,

165

:

I would try to build projects that are

relevant to, to business analytics.

166

:

Maybe data on sales or marketing

or operations, anything

167

:

that's business related.

168

:

Those are the projects

I would try to seek out.

169

:

Or if you're not sure, like if you want

to be a business analyst or a healthcare

170

:

analyst, or maybe you don't even care.

171

:

You'll just take whatever you've got.

172

:

I would suggest doing projects

on lots of different industries.

173

:

Maybe dip into healthcare analytics.

174

:

Maybe do some people and HR analytics.

175

:

Maybe do a project on

manufacturing and engineering data.

176

:

That way you're getting exposed

to multiple different industries,

177

:

so you can kind of figure out

maybe what you're interested in.

178

:

You're creating a robust portfolio

that will be attractive to every

179

:

industry and multiple companies, right?

180

:

Because if you just focus on creating,

you know, business projects, but

181

:

let's say you want to become a

healthcare analyst, it's like, oh,

182

:

those projects don't really match up.

183

:

So.

184

:

That way you have a project for whatever

role you might be interested in.

185

:

So that's particularly

what I suggest doing.

186

:

And it's what we do inside of

my bootcamp, the Data Analytics

187

:

Accelerator is we learn Excel, SQL,

and Tableau by building projects.

188

:

And we built multiple projects

in different industries.

189

:

So that way we're very robust as can.

190

:

The fifth thing I would do if I was

trying to become a data analyst.

191

:

is create a home for my projects.

192

:

And this is actually

what's called a portfolio.

193

:

You know, projects are something that

we do but if you just do them and you

194

:

don't publish them and you don't share

them, they don't actually do much good.

195

:

You need to create a portfolio

to home these projects.

196

:

And the portfolio platform you'll

hear the most about is GitHub.

197

:

And I have a controversial

take that I'm not a fan of it.

198

:

I don't think GitHub is

meant to be a portfolio.

199

:

Now that's me being a little bit picky,

but I just don't think it's the best

200

:

option if you're choosing from scratch.

201

:

What you need to do is make sure

that your readmes are really good,

202

:

because if you have a good readme

on your GitHub, then it can work.

203

:

But if you're starting from scratch,

I recommend doing something like

204

:

LinkedIn, using the featured section.

205

:

Or choose GitHub Pages, which is from

GitHub, but kind of a separate product,

206

:

and it's their portfolio solution.

207

:

It's actually what GitHub

recommends as a portfolio.

208

:

Or I really like Card, C A R R D.

209

:

It's just a simple website builder,

be really great options inside the

210

:

accelerator, my bootcamp, so any of

those three would work just fine.

211

:

The sixth thing I would do is make

sure that my LinkedIn and resume

212

:

are up to date and optimized.

213

:

And I would do this early, even

before I've actually mastered Excel

214

:

or I've, you know, tackled Tableau.

215

:

The earlier you do this,

the better, because.

216

:

Your LinkedIn is your professional

business card to the world.

217

:

One of the really cool things is LinkedIn

has a feature called Open to Work.

218

:

There's two different settings on it.

219

:

We can talk about it later, but

basically you can have Open to Work

220

:

for the entire world or you can just

have Open to Work for recruiters.

221

:

And either way, if you set up

your LinkedIn correctly, your

222

:

LinkedIn can start to work for you.

223

:

And instead of you going out and

applying for jobs, recruiters

224

:

and hiring managers are actually

applying to you for specific jobs.

225

:

They'll reach out to you and be like, Hey,

I think you're a good fit for this job.

226

:

So having an optimized

LinkedIn is, is really key.

227

:

And then of course, having an

optimized resume is a must because

228

:

once you start applying for jobs.

229

:

If your resume isn't optimized, you're

probably not going to get many interviews.

230

:

And the reason is there's so many

candidates trying to get into data

231

:

analytics roles, especially the

entry level ones, that recruiters

232

:

and hiring managers have to use

what's called the ATS, which is

233

:

the Applicant Tracking System.

234

:

And basically it's, it's computer, it's

AI, it's It's actually not even really

235

:

that complicated, but there are certain

things you need to do on your resume to

236

:

have it be optimized and ATS friendly, so

you can get past the computer screening

237

:

and actually have a human being look at

your resume, because it's so frustrating

238

:

when you get rejection after rejection

after rejection that you don't even know

239

:

if a human's looking at your resume.

240

:

A lot of the times you're just getting

rejected by the ATS, and so you need to

241

:

make sure you have an optimized resume.

242

:

So, in terms of having an optimized

resume, it would basically look like

243

:

not having any columns on your resume,

or any tables on your resume, and

244

:

then using really key words that match

the job descriptions, so that way you

245

:

appear as a good applicant to the ATS.

246

:

The seventh step that I would take

is to start applying, and I think

247

:

this is obvious, but a lot of people

don't ever start applying for jobs.

248

:

And I get it, because it's scary.

249

:

How do you know if you're

ready to land a data job?

250

:

It's hard to know, and you probably

will never feel ready, so I suggest

251

:

just start applying anyways.

252

:

And when you start applying,

don't only apply on LinkedIn jobs.

253

:

LinkedIn jobs is where everyone applies,

and there's going to be hundreds of

254

:

candidates in a matter of a few days

on those platforms, the majority of the

255

:

time, because everyone's doing that.

256

:

So you might want to try something

new, like going to company websites or

257

:

checking out my job board, findadatajob.

258

:

com or some other combination

of other job websites.

259

:

The point here is you need to

be looking at multiple places

260

:

and actually start applying.

261

:

I know it's scary, but just do it scared.

262

:

The next step I would do in this process

is I would really try to be networking.

263

:

And I, I would try to be networking

the entire time, like even in step one.

264

:

But this is where I fit on

today's roadmap is step eight.

265

:

So it's way easier to get

hired when you know someone.

266

:

In fact, my brother was just recently

looking for a job and having a

267

:

hard time and he ended up Getting

an interview and landing that job

268

:

because his wife's friend works there.

269

:

And like, I can't tell you how

often that actually happens.

270

:

So networking doesn't have to be hard.

271

:

You can do it on LinkedIn by

posting and commenting on LinkedIn.

272

:

I think that's really important to do, but

I understand that's hard and a scary step.

273

:

One thing that's really a lot easier is

just to talk to your friends and family.

274

:

Just say, Hey, I'm trying

to become a data analyst.

275

:

Do you know anyone who's a data analyst?

276

:

Does your company hire data

analysts and have a conversation?

277

:

You're not even really

asking them anything.

278

:

You're just opening a conversation.

279

:

I know this is hard and I know it's

uncomfortable and I know it's not fun.

280

:

Like it's much more fun to learn data

skills than it is to network, but

281

:

honestly, networking gets you the same,

if not better results than upscaling

282

:

and actually learning new data things.

283

:

So you can't be ignoring this.

284

:

Couldn't be ignoring this.

285

:

I have to be networking,

no matter how hard it is.

286

:

Now, if all is going well, and I'm doing

all the previous eight things that I've

287

:

talked about, I think at this point

I'd probably start to land interviews.

288

:

There's two parts to an interview,

the technical and the behavioral.

289

:

The technical interview is when

they're going to be asking you

290

:

questions about data skills.

291

:

It might be like, Excel questions or data

visualization questions or oftentimes

292

:

sequel questions and I'll ask you to

write certain sequel queries This can

293

:

be really scary and intimidating and

honestly, they can be really hard The

294

:

cool part is they don't always occur

or or if they occur they occur very

295

:

easily Sometimes they're very hard.

296

:

Sometimes they're very easy.

297

:

It really just depends and to prepare

for the technical resources There's

298

:

a lot of things that I could do.

299

:

There's a lot of resources out

there that would help me prepare.

300

:

Um, there's something called Scrata

Scratch that I'll have a link in the show

301

:

notes down below that you guys can check.

302

:

There's Data Lemur.

303

:

There's a bunch of tools that

will help you prepare for

304

:

these technical interviews.

305

:

Behavioral interview is going to be

more like them trying to feel for

306

:

who you are and what you've done

previously and like how you would

307

:

act as a human being, as an employee.

308

:

And that is a little bit harder to

prepare for because it's more of like,

309

:

instead of answering technical questions,

it's answering like personal questions.

310

:

There's not a whole lot

of resources out there.

311

:

One of the things you would want

to do is use the STAR method.

312

:

You want to answer every question by

saying, this is the situation I was

313

:

in, this is the task I was given, this

was the action I took, and this is the

314

:

results that came from that action.

315

:

And if you answer using that method,

most of the time you'll be good.

316

:

It can be scary, and there's not a whole

lot of resources out there for this.

317

:

So do you want to check

out one that I made?

318

:

It's called interview simulator.

319

:

io, and it basically helps you

practice these questions where

320

:

I'll ask you the question via video

and you will respond via video.

321

:

And then we'll actually grade your

answer and tell you what you did

322

:

well and where you could improve.

323

:

It's a pretty cool software.

324

:

I'll link for that in the

show notes down below as well.

325

:

Wow, lots of links in the show

notes, so be sure to check those out.

326

:

So those are the nine steps that I

would take if I had to start from

327

:

scratch and land a day job in 2025.

328

:

And remember, I'm lazy, I'm trying

to do this the easiest way possible.

329

:

This is This is what

I call the SPN method.

330

:

You need to learn the right skills, not

all the skills, but the right skills.

331

:

You need to build projects

and put them on a portfolio.

332

:

That's the P part.

333

:

And then you need to be

networking, updating your

334

:

LinkedIn and updating your resume.

335

:

That's the N part.

336

:

And it's the easiest

way to land a data job.

337

:

Now you can do all this stuff that

I told you on your own and you'd

338

:

be 100 percent okay, but it's a lot

more fun to do it in community and

339

:

it's a lot easier to do with a coach.

340

:

Once again, I'm all about doing it

fast, And it's much easier to do

341

:

that with a given curriculum where

you don't have to be questioning.

342

:

Am I doing this right?

343

:

How do I actually do this?

344

:

So on and so forth.

345

:

And so that's why I created the data

analytics accelerator program, which

346

:

is basically a 10 week bootcamp to

help you land your first day at a job.

347

:

We'll go over all of these nine steps.

348

:

Hand by hand, step by step together, and

make sure you're ready to land a data job.

349

:

If you want to check that out,

you can go to datacareerjumpstart.

350

:

com slash D A A D A A standing

for Data Analytics Accelerator.

351

:

And of course, I'll have a link to

that in the show notes down below.

352

:

Let me know what I missed

and what questions you have.

353

:

I'll try to respond to everyone in

the comments down below if you're

354

:

watching on YouTube or on Spotify.

355

:

And I wish you the best of luck in 2025.

Follow

Links

Chapters

Video

More from YouTube