216: 26 Data Job Cheat Codes That Actually Work
Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
I analyzed thousands of data job applications. I'll show you the 26 things that work in today's market and the 6 I'd start with.
π Join 30k+ aspiring data analysts & get my tips in your inbox weekly π https://datacareerjumpstart.com/newsletter
π Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training π https://datacareerjumpstart.com/training
π©βπ» Want to land a data job in less than 90 days? π https://datacareerjumpstart.com/daa
π Ace The Interview with Confidence π https://datacareerjumpstart.com/interviewsimulator
β TIMESTAMPS
00:00 β Apply in the first hour
02:03 β Quantify every bullet
06:36 β Referrals beat everything
09:33 β Go hybrid not remote
11:24 β Never give the first salary number
13:27 β Track everything
π CONNECT WITH AVERY
π₯ YouTube Channel
π€ LinkedIn
πΈ Instagram
π΅ TikTok
π» Website
Mentioned in this episode:
π° Join 18k Other Analysts in My Newsletter
Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe
π Subscribe To My Newsletter
Build Your Data Portfolio
We will build your data portfolio site for you for $1. All you need to do is go to MyDataFolio.com/build and enter your LinkedIn URL. Wait 30 seconds. And BOOM! You have a portfolio! Try it.
Transcript
The data job market in
:
2
:You're up against a flood of applicants
on every single job posting, and a
3
:huge number of the listings out there
are straight up ghost posts that were
4
:never going to hire anyone anyways.
5
:But people are breaking
into data every single day.
6
:Career changers, people without CS
degrees coming from normal jobs like
7
:retail or bartending, you name it,
and they're just doing a handful of
8
:things differently than everyone else.
9
:So here are 26 cheat codes to land
your first data job this year.
10
:Cheat code number one: apply within
the first hour, not the first week.
11
:Recruiters start building their shortlist
the moment applications start to roll
12
:in, so the exact same resume that gets
a call back in the first hour will
13
:probably get buried after week one.
14
:Not because it's worse, but because
they have already found five people
15
:who they're going to interview.
16
:Applying in that first window
can boost your interview odds
17
:by as much as four times.
18
:So here's the actual trick.
19
:On LinkedIn Jobs, search your
new role, data analyst, and
20
:filter by the past 24 hours.
21
:Now look up at the URL in your
address bar and you'll see a
22
:chunk that says f_TPR=R86400.
23
:And that's just a number.
24
:It's just seconds, because
86,400 seconds is 24 hours.
25
:Now, change that number to R3600,
and that is one hour, and hit Enter.
26
:Now you're only seeing jobs
posted in the last 60 minutes.
27
:If you add an ampersand sort by equals to
D-D on the end to sort by the most recent,
28
:and you can literally bookmark that
URL and check it a few times every day.
29
:You're gonna be guaranteed
to be applicant number three
30
:instead of applicant number 300.
31
:Cheat code number two: tailor
it to the posting's keywords.
32
:Most first-round filtering is a literal
keyword match that ATSs do for the
33
:exact terms in the job description.
34
:So if the posting says sequel, Looker,
stakeholder communication, those are exact
35
:phrases that need to be on your resume.
36
:Don't use synonyms.
37
:Use the literally exact same words,
because you wanna mirror their language
38
:straight back to them, and that
increases your odds by quite a bit.
39
:Cheat code number three is
to quantify every bullet.
40
:Responsible for reporting tells a
hiring manager absolutely nothing.
41
:Cut weekly reporting by 40%,
that tells them everything.
42
:Numbers are credibility anchors.
43
:They make a stranger actually believe you.
44
:Every bullet on your resume
should have a number on it.
45
:If it doesn't, you're describing a
task instead of proving an impact.
46
:Cheat code number four: name
your resume file properly.
47
:This one literally takes 10
seconds, and yet no one does it.
48
:Just name the file your first name,
your last name, data analyst.pdf.
49
:And a recruiter who downloads
literally hundreds of these resumes
50
:into a folder, a resume that says
resume final V3 looks really careless
51
:and gets lost every single time.
52
:Your name, the title, every
time you don't get lost.
53
:Cheat code number five:
don't gatekeep yourself out.
54
:If a posting lists 10 different
requirements, that's a
55
:wish list, not a checklist.
56
:They will almost never find someone
who hits all 10 of those things.
57
:So if you hit about 60% of
the requirements, apply.
58
:The person who gets hired is
rarely the most qualified.
59
:It's the qualified enough person who
is actually brave enough to apply.
60
:So stop disqualifying yourself
before they get a chance to.
61
:Cheat code number six: apply to
adjacent titles, not just data analyst.
62
:If you only search words like data
analyst, you're gonna be skipping most of
63
:the jobs you're actually qualified for.
64
:The exact role gets posted as business
analyst, reporting analyst, operations
65
:analyst, BI analyst, insight analyst.
66
:Same work, different label,
depending on who writes the listing.
67
:On findadatajob.com,
68
:when I broaden the search beyond
just data analyst, the number of
69
:relevant roles roughly quadruples.
70
:That's about four times the openings.
71
:So you're not under-qualified,
you're just searching for one term.
72
:Cast a wider net.
73
:Cheat code number seven: skip the cover
letter, unless it's the dream role.
74
:For most postings, nobody reads the
cover letter, and the hour you spend
75
:on it is an hour you could have spent
on two more tailored applications.
76
:So save the cover letter for
situations like a referral or a
77
:role you genuinely, genuinely love.
78
:Everywhere else, put that energy
into volume of applications
79
:and tailoring your resume.
80
:Cheat code number eight: when you
do write a cover letter, lead with
81
:their problem, not your story.
82
:The mistake everyone makes is opening a
cover letter with, "I am a passionate,
83
:detail-oriented professional seekingβ¦"
84
:And that's about you, and
they don't care about you yet.
85
:Flip it.
86
:Open with their problem.
87
:"Hey, I saw your team is scaling
reporting across three different regions.
88
:Here's a dashboard I built
that solves exactly that."
89
:Now you're not an applicant, you're
someone who already understands their
90
:pain, and that's the entire difference
between getting read and getting skipped.
91
:Cheat code number nine: learn SQL first,
and honestly, skip Python for now.
92
:Everyone wants to start with Python.
93
:For getting your first job,
that's absolutely backwards.
94
:Look at the actual demand.
95
:On our skills breakdown
at findadatajob.com,
96
:SQL shows up 38% of data analyst postings.
97
:Python is only 20%.
98
:So if you spend six months grinding
pandas before you can actually
99
:write a clean join in SQL, you're
studying hard for a test that the
100
:job market is mostly not giving you.
101
:Learn SQL until you're genuinely
comfortable, get hired, then pick up
102
:Python, ideally on the company's dime.
103
:Excel, SQL, and a business intelligence
tool, like Tableau or Power BI,
104
:are the highest ROI in this entire
field, and it's not even close.
105
:Cheat code number 10:
skip the cert rabbit hole.
106
:You do not need five
certifications to get an interview.
107
:Most of them are a way to feel productive
without actually being productive.
108
:Rocking horse syndrome.
109
:One real project that solves a real
problem will outperform a wall of
110
:certification badges every single time.
111
:Certificates prove that
you can finish a course.
112
:A project proves that you can do the job.
113
:Just build a project.
114
:Cheat code 11: make your LinkedIn
headline the exact title you want.
115
:Recruiters use LinkedIn, and they
search LinkedIn by literal job title.
116
:If your headline says, "Aspiring
data professional, lifelong learner,"
117
:well, you are invisible to the search.
118
:Put the title you want, data
analyst, right in your headline.
119
:You're not lying about having the
job, you're telling the search
120
:engine exactly who you are.
121
:Cheat code 12: give yourself
the title data analyst.
122
:You wanna make sure that's
in your experience section on
123
:your resume and your LinkedIn.
124
:It's kind of a chicken and the egg
problem that everyone gets into because
125
:you need experience to get the job,
but you need the job to get experience.
126
:So my solution is to manufacture
the experience legitimately.
127
:You don't need some company to
hand you the title data analyst.
128
:Instead, do a real project and list it.
129
:Start a tiny company on your own and
be your first customer and do analysis.
130
:Volunteer to build a dashboard for
a local business, a nonprofit, a
131
:friend's workshop, or you can join
my boot camp, the Data Analytics
132
:Accelerator, and you come in and work
as a data analyst intern and do real
133
:work for our company, and there you go.
134
:You have experience.
135
:Any of these earns you a legitimate
data analyst entry in the experience
136
:section on your LinkedIn and your resume.
137
:Because a recruiter scanning your
profile isn't reading a story, they're
138
:checking whether the words data analyst
appear in your experience at all.
139
:So put it there.
140
:Give yourself a job
until someone else does.
141
:Cheat code 13: referrals beat
cold applications every single
142
:time Cold application drops
you into a pile of hundreds.
143
:A referral walks you past the entire pile.
144
:Referred candidates get interviewed at
a far higher rate than cold applicants,
145
:and it's not even the same game.
146
:One warm introduction is worth
more than 50 perfect applications
147
:submitted to the resume black hole.
148
:So before you fire off another cold
application, ask yourself, "Is there a
149
:human that I could go through instead?"
150
:Which leads us directly to our
next cheat code, cheat code 14.
151
:Ask your neighbors if they
know any data analysts.
152
:And this sounds almost maybe too
simple, but that's exactly why it works.
153
:You are sitting on a network you've
never actually talked to before.
154
:The person two doors down maybe works
in data or is married to someone who
155
:does, or their kid just got hired as
an analyst, and you literally have no
156
:idea because you've never said this
sentence out loud, "Hey, do you happen
157
:to know anyone who works in data?"
158
:This simple question can turn into
a warm intro, and then a warm intro
159
:skips the resume pile entirely.
160
:All of a sudden you have an interview,
and all of a sudden you have an offer.
161
:So ask everyone.
162
:Someone always knows someone.
163
:Cheat code number 15.
164
:Search the phrase "hiring
data analyst" on LinkedIn.
165
:Don't just search the jobs tab.
166
:Literally go to the search bar and type
in "hiring data analyst," and you'll
167
:surface a bunch of posts from actual
managers and teammates announcing that
168
:their company is hiring, and a lot
of these never get into the official
169
:posting treatment that LinkedIn does.
170
:You're gonna be finding the role
before it becomes into a pile.
171
:Real person, real post, real opening.
172
:And honestly, this is a lot of work,
so if you'd rather skip the manual
173
:hunting of this, we've actually already
pulled over 3,000 of these types of
174
:job postings on findadatajob.com,
175
:and we add 30 new ones every single week.
176
:So basically, it's a lot
easier for you to do that.
177
:So if you want fresh
jobs, check it out there.
178
:Cheat code 16.
179
:Hunt for the purple hashtag
hiring ring in LinkedIn.
180
:It is a completely different game.
181
:LinkedIn lets people put a purple
hiring ring around their profile
182
:picture and say that they're
actually hiring data analysts.
183
:So you can actually go to the LinkedIn
search bar, go to hiring data analyst,
184
:and get an entire list of hiring
managers, recruiters, all sorts of
185
:different people who are actually
hiring data analysts right now.
186
:You can message them directly,
and at that point, you've skipped
187
:the entire ATS altogether and gone
straight to the decision maker.
188
:Cheat code 17.
189
:Turn on open to work on LinkedIn,
but for recruiter visibility only.
190
:The green open to work banner on
your photo can read as a little
191
:desperate to some hiring managers.
192
:So instead, you can use the
quieter setting, which is
193
:visible to recruiters only.
194
:You still show up in every single
recruiter search for open candidates,
195
:but you skip the public banner.
196
:All of the upside and none of the optics.
197
:Cheat code 18: build in public.
198
:Most people job hunt in complete silence
and wonder why no one ever finds them.
199
:So instead, post what you're learning.
200
:Share the SQL query that finally clicked,
the dashboard you built this week, the
201
:messy data set that you just wrangled.
202
:You don't need an audience, you
just need to be findable and
203
:look active in the data world.
204
:Visibility compounds.
205
:The recruiter who didn't search for
you still scrolls past your post.
206
:I've watched many of my students
get DM'd about roles purely because
207
:they were the person visibly
doing the work on the internet.
208
:Be that person.
209
:Cheat code 19: hybrid is way
less competitive than remote.
210
:Everyone fights over fully remote roles,
and that's exactly why you shouldn't.
211
:A remote posting pulls applicants from the
entire country, sometimes even the entire
212
:world, so it gets absolutely flooded
with all sorts of different candidates.
213
:A hybrid role in your city is competing
against a tiny fraction of that.
214
:And here's the part that most people miss:
hybrid keeps almost all of the benefits.
215
:You're still at home most of the week,
you just skip most of the commute, but you
216
:quietly remove most of your competition.
217
:For your first role especially,
hybrid is a literal cheat code.
218
:Cheat code number 20: practice
interviews because they're hard to get.
219
:Here's the brutal reality: you might
send dozens, heck, even hundreds of
220
:applications to land one single interview.
221
:So when you finally get it,
it's way too valuable to just
222
:wing it and see how it goes.
223
:Most people spend weeks getting
an interview and then zero hours
224
:actually prepping for it, and that's
like training six months for a
225
:race and skipping the actual race.
226
:Run mock interviews out loud.
227
:A tool like interviewsimulator.io
228
:lets you rehearse real interview
questions until your answers
229
:come out perfectly smooth.
230
:Record yourself once, twice, three
times, and you'll hear the rambling
231
:that you wouldn't hear live, and
you'll be able to correct it before
232
:you actually get to the interview.
233
:The interview is a
rare, precious resource.
234
:Treat it like one.
235
:Cheat code 21: when you land an interview,
figure out why and double down on it.
236
:An interview just isn't a chance
at a job, it's literal data.
237
:Something on the application worked.
238
:Which version of your resume was it?
239
:Which title did you under- apply under?
240
:Was it a referral, a hybrid
role, a specific industry?
241
:Most people get an interview, and
if it doesn't convert, they get
242
:depressed, and they throw the whole
approach over and start from scratch.
243
:Don't.
244
:Figure out what triggered the interest and
pour more energy into that exact channel.
245
:You're a data analyst, after all.
246
:Your own data from your job hunt
is a data set, and an interview
247
:is your strongest signal in it.
248
:Find the pattern and run it straight back.
249
:Double down.
250
:Cheat code number 22: never give
the first number in a negotiation.
251
:When a recruiter or hiring manager asks,
"What are your salary expectations?"
252
:That's not exactly a friendly question.
253
:It's the start of the negotiation.
254
:Whoever says a number first loses,
and you set an anchor, and it's
255
:really hard to ever get back.
256
:So deflect it and say, instead,
"I'd love to hear the range
257
:you've budgeted for the role."
258
:Make them go first.
259
:You can't lose an anchor you never threw.
260
:Cheat code number 23: if you're forced to
actually answer the sa- salary question,
261
:don't give an exact number, give a range.
262
:Sometimes they're gonna push, and
you're gonna need to say something.
263
:But don't give a single
number, give the full range.
264
:A range keeps you in the conversation
no matter what their budget actually
265
:sits, and you make sure that the
bottom of your range is still a
266
:number you'd be happy to accept.
267
:Single number and you've
kind of lost the battle.
268
:You give a range, and you're keeping
the door open and alive in the game.
269
:Cheat code number 24, job hop.
270
:For some reason, you're worth
more to someone else faster,
271
:and the fastest way to grow your
salary is unfortunately to leave.
272
:Internal raises tend to be small
and infrequent, maybe a few
273
:percent every year if you're lucky.
274
:Moving to a new company is where you can
actually get a true salary hike because
275
:a new employer prices you at today's
market rate and at their competitor's
276
:market rate, and they just value
you more than your current company.
277
:Loyalty is great, but
don't let it cost you.
278
:Get your first job, build real
skills, and then don't be afraid
279
:to move when the market says you're
worth more, and it will usually.
280
:Cheat code 25, detach your worth
from your response rate, and this is
281
:the one that keeps you in the game
long enough for the rest to work.
282
:A two to three percent callback
rate from an application is
283
:pretty normal in today's market.
284
:It's not a verdict of who you are
as a person or as a data analyst.
285
:It's just the math of a crowded field.
286
:If you tie your self-worth to every single
rejection you get, you'll burn out in
287
:like two weeks and quit right before you
are actually going to land interviews.
288
:So instead, measure your effort, not
the out- "I sent 20 quality applications
289
:this week," is in your control.
290
:An interview or an offer is not.
291
:Protect your head because this is
a months long game, and the people
292
:who win are the ones who are left
still standing and didn't give up.
293
:Cheat code number 26, track
everything about your job hunt.
294
:You are a data analyst,
so job hunt like one.
295
:This is the most important one, and it's
the one that almost no one actually does.
296
:You're trying to become a data analyst, so
become one right now with your job search.
297
:What can't be measured can't be improved.
298
:So open up a spreadsheet, or honestly,
if you just want the easier way to do
299
:it, the cheat code is we built a job
tracker right into findadatajob.com,
300
:so you don't even have
to start from scratch.
301
:Track every application, the company,
the title you applied for, was it remote,
302
:was it hybrid, was it cold, did you have
a referral, the date, and the outcome.
303
:Within a few weeks, you'll stop
guessing and start seeing patterns.
304
:Oh, every interview I've gotten came
from a referral or a hybrid role,
305
:and that's not a feeling anymore.
306
:That's actual data.
307
:And now you cut out what isn't working,
and you double down on everything that is.
308
:Every other cheat code I've given you in
this episode will start to actually work
309
:the moment you start tracking because
you'll know which ones are actually
310
:moving the needle forward for you.
311
:You're not just hunting for a data
job, you're running your first
312
:real data project in real time.
313
:Start treating your job search like
a job, and you'll be amazed how
314
:fast that job shows up more quickly.
315
:If you got something out of these
cheat codes, I send a fresh one in
316
:my newsletter every single Wednesday.
317
:Head to datacareerjumpstart.com/newsletter
318
:and hit subscribe.
319
:I'll see you in the next episode.
