Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away!
I built you a free tool that matches you to open data jobs! I built it using a low-code analytics tool called KNIME. Learn how I built it & how you can build your own!
👔 Try the Resume to Job Match App: https://apps.hub.knime.com/d/AI_Job_Search~data-app:c0cff571-721d-4cd2-aca7-5f19505d7537/run?authToken=cVZoMmVVZmF3RkM4eG9HdXVDdWltWTlZbFJDdzRCTjc0TXBLaFIzY3JYSTpmT3FYZ3VWZ19OTHgwZExxMGZ1Ty1XMUxySFF0QmdYRXBOWllaSVVQRnZmbnRHdGlnWlJ1cS1lM2hlQk0tM3k0TE0taHk3b0ZyQTh2S0t2YWV4QkREdw==
💻 Download KNIME: https://www.knime.com/start?utm_source=youtube&utm_medium=influencer&utm_term=avery_smith&utm_content=video&utm_campaign=kapsquad
📈 Download the KNIME Workflow: https://hub.knime.com/knime/spaces/Data%20Apps/AI_Job_Search~IkoQH5UBhidlxnEt/current-state?utm_source=youtube&utm_medium=influencer&utm_term=avery_smith&utm_content=video&utm_campaign=kapsquad
💌 Join 30k+ 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
0:00 - Avery's notes about episode (audio only)
7:33 - Use this free tool to find data jobs
09:36 - What is low-code analytics & why is it important?
13:20 - How I built this tool (& you can too)
16:47 - The future of low-code data tools
🔗 CONNECT WITH AVERY
🎵 TikTok
💻 Website
Mentioned in this episode:
🎉 The 2026 Cohort of The Data Analytics Accelerator 🎉
Ready to land your data job in 2025? We're starting the 2026 Cohort on January 5th. This bootcamp is everything you need to land your first data job. Check out our New Year's sale & bonuses: https://datacareerjumpstart.com/daa
Hey, podcast listeners, Avery Smith here.
2
:I've been wanting to tell you guys about
this for a while, but like you've probably
3
:noticed that I've started to make a lot
of my podcast episodes more video heavy,
4
:and I wish that I could put the videos
on podcast warm, but that's just not how
5
:it's really set up to work right now.
6
:Um, so one thing I was thinking
about is how can I make these
7
:video more video-centric episodes?
8
:Better for you guys and the listeners.
9
:Right.
10
:First off, this one that you're gonna
about to listen to, I don't think
11
:it's super important to have video.
12
:Um, I do talk about like a
little bit of a workflow.
13
:Um, but actually if you go to the
description and you click on the
14
:link, that will take you to the
workflow that will actually show
15
:you a picture of the workflow.
16
:So you could actually have
that open if you wanted to.
17
:Um, otherwise I like try to explain it
so you don't need the visual reference.
18
:Um, but I've been thinking about
like these more video centric
19
:episodes about how can I make it
more special and interesting to
20
:you guys as podcast listeners.
21
:And one of the ideas I had, I had was
like, kind of doing this more free
22
:flowing casual intro to the episodes.
23
:That you're listening to right
now, that kinda gives you a little
24
:bit more, uh, behind the scenes.
25
:And maybe is on a lot of time when you're
making a YouTube video, you have to keep
26
:it pretty short and brief because people's
attention spans are short, including mine.
27
:Uh, but when you're doing a podcast, you
can like listen a little bit longer, um,
28
:and get a little bit more of the details.
29
:So I was like, maybe I can kind of
do a little preamble to the, uh.
30
:The actual episode and give
you guys a little bit more
31
:of an audio only experience.
32
:So, um, let me know in the Spotify
comments if you like this or not, or
33
:you can send me an email too and tell
me your thoughts on the podcast, um,
34
:and maybe how we could do better with
these more video centric episodes.
35
:You can send me an email, my email's
avery@datacareerjumpstart.com
36
:and you can just put in the
headline like podcast feedback.
37
:I'd love to hear from you because it's
something I'm actually thinking about
38
:is how do we make the audio podcast.
39
:Continue to be the number one
data podcast on Spotify, which you
40
:guys, thanks to you guys we are.
41
:Which is super cool.
42
:Um, so this episode it's about a
tool I made using a no code slash low
43
:code, uh, data analytics platform.
44
:And, um, I explain how I
built it, what the tool is.
45
:It, it basically, you upload your
resume and it matches you with jobs.
46
:And I explain kind of why I think no code
and low code tools are, are important.
47
:But I just wanna tell you guys, I do think
that these tools are really important.
48
:I think they are going to be
used more in the future and they
49
:actually make data analysis easier.
50
:So if you're brand new to data analytics
these tools are, are pretty cool.
51
:Um, now they aren't used like all the time
in industry, but they're becoming more
52
:popular and I think they'll be, continue
to become more popular down the road.
53
:Um, if you're unfamiliar with them,
just think instead of like writing
54
:code, like SQL or Python or doing
a spreadsheet like Excel or like a
55
:dashboard like Power BI or Tableau.
56
:You have like a blank canvas.
57
:And on that canvas, you, you can
kind of think of it almost like
58
:a factory, like a data factory.
59
:Um, where, you know, data starts on
like the left hand side, and then
60
:your analysis is gonna be on the, the
output of the analysis is gonna be
61
:on the right hand side and in between
there's like all these like magic
62
:machines that will do certain things.
63
:So like, you'll have a data
cleaning machine, right?
64
:You put the data through the left
hand side through the data cleaning
65
:machine, and out comes clean data.
66
:And then you could have like a, a
bar chart machine where you feed
67
:in the data and out the right
hand side comes a bar chart.
68
:Um, and you could have all
these different little machines.
69
:These are called nodes in the tool
I was using, which is called nine.
70
:Um, these nodes basically perform one
little bite sized data operation for you.
71
:So it could be, you know,
cleaning all the dates.
72
:It could be cleaning you
know, the null values.
73
:It could be doing regression.
74
:It could be, you know, any sort of
data thing you could be doing can
75
:be done in this no-code platform.
76
:So, I think it's really cool.
77
:Nym this, this pon, this
episode is sponsored by Nime.
78
:They actually reached out to me and
I was super excited when they reached
79
:out to me, and I, I talk about this in
the episode, but Trevor, uh, Maxwell,
80
:who you may have listened to his
interview where he went from no college
81
:degree printer technician to landing
a totally remote data analyst job.
82
:He actually uses Nime a decent
amount at work, which is super cool.
83
:And he's, he's told me how,
how Nims he really enjoys Nime.
84
:And I was like, yeah, I think
low-code, no-code stuff is cool.
85
:We don't talk about any of that
inside of the bootcamp, inside
86
:of my accelerator program.
87
:Trevor, why don't you make a, um, and I,
I've hired Trevor now, if you didn't know.
88
:He's one of my coaches inside
of my accelerator program.
89
:Um, helps manage the students,
answers, questions, does some office
90
:hours, gives people like a little
bit of an insight of what it's
91
:like to actually be a data analyst.
92
:You know, working right now.
93
:And I had him create, uh, like a
half hour intro to Nime, uh, to our
94
:accelerator students, so that way if they
see it on job applications or if they
95
:see low-code, other no-code, low-code
platforms, they would know about it.
96
:So anyways, uh, big fan of Nime.
97
:I think it was really cool to have
them reach out and I was super happy to
98
:tell more people about the tool because
one, I think it's a cool tool and, uh,
99
:two, I think everyone should be aware
of how to do these types of low code.
100
:No-code analysis and what
the pros and the cons are.
101
:I talk a little about the pros.
102
:In the episode that we'll get
to here just in one second.
103
:I don't really talk too much of the cons.
104
:The, the trade off that a lot of people
will tell you is low-code, no-code tools
105
:make it easier to do data analysis.
106
:Like it's just easier to set up.
107
:It's actually easier to
do all the operations up.
108
:You know what you're trying to do.
109
:Um, but sometimes they come
at a sacrifice of like speed.
110
:So I know there are some data
engineers who would argue that like
111
:low code tools are inefficient and
they really slowed down things from
112
:a speed and memory perspective.
113
:I haven't really dealt with these
tools at scale, so I can't really
114
:speak to how big of a problem that is.
115
:So if you're currently employed as a
data professional or down the road when
116
:you, you know, land your first data
job and they're talking about this,
117
:that's, that's basically a trade off.
118
:You can, you can know is there, there,
there could be a trade off between how.
119
:Efficient the tools are
versus how easy it is.
120
:It's easier to set up, but it
might not be as like efficient
121
:from a data storage perspective.
122
:Now, I can't speak specifically
on Nime and like I've never worked
123
:with, with an a low-code tool
in my personal data per career.
124
:I'm pretty sure maybe I have a little bit.
125
:We have a little bit.
126
:But speed and efficiency
wasn't a big issue for us.
127
:So if you're in a place where speed
and efficiency are really, really,
128
:really, really, really important,
so like think about like automatic
129
:trading on the stock market, right?
130
:Even one second late, you can be
losing on, you know, a lot of money.
131
:So those situations, you know, you might
want to lose some of the infrastructure,
132
:the ease of like a low-code, no-code tool.
133
:Um, but if you're doing what I was kind
of doing like at ExxonMobil where the
134
:stuff you're predicting is months out.
135
:If it takes five extra minutes
to run, it's not a big deal.
136
:So anyways, that's a little bit of
some background on this episode.
137
:Tell me in the Spotify comments if
you kinda liked this preamble, uh, to
138
:the episode that's about to happen.
139
:And if you want more of it, um, once
again, when I talk about the workflow
140
:in the upcoming episode, go to the
show notes down below and uh, you can
141
:see a picture in the download nine.
142
:Uh, workflow Link and that
will show you the picture if
143
:you want to have the visual.
144
:Otherwise, I think I did an okay job
of giving you the visual without,
145
:without actually showing you the visual.
146
:Okay.
147
:Enough of my preamble.
148
:Let me know if you enjoyed this
and let's get into the episode.
149
:Okay.
150
:Speaker: Job hunting sucks right now.
151
:So in an effort to help you out,
I built a free tool that allows
152
:you to find specifically tailored
data jobs that are great fits for
153
:you based only on your resume.
154
:Seriously, just upload your resume
and boom, you got tailored job
155
:listings ready for you to apply.
156
:And I built this entire tool
using a data platform called nym.
157
:Which allows you to do data analytics
and data engineering with a visual
158
:interface, which makes the whole process
kind of feel like building data Legos.
159
:And they're actually the sponsor for
this episode, but more on them in a bit.
160
:So to test this tool out and to see
if it was any good, I asked one of
161
:my bootcamp students, you it, if
we could try it with her resume.
162
:So here's what we do, you use
the link in the show notes
163
:down below and you're going to.
164
:Upload your resume.
165
:So we'll go ahead and upload UITs
resume, then go for the job title
166
:you want in this case, data analyst.
167
:Next you're going to say your location
UITs is Charlotte, North Carolina.
168
:And finally, you're going to give a brief
summary of what your search goals are.
169
:So for her, it's going to land first.
170
:Data analyst job, you'll then press
next right here and wait a few
171
:seconds for it to finish the results.
172
:And bam, you get your own
personalized dashboard here.
173
:So on the left hand side, this is where
you have the top 10 job matches for you.
174
:Uh, and a little bit of
personalized tips right here.
175
:Then you have the job map here that lets
you see where the different jobs are
176
:and some basic information about them.
177
:So if you live in a certain
area, you can check it out there.
178
:And then on the right hand side.
179
:This is basically the top 10
jobs that it has for you with the
180
:descriptions, the location, the
company, as well as the salary.
181
:And of course, a link to apply.
182
:You'll need to hit control.
183
:Click to open that up.
184
:There's also a fun little histogram
up here that shows you kind of,
185
:uh, the salary distributions of
what you can kind of expect based
186
:off of the jobs it found for you.
187
:Pretty fun way to just find some new
jobs that you could possibly apply for.
188
:I have a link for you to try this tool
down in the description down below.
189
:So go try it out and let me know
what you think in the comments.
190
:I am of course, hoping it'll be
useful for you and help you find
191
:a few data jobs to apply for.
192
:But in the meantime, let me show you
how I built it and how you can actually
193
:build something quite similar, even
if you're not a data expert already.
194
:To start, I want to tell you about
why I chose to build this tool in
195
:nine, and you may have never heard of
nine before, and that's totally okay.
196
:I'll explain what it is and when you
might use it so that way if you ever
197
:see it on a job description, you don't
have to like panic and be like, oh my
198
:gosh, I have no idea what this thing
is, can I, I've never even heard of it.
199
:Right?
200
:Uh, let's explain what it's, so,
like I mentioned earlier, Nime is
201
:a data analytics and automation
platform, and it's honestly becoming
202
:a more popular choice of doing data
analytics and data engineering because
203
:one, it's free and open source and
we like free, we like open source.
204
:Who doesn't like that?
205
:Right?
206
:And number two, it makes data analytics
and data engineering honestly.
207
:Fun and easy using nine feels
like playing with data Legos.
208
:Instead of writing really long coding
scripts, you're actually pushing data
209
:through a visual workflow with data
building blocks like data Legos, and
210
:it's a lot easier to do complex data
manipulation because you're doing it with
211
:like little building blocks and Legos
instead of writing lots of code, which
212
:of course that makes it more fun and it
makes it a lot easier to do, especially
213
:if you're not even all that technical.
214
:You can do this stuff
and it's not too bad.
215
:Another reason I chose nine is it has
this awesome feature that makes it super,
216
:super, super easy to share data, web apps
like this resume one that I showed you
217
:earlier with just a couple clicks, and
that is insanely valuable, uh, because
218
:that's actually usually pretty hard to do.
219
:Let me explain why with a quick story.
220
:So when I was data scientist
at ExxonMobil, I was doing
221
:cool data science things.
222
:I was building cool data science projects,
and I like to think that these projects
223
:were technically difficult, right?
224
:We were doing cool things
where we were like.
225
:Predicting gasoline consumption
and trying to figure out what
226
:oils to buy around the world.
227
:And we were doing most of these projects
in Python, and it was like hundreds
228
:and hundreds of lines of Python code.
229
:We were using all sorts of different
Python libraries, some that you've heard
230
:of, some you've never heard of before.
231
:And we were using some decently
complicated machine learning algorithms.
232
:And so it wasn't easy.
233
:It was definitely like kind of hard.
234
:But despite all that.
235
:The hardest part might have
actually been when we actually
236
:finished writing all of the code.
237
:We're like, Hey, we built this really
cool tool, but how do we actually give
238
:it to end business user who doesn't know
how to use Python, doesn't have Python
239
:installed in their machine, doesn't
know anything about data, like how do
240
:we give it to a layman and be like, Hey,
we built this cool tool, now use it.
241
:Uh, and that was actually a
really hard question to solve.
242
:You could send them the script and
install Python on their computer, but
243
:that seems like overly complicated.
244
:And also, how do they actually run it?
245
:Do they just click run in like an id?
246
:It's, it's complicated.
247
:Do we just give it to a notebook?
248
:I don't know.
249
:That doesn't seem like we're
actually solving the problem.
250
:So, um, this is something that we
actually solved at Exxon most of the
251
:time by building pretty intensive.
252
:Web apps, but that required us to
write more Python codes, so we'd solve
253
:the problem with more Python code.
254
:And that took a ton of time and a ton
of resources because not only is it a
255
:lot of coding, but it's also a ton of
data engineering to give us like the
256
:access and like the CPUs and, uh, I don't
know, hosting it and all that stuff.
257
:It's, it's kinda over my pay grade, but it
was annoying and it would take forever and
258
:it would require a lot of people's help.
259
:Like I couldn't just do it by myself.
260
:At Exon.
261
:So with this tool with ny, it has like
this data app feature built right in,
262
:which makes it super easy to just hand
off to end business users like yourselves.
263
:So it's kinda like Tableau public.
264
:If you've ever used Tableau public
before, where you can just create
265
:a dashboard and share a link right
away, nys the exact same way where
266
:you can create these dashboards
or web apps and you have a link.
267
:You just copy that link and you can
literally send it to, uh, anyone you
268
:want to, and they can use your cool tool.
269
:So if you or your company are doing
complex data operations with lots
270
:of data manipulation, lots of data
visualization, and you wanna do it in
271
:like a simple, fun manner that makes it
easy to share and for easy for people to
272
:use, nine might be a really good choice.
273
:And that's when you'd want
to maybe check it out.
274
:So let me actually explain how you'd
use these data legos and how they work
275
:here by showing you how I built this
tool and how you could even rebuild
276
:it yourself or download the workflow
template and then just edit it and
277
:make some changes and make it your own.
278
:So basically what you need to know is this
workflow has three to four main parts,
279
:the resume part right here in yellow.
280
:The job part here in Orange.
281
:And then of course the dashboard part
here in red, which is kind of split
282
:into two with the AI part here, and then
the assembling the dashboard part here.
283
:Now each one of these little squares
that you see right here is called
284
:a node, and data flows in the node
from this direction or some sort
285
:of data transformation occurs.
286
:And then out the other side to future
nodes downstream as illustrated kind
287
:of with these arrows right here.
288
:Now, let's break down each one
of these sections one by one.
289
:The first part we have right here is
the resume portion, and this is just
290
:really a node right here, which basically
creates the landing page that you
291
:saw earlier with all those different
form questions to upload your resume
292
:and to tell them about yourselves.
293
:Now, usually building
webpage like this is.
294
:Pretty difficult to do, but seriously,
not super hard to do In a platform
295
:like nine where it's all low code,
drag and drop, no coding required.
296
:Next we have the job board section over
here, which is in orange, and the first
297
:thing we do here is we have our jobs API
note, which is actually just almost like
298
:a folder for a whole little mini work.
299
:Flow inside of the folder.
300
:Now you'll see here that we're using a
get request node, which just basically
301
:lets us call our job board API based
on the information that we gave it
302
:from that landing page, and you can
see some of the data inside of it.
303
:It's basically pulling the
titles, so on and so forth.
304
:Then the remaining nodes are
kind of just to clean and
305
:organized the job listing data.
306
:Job listing data obviously is
not super structured a lot of
307
:the time 'cause it's just words.
308
:It's not, numbers doesn't
fit like in a table, right?
309
:So this is just kind of us
organizing and cleaning that data.
310
:And then the remaining nodes inside this
section right here are essentially just
311
:doing more data cleanup, helping us create
the data that will feed into our LLM.
312
:We're also doing some data cleaning
down here with regular expressions where
313
:we're trying to pull out the salaries.
314
:Inside of the job descriptions and then
report that to you on the dashboard page.
315
:Now, all the data here basically
gets fed into this section right
316
:here, which is our AI section.
317
:The top nodes up here are where you're
going to input your own L-L-M-A-P-I
318
:keys, which is basically your password
to use some sort of tool like OpenAI
319
:inside of this app, and then of course
selecting what model you'd like to use.
320
:In this case, we are
choosing to use GPT-4 0.1,
321
:and then lastly, we have this
LLM prompter node down here at
322
:the bottom, which is essentially.
323
:Our message to chat GPT with
instructions on what to do.
324
:Now you'll notice with all these arrows,
it's getting our personal resume info,
325
:the job listing info, and all of the info
from the previous task passed into that.
326
:All of our information is then fed
into our final section right here,
327
:which is the dashboard node, and this
is the final page of the web app.
328
:This is where we have all the settings
to create the actual dashboard.
329
:Page.
330
:So to recap, in this workflow, we have
a form that first collects all of the
331
:user data, a data cleanup section that
extracts information from the resume,
332
:cleans it up, and then calls a job
board API, an AI section that creates
333
:custom tips for us based off of all
the previous information collected.
334
:And then lastly, our user-friendly
dashboards to display all
335
:that information to the user.
336
:And this is all built using nym.
337
:Data building Block Legos.
338
:So super fun to build
and super easy to do.
339
:So I hope you now see how it's
possible to do serious data analysis
340
:workflows using this type of platform.
341
:And I know a lot of companies are
using tools like Nine to simplify
342
:their lives, make it easy, and
create cool things like this.
343
:In fact, one of the alumnis.
344
:From my bootcamp, Trevor Maxwell,
use his name a decent amount at work.
345
:You can hear Trevor's full story of going
from printer technician to data analyst
346
:by clicking on the YouTube card here.
347
:Or I'll have a link to it
down below in the show note.
348
:And by the way, if you wanna customize
this workflow and make it your very
349
:own or make it better, 'cause I
definitely think it could be better.
350
:You totally can.
351
:So step one, you just wanna
download this example workflow.
352
:We'll have a link to it in
the description down below.
353
:Next, you'd want to download nine
and it's free to get started.
354
:We'll also have a link to that
down below in the description.
355
:And then lastly, you'd want to open
that downloaded workflow in nine.
356
:From here, you can edit any of the nodes
or add more nodes or take away things.
357
:You can literally do almost anything.
358
:Just remember, you'll need to enter
your own open AI API and job board API.
359
:And this is probably the
trickiest part since these are
360
:third party external tools.
361
:So that would be a little bit tricky.
362
:But other than that, you could
literally do so many things.
363
:You could increase the
number of jobs returned.
364
:You could add some analysis about
what skills are mentioned the most.
365
:Maybe you could even create some
sort of a scoring system, like
366
:there's so many different things
you could be doing with this guys.
367
:So go ahead, try it out.
368
:Overall, I hope you now one,
have a fun tool to test, to try
369
:to find different data jobs.
370
:Two, you understand how you
can actually analyze real data.
371
:With low code building blocks.
372
:Legos, right?
373
:It's a lot of fun.
374
:And three, I hope you know what
nine is, so you won't be scared
375
:when you see it on a job description
and you can be like, oh yeah, Avery
376
:talked about that in an episode.
377
:I'm hoping all of this is going
to help you on your data journey,
378
:and if you want more help on
your data journey, hit subscribe.
379
:I've got a lot more useful tips to share.