March 18, 2025 • 19 mins
In this episode I'll show you what it takes to land data analyst jobs! I'll provide in-depth insights and tips for six data analyst positions with salaries ranging from $35K to $200K-- and why should you apply even if you don't meet all the requirements.
💌 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
No College Degree As A Data Analyst Playlist: https://youtu.be/mSWtnjq4LRE?si=FlfChqSxIPBXc_Lb
⌚ TIMESTAMPS
Data Analyst Jobs: How Much $$$ Could You ACTUALLY Make???
00:00 - Introduction
00:21 - Data Analyst Job #1: Data Specialist ($35k)
04:00 - Data Analyst Job #2: Business and Data Analyst ($55k)
07:48 - Data Analyst Job #3: Data Visualization Analyst ($75k)
10:21 - Data Analyst Job #4: Senior Financial Analyst ($90k)
13:04 - Data Analyst Job #5: Senior Investment Operations Data Analyst ($125k)
14:35 - Data Analyst Job #6: Business Intelligence Engineer ($107k to $189k)
🔗 CONNECT WITH AVERY
🎥 YouTube Channel: https://www.youtube.com/@averysmith
🤝 LinkedIn: https://www.linkedin.com/in/averyjsmith/
📸 Instagram: https://instagram.com/datacareerjumpstart
🎵 TikTok: https://www.tiktok.com/@verydata
💻 Website: https://www.datacareerjumpstart.com/
Mentioned in this episode:
💙 Thank you for subscribing & leaving a review
Thanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.
Join The Next Cohort of The Accelerator
Want to land your first data job? Join my data bootcamp to get EVERYTHING you need to land your first data job! Excel, SQL, Tableau, Power BI, Python, R? Yup. Projects? Lots of them. LinkedIn help? Of course. Resume optimization? You betcha. Job hunting strategy? Duh. Click to learn more!
Mark as Played
Transcript
Episode Transcript
Available transcripts are automatically generated. Complete accuracy is not guaranteed.
Avery (00:00):
I'm about to show you what a 200, 000 data analyst job looks
like and what it takes to get there.
In this episode, I'll exploresix different data analyst
jobs ranging from 25K to 200K.
I'll explain what they pay.
What you need to do to be qualifiedand how you can actually land the job
(00:21):
starting with the lowest paying dataanalyst job that I could find job number
one is located in Fresno, California,and it pays drumroll please only 35, 000
well technically it pays 17 and 69 centsan hour and it's for a data specialist
role for an analytics firm in Californiacalled Avenue Insights and Analytics now
(00:45):
technically this Is a data specialistrole, which isn't really quite a data
analyst role, but often it's like thejob right below a data analyst, you'll
still be doing some sort of analysisand analytics, but it's also mixed with
some manual analysis, like looking atthings or some sort of data entry or
data validation or something like that.
(01:05):
The good news about that is it hasless requirements and we'll get to
those requirements here in a second.
But the bad news is it doesn't pay great.
You can honestly make more starting outas a cashier at Bucky's than this job.
But, but, but this job would help youget some relevant data experience on
your resume, which is very beneficial.
That would make landing a dataanalyst job down the road.
(01:26):
a lot easier.
Anytime you can get the word dataon your resume, it is a good thing.
So at this job, you'd basicallybe ensuring data accuracy, finding
leads from tax sheets and makingcorrections for state and local
governments, because that's actuallywhat this analytics firm does.
It comes into your state or localgovernment and does some basic
revenue and operations analysis.
(01:48):
for these local entities.
Fun, I know.
In terms of requirements, they arelooking for someone with an associate's
degree, attention to detail, andsome sort of ability to do some sort
of analysis and think critically.
This job also strangely requiresyou to be bilingual with Spanish and
English, which seems a little bitmore specialized and niche than usual.
(02:08):
Pero si puedes hablarespanol, You're good.
Like I said, it's inCalifornia and it's on site.
So even though it doesn't require alot of previous experience, I think
they're going to have a hard time fillingthis role because the pay isn't great.
It's on site and there's thatstrict bilingual aspect that
it's going to make it reallydifficult to find the right person.
I personally think that thisrole should pay more like
(02:30):
something around 50, 000 per year.
Not 35, by the way, all of these sixjobs that we're looking at today,
I found on my own data job board.
It's called find a data job.
com and it's a hundred percent free.
It has a great search and filterwidget on the left hand side that
allows you to search by title,company, salary, remote jobs.
(02:51):
So if you're looking for a placeto find less competitive data
jobs in the U S and Canada, besure to check it out, find a job.
com a hundred percent free.
And just a real quick note requirements onjob descriptions, in my opinion, are more
like wishlist than actual requirements.
Basically it's a way of companiessaying like, this is what we'd want in
a perfect world with perfect candidates.
(03:12):
But in reality, they're not even reallylikely to find one person that has.
All of those requirements.
And if they did the salary that they havelisted on the job description or that
they've allocated in the budget probablyisn't enough to properly compensate
this absolute unicorn of a data analyst.
So my personal recommendation and you'rewelcome to follow it or not is whenever
(03:33):
you're looking at job descriptions isto kind of look at them with blurry
eyes, like kind of squint your eyesat it and look at the descriptions.
If you fit.
Say 60%, 70%, 55 percentof the requirements.
And you're actually likeinterested in the job.
Like genuinely, I think you should applybecause you never know what might happen.
And honestly, the hiring manager whorejects you the most is actually yourself.
(03:58):
So go ahead and hit apply anyways.
Okay.
Job number two is located inthe great town of Pickerington.
Ohio.
And now I don't actuallyknow if it's a great town.
I've never even been to Ohio, butdoesn't it just have like a lovely
name and sound like a great place.
Now, job number two, it is a businessand data analyst role for the
(04:18):
American motorcycle association.
And how freaking cool is that to workfor the AMA, especially if you ride
a motorcycle, it sounds pretty cool.
In my opinion, like.
Fun job.
This job pays between55 and 60, 000 per year.
And if you heard me say that title andyou were kind of like, what the heck
did he just say, then you are correct.
Because a business and data analysttitle is a very interesting title.
(04:44):
It's not really onethat I've heard or seen.
Very often, or actually ever, it's usuallyjust like business analyst or just data
analyst, or maybe like business dataanalysts combined in some cases, but
certainly not business and data analysts.
That's sort of weird.
In fact, I search LinkedIn jobs to seeif I could find a similar titled role.
And sure enough, there was absolutely nomatches, at least in the market right now.
(05:08):
And that made me even more curious.
Cause it's like, what theheck is going on here?
So I went to the American motorcycleassociations, LinkedIn page and went to
the people tab and searched for analysts,by the way, side note, this is an
absolutely great way to network and try tolearn who actually is already inside the
company and who might be able to give youa referral for any jobs that you apply.
But when I searched for analysts.
(05:29):
Sure enough, like no one popped up.
And I think that there's no actualdata analyst or business analyst
working at this company right now.
This very well might be this company'sfirst day to hire, or at least first
in a while, I obviously can't bea hundred percent sure here, and I
could be wrong, but based on the verystrange title and no other analysts
that I could find on LinkedIn,working for this company, my guess is.
(05:50):
They don't really know what theywant or exactly what they're doing.
Once again, I could be wrong, but that ismy gut feeling that this company is kind
of new in the data maturity space, butthat's my gut feeling that this company
is kind of new to the whole data thing.
All right.
Regardless in this role, you'd be workingwith stakeholders to maintain and analyze.
data to identify trends and towork on some business processes.
(06:12):
They are asking for a bachelor'sdegree in business or computer science
or analytics or something similar.
And they also want one to three yearsof experience in some sort of analytics.
They want you to be proficient inExcel, SQL, Power BI, or Tableau.
And once again, when they'resaying Power BI or Tableau.
Or even like having Excel,SQL, Power BI, and Tableau be
(06:34):
all in the same sentence here.
It's kind of hinting that they don'thave a very mature data team because
like just take Power BI and Tableau, forexample, usually a small company like
this, it only has like a hundred employeeswould only have Tableau or Power BI.
Not really both large companies.
They often have both.
But they're both very expensive.
And so smaller companiesusually pick one or the other.
(06:54):
Now it's not always the case,but that is my gut feeling.
And so they probably don'tknow which one to choose.
And so maybe that would be somethingthat you would influence them on.
Now, if you're learning Tableau,learning Power BI isn't hard.
Like you'll be able to figure it out.
And sometimes I feel like companiesmaybe list Power BI or Tableau
because they're like, if you knowone, you'll figure out the other, but
I think that's actually pretty rare.
And I don't think that'swhat's happening here.
Anyways, this is a onsite role aswell, and it's quite a bit lower
(07:19):
than the average data analyst salaryin the U S which is around 82, 000.
They're requiring a bachelor's degree,one to three years of experience, and
the pay is a bit low for all of that.
So despite that, I thinkyou should apply anyways.
If you think that you fit maybe like60 percent or maybe even 50 percent of
the requirements for this job, the paythat they're listing is much more entry
level than their actual job description.
(07:40):
And with their data maturitybeing probably pretty low, you
might be surprised on the bitesthat you could possibly get in
applying for a job like this.
All right, next we have job number three.
This is the 75, 000 job andit is in Woodridge, Illinois.
It's for a company calledMahoney Environmental Solutions.
And this job is right around the averagedata analyst salary between 72 to 77, 000.
(08:05):
The title of this role isdata visualization analyst.
And now I purposely chose differenttitles for each of these six jobs that
I'm showing you, just to illustrate thatif you're only looking for data analyst
roles, you're probably missing out onlike more than half of the job market.
But I really do like this role.
I think it is quite interesting.
(08:26):
Now this company Mahoneyenvironmental solutions.
They're pretty interesting too, becauseat first I was like, okay, environmental
company, they probably do something likeclimate change or water purification
or like toxic something or other.
Right.
But after looking at theirwebsite, I was totally surprised.
And I think you'll be surprised as well.
It looks like they basically specializein one thing and only one thing,
(08:49):
which is removing used cooking oil.
And I think that just goes toshow that you can land a data job.
A data role in any industry forany company that does all sorts
of different things, right?
Like from Chuck E.
Cheese to Apple.
I don't know.
Sometimes we just think that like,Oh, it's only Facebook or that hires
like data analysts, but like even thiscompany that's just doing like grease
(09:10):
removal, they'll hire data analysts.
So interesting.
Data is literally everywhere.
You guys, you just got to look for it.
This role based on the descriptionsounds like you'd be building a
lot of power bi reports on theoperation side of the business.
It actually is quite a big business.
They have lots oflocations all over the US.
It does sound like there is some sortof queries that may or may not need
to be written to join a bunch of theirdata sets together in order to visualize
(09:33):
it in power bi requirements wise.
You're looking at Two plus years ofexperience with Power BI, DAX, and SQL.
And they also say thatPython is preferred.
They do mention that they're lookingfor someone with a BS in data science,
computer science, or a similar field.
Once again, you need to look at, or Iguess really in your case, hear all those
(09:54):
job descriptions with your eyes squinted.
This is just a wishlist.
For unicorn divide everything by two.
And if that's you apply, if youhave any bachelor's degree at all, I
personally think that fits the similarfield requirement for the education.
And I say, apply, go for it.
To me, this role is a bitmore than an entry level role.
So I think the pay should honestlybe closer to about 90, 000.
(10:15):
Here, but it does seem likea pretty interesting job
for an interesting company.
So if you're in an Illinois, this might bea good fit for you moving on to job number
four, and it's actually right next doorto job number three in Chicago, Illinois.
And it's with the Griffin museum ofscience and industry, which who knew
it is the largest and most interactivescience museum in the Western hemisphere.
Pretty cool, right?
(10:35):
Once again, like what a crazy companyand what an interesting industry.
I would never have thought thatlike museums are going to hire data
analysts, but apparently they do.
This role is for a senior financialanalyst role, and it pays just shy
of a hundred thousand dollars salaryrange is between 90 to 95, 000.
And you'll notice if you're payingattention that we've actually crossed
(10:56):
into the senior role territory.
And now just because a role is seniordoesn't mean that it's going to pay
more than like a non senior role.
There are lots of different factorslike where you're located, what your
experience is, what the company does, whatindustry they're in, so on and so forth.
With that senior jump.
We also are making that six figure jump,or at least we're getting close to it.
In this role, you'd be managing all of thefinancial and planning for the company.
(11:21):
You'd be reviewing budget reports,doing some pricing analytics
and predicting future revenue.
If you're accountant or you've worked inbanking or any sort of like financial role
in the past, this type of role, like afinancial analyst role would be an awesome
fit for you with your previous experience.
Now I will say.
The requirements for thisrole are pretty crazy.
(11:42):
It has the most strict and the highestbar of requirements, which is a bit
weird considering we still have the125, 000 job and the 200, 000 job left.
They want a bachelor's degreein finance or accounting.
Okay.
That's fine.
That's standard, right?
But with six to eight yearsof related experience, plus
they say public accountingexperience or an MBA are a plus.
(12:05):
And in terms of what skills they'reinterested in, they want power BI SQL and
advanced Excel financial modeling skills.
And just as a side note here, and prettyinteresting one as well, this is the
only time a graduate degree will bementioned in any of the job descriptions
that I read today, even the 200, 000 job.
So if you're considering a master'sdegree, just know that anecdotally
(12:26):
out of the six jobs that we randomlypulled today, a master's degree was
only mentioned once and it was mentionedas a plus, not as a requirement.
Now back to the job as a common trend.
The pay is a bit low for what'sbeing required, especially
if you already have an MBA.
But one thing to consider here and for allthese jobs as well is the cost of living.
One of my favorite tools is the cost ofliving salary calculator from NerdWallet.
(12:49):
It lets you put in your current salaryand your current location and where your
new location would be and it would displaywhat the actual salary would be according
to the cost of living in that new place.
So this job would be six figures.
If it was in say, California, nowwe've officially crossed the six
figure mark and we are moving toour 125, 000 job or job number five.
(13:11):
And it's in the sunny state of Californiain the beautiful city of Newport beach.
It's a senior investmentoperations data analyst.
That is a mouthful with Pacific lifeinsurance company and it pays between
111, 000 and 135, 000 per year.
Now you've maybe heard of this companybefore and in the name it's evidence
it it's a life insurance company.
(13:32):
So analytics is really important becausethis business, this whole industry.
It's basically one big math problem, theodds of you dying and how much the payout
would be to your benefactors, so on and soforth, based off previous conditions and
your current health in this role, you'dactually be analyzing more financial data,
a lot of financial data in this video.
Don't know why you'd becreating and redefining
(13:52):
dashboards for all of that data.
Talking to stakeholders, validating thedata for accuracy and consistency as well.
They're asking that you have a bachelor'sdegree in finance or the famous line here,
similar field or equivalent experience andfive plus years of experience with SAP,
Power BI, Power Query, Excel, and SQL.
Remember guys, squint at these.
(14:12):
Don't take it word for word.
I actually think this pay ishonestly pretty realistic.
I think it's pretty fair.
Maybe they should add on an extra10, 000 because cost of living
in California is quite high, butI actually think especially the
upper end is fairly reasonable.
And I actually think that youcould land this role with three
years of experience, not the five.
Once again, that's how I'dpersonally squint at this role.
And I would apply if I hadthree plus years of experience.
(14:35):
Surprisingly, this role also requiresmore experience than our last and
sixth job does pay nearly 200, 000.
It's just down the road inSanta Monica, California.
And it's a company that you've.
Definitely heard ofand probably used snap.
Yep.
Snapchat, you know, the app thatall the teenagers use to like
send those like pictures of theirfaces and say, Hey, what's up?
(14:55):
What are you doing?
Nothing much.
Yeah.
That company, this is a businessintelligence engineer role.
And it actually pays and get readyhere because this is a big range.
It pays between 107 and 189, 000 per year.
I was right, right?
That's a huge range.
And why is it?
Well, it's because this role might beremote friendly in California and Arizona.
I'm not actually sure the job descriptionis very confusing, but snap as a
(15:17):
company actually has what's calledgeographic pay zones that vary your
salary based on where you're located.
So if you're located in Washington orCalifornia or New York city, you'll
get paid in the a zone, which is themost if you're in Austin, Chicago,
Colorado, and a bunch of other States.
You are in the B zone and all the restof us are in the C zone, the lowest pay.
(15:38):
Now you'll notice that this is ourfirst job description that we've
had in the tech industry, right?
We did the analytics firm, amotorcycle club, the grease for moving
service, a museum and life insurance.
And now we are in software.
We're in apps.
We're in like.
Tech, right?
That's one of the reasonsyou'll see a high pay because
tech does have high salaries.
That's partially because they're reallylike in Seattle or LA or San Francisco.
(16:01):
And the cost of living in those areasis quite big, but also this role
doesn't have a huge barrier to entry.
They're only asking for a bachelor'sdegree in computer science,
math, physics, or related field.
That's what they all kindof have asked for, right?
Or equivalent years ofexperience, whatever that means.
But they're only really askingfor three years of experience.
And minimum, you shouldknow SQL and Python.
(16:22):
One thing that I really liked that Snapdid with this job description, and this
is becoming more popular, but still alot of companies aren't doing it, is
they put the minimum qualifications.
And then the preferred qualifications.
Like I said, not a lot of companies aredoing this, but it makes the process
for the job seeker so much easier.
Like that whole squintingthing I talked about basically
doing the squinting for you.
(16:42):
It's telling you what you need toknow and where you can get a leg up.
If you do know any of these thingsfor this particular job and the
preferred section, they're askingfor experience in big query, get
airflow and ETL type processes.
And in terms of salary, I feellike this is a pretty fair salary.
I mean, obviously it's a hugerange, but with three plus years
of experience, I do think it is.
Pretty good.
So there you have it.
(17:02):
Our six different salaries ranging from35, 000 all the way to 200, 000 per year.
Now I can already hear some of you guysin the comments asking, you know, all
these jobs that we looked at rangingfrom 35, 000 to 200, 000 a year, they
all required some college degrees.
Most of them bachelors.
You're probably going to ask, are thereany jobs that don't require degrees?
(17:24):
And the short answer is yes, there are.
They are less common, but they do exist.
I actually made this playlist herewith some interviews of people who
were able to land jobs without degrees.
It'll be right here on your screen,or if you're an audio listener, it'll
be in the show notes down below.
And the other half of you areprobably going to comment in the
comments, you know, where do I start?
What skills should I start with?
What should I be focusing on?
(17:45):
And I have a great episode for you here.
That will help you get started learningyour tech skills, where to actually start.
So just click right here, or youcan find it in the show notes.
Thanks for listening.
I'm about to show you what a 200, 000 data analyst job looks
like and what it takes to get there.
In this episode, I'll exploresix different data analyst
jobs ranging from 25K to 200K.
I'll explain what they pay.
What you need to do to be qualifiedand how you can actually land the job
(00:21):
starting with the lowest paying dataanalyst job that I could find job number
one is located in Fresno, California,and it pays drumroll please only 35, 000
well technically it pays 17 and 69 centsan hour and it's for a data specialist
role for an analytics firm in Californiacalled Avenue Insights and Analytics now
(00:45):
technically this Is a data specialistrole, which isn't really quite a data
analyst role, but often it's like thejob right below a data analyst, you'll
still be doing some sort of analysisand analytics, but it's also mixed with
some manual analysis, like looking atthings or some sort of data entry or
data validation or something like that.
(01:05):
The good news about that is it hasless requirements and we'll get to
those requirements here in a second.
But the bad news is it doesn't pay great.
You can honestly make more starting outas a cashier at Bucky's than this job.
But, but, but this job would help youget some relevant data experience on
your resume, which is very beneficial.
That would make landing a dataanalyst job down the road.
(01:26):
a lot easier.
Anytime you can get the word dataon your resume, it is a good thing.
So at this job, you'd basicallybe ensuring data accuracy, finding
leads from tax sheets and makingcorrections for state and local
governments, because that's actuallywhat this analytics firm does.
It comes into your state or localgovernment and does some basic
revenue and operations analysis.
(01:48):
for these local entities.
Fun, I know.
In terms of requirements, they arelooking for someone with an associate's
degree, attention to detail, andsome sort of ability to do some sort
of analysis and think critically.
This job also strangely requiresyou to be bilingual with Spanish and
English, which seems a little bitmore specialized and niche than usual.
(02:08):
Pero si puedes hablarespanol, You're good.
Like I said, it's inCalifornia and it's on site.
So even though it doesn't require alot of previous experience, I think
they're going to have a hard time fillingthis role because the pay isn't great.
It's on site and there's thatstrict bilingual aspect that
it's going to make it reallydifficult to find the right person.
I personally think that thisrole should pay more like
(02:30):
something around 50, 000 per year.
Not 35, by the way, all of these sixjobs that we're looking at today,
I found on my own data job board.
It's called find a data job.
com and it's a hundred percent free.
It has a great search and filterwidget on the left hand side that
allows you to search by title,company, salary, remote jobs.
(02:51):
So if you're looking for a placeto find less competitive data
jobs in the U S and Canada, besure to check it out, find a job.
com a hundred percent free.
And just a real quick note requirements onjob descriptions, in my opinion, are more
like wishlist than actual requirements.
Basically it's a way of companiessaying like, this is what we'd want in
a perfect world with perfect candidates.
(03:12):
But in reality, they're not even reallylikely to find one person that has.
All of those requirements.
And if they did the salary that they havelisted on the job description or that
they've allocated in the budget probablyisn't enough to properly compensate
this absolute unicorn of a data analyst.
So my personal recommendation and you'rewelcome to follow it or not is whenever
(03:33):
you're looking at job descriptions isto kind of look at them with blurry
eyes, like kind of squint your eyesat it and look at the descriptions.
If you fit.
Say 60%, 70%, 55 percentof the requirements.
And you're actually likeinterested in the job.
Like genuinely, I think you should applybecause you never know what might happen.
And honestly, the hiring manager whorejects you the most is actually yourself.
(03:58):
So go ahead and hit apply anyways.
Okay.
Job number two is located inthe great town of Pickerington.
Ohio.
And now I don't actuallyknow if it's a great town.
I've never even been to Ohio, butdoesn't it just have like a lovely
name and sound like a great place.
Now, job number two, it is a businessand data analyst role for the
(04:18):
American motorcycle association.
And how freaking cool is that to workfor the AMA, especially if you ride
a motorcycle, it sounds pretty cool.
In my opinion, like.
Fun job.
This job pays between55 and 60, 000 per year.
And if you heard me say that title andyou were kind of like, what the heck
did he just say, then you are correct.
Because a business and data analysttitle is a very interesting title.
(04:44):
It's not really onethat I've heard or seen.
Very often, or actually ever, it's usuallyjust like business analyst or just data
analyst, or maybe like business dataanalysts combined in some cases, but
certainly not business and data analysts.
That's sort of weird.
In fact, I search LinkedIn jobs to seeif I could find a similar titled role.
And sure enough, there was absolutely nomatches, at least in the market right now.
(05:08):
And that made me even more curious.
Cause it's like, what theheck is going on here?
So I went to the American motorcycleassociations, LinkedIn page and went to
the people tab and searched for analysts,by the way, side note, this is an
absolutely great way to network and try tolearn who actually is already inside the
company and who might be able to give youa referral for any jobs that you apply.
But when I searched for analysts.
(05:29):
Sure enough, like no one popped up.
And I think that there's no actualdata analyst or business analyst
working at this company right now.
This very well might be this company'sfirst day to hire, or at least first
in a while, I obviously can't bea hundred percent sure here, and I
could be wrong, but based on the verystrange title and no other analysts
that I could find on LinkedIn,working for this company, my guess is.
(05:50):
They don't really know what theywant or exactly what they're doing.
Once again, I could be wrong, but that ismy gut feeling that this company is kind
of new in the data maturity space, butthat's my gut feeling that this company
is kind of new to the whole data thing.
All right.
Regardless in this role, you'd be workingwith stakeholders to maintain and analyze.
data to identify trends and towork on some business processes.
(06:12):
They are asking for a bachelor'sdegree in business or computer science
or analytics or something similar.
And they also want one to three yearsof experience in some sort of analytics.
They want you to be proficient inExcel, SQL, Power BI, or Tableau.
And once again, when they'resaying Power BI or Tableau.
Or even like having Excel,SQL, Power BI, and Tableau be
(06:34):
all in the same sentence here.
It's kind of hinting that they don'thave a very mature data team because
like just take Power BI and Tableau, forexample, usually a small company like
this, it only has like a hundred employeeswould only have Tableau or Power BI.
Not really both large companies.
They often have both.
But they're both very expensive.
And so smaller companiesusually pick one or the other.
(06:54):
Now it's not always the case,but that is my gut feeling.
And so they probably don'tknow which one to choose.
And so maybe that would be somethingthat you would influence them on.
Now, if you're learning Tableau,learning Power BI isn't hard.
Like you'll be able to figure it out.
And sometimes I feel like companiesmaybe list Power BI or Tableau
because they're like, if you knowone, you'll figure out the other, but
I think that's actually pretty rare.
And I don't think that'swhat's happening here.
Anyways, this is a onsite role aswell, and it's quite a bit lower
(07:19):
than the average data analyst salaryin the U S which is around 82, 000.
They're requiring a bachelor's degree,one to three years of experience, and
the pay is a bit low for all of that.
So despite that, I thinkyou should apply anyways.
If you think that you fit maybe like60 percent or maybe even 50 percent of
the requirements for this job, the paythat they're listing is much more entry
level than their actual job description.
(07:40):
And with their data maturitybeing probably pretty low, you
might be surprised on the bitesthat you could possibly get in
applying for a job like this.
All right, next we have job number three.
This is the 75, 000 job andit is in Woodridge, Illinois.
It's for a company calledMahoney Environmental Solutions.
And this job is right around the averagedata analyst salary between 72 to 77, 000.
(08:05):
The title of this role isdata visualization analyst.
And now I purposely chose differenttitles for each of these six jobs that
I'm showing you, just to illustrate thatif you're only looking for data analyst
roles, you're probably missing out onlike more than half of the job market.
But I really do like this role.
I think it is quite interesting.
(08:26):
Now this company Mahoneyenvironmental solutions.
They're pretty interesting too, becauseat first I was like, okay, environmental
company, they probably do something likeclimate change or water purification
or like toxic something or other.
Right.
But after looking at theirwebsite, I was totally surprised.
And I think you'll be surprised as well.
It looks like they basically specializein one thing and only one thing,
(08:49):
which is removing used cooking oil.
And I think that just goes toshow that you can land a data job.
A data role in any industry forany company that does all sorts
of different things, right?
Like from Chuck E.
Cheese to Apple.
I don't know.
Sometimes we just think that like,Oh, it's only Facebook or that hires
like data analysts, but like even thiscompany that's just doing like grease
(09:10):
removal, they'll hire data analysts.
So interesting.
Data is literally everywhere.
You guys, you just got to look for it.
This role based on the descriptionsounds like you'd be building a
lot of power bi reports on theoperation side of the business.
It actually is quite a big business.
They have lots oflocations all over the US.
It does sound like there is some sortof queries that may or may not need
to be written to join a bunch of theirdata sets together in order to visualize
(09:33):
it in power bi requirements wise.
You're looking at Two plus years ofexperience with Power BI, DAX, and SQL.
And they also say thatPython is preferred.
They do mention that they're lookingfor someone with a BS in data science,
computer science, or a similar field.
Once again, you need to look at, or Iguess really in your case, hear all those
(09:54):
job descriptions with your eyes squinted.
This is just a wishlist.
For unicorn divide everything by two.
And if that's you apply, if youhave any bachelor's degree at all, I
personally think that fits the similarfield requirement for the education.
And I say, apply, go for it.
To me, this role is a bitmore than an entry level role.
So I think the pay should honestlybe closer to about 90, 000.
(10:15):
Here, but it does seem likea pretty interesting job
for an interesting company.
So if you're in an Illinois, this might bea good fit for you moving on to job number
four, and it's actually right next doorto job number three in Chicago, Illinois.
And it's with the Griffin museum ofscience and industry, which who knew
it is the largest and most interactivescience museum in the Western hemisphere.
Pretty cool, right?
(10:35):
Once again, like what a crazy companyand what an interesting industry.
I would never have thought thatlike museums are going to hire data
analysts, but apparently they do.
This role is for a senior financialanalyst role, and it pays just shy
of a hundred thousand dollars salaryrange is between 90 to 95, 000.
And you'll notice if you're payingattention that we've actually crossed
(10:56):
into the senior role territory.
And now just because a role is seniordoesn't mean that it's going to pay
more than like a non senior role.
There are lots of different factorslike where you're located, what your
experience is, what the company does, whatindustry they're in, so on and so forth.
With that senior jump.
We also are making that six figure jump,or at least we're getting close to it.
In this role, you'd be managing all of thefinancial and planning for the company.
(11:21):
You'd be reviewing budget reports,doing some pricing analytics
and predicting future revenue.
If you're accountant or you've worked inbanking or any sort of like financial role
in the past, this type of role, like afinancial analyst role would be an awesome
fit for you with your previous experience.
Now I will say.
The requirements for thisrole are pretty crazy.
(11:42):
It has the most strict and the highestbar of requirements, which is a bit
weird considering we still have the125, 000 job and the 200, 000 job left.
They want a bachelor's degreein finance or accounting.
Okay.
That's fine.
That's standard, right?
But with six to eight yearsof related experience, plus
they say public accountingexperience or an MBA are a plus.
(12:05):
And in terms of what skills they'reinterested in, they want power BI SQL and
advanced Excel financial modeling skills.
And just as a side note here, and prettyinteresting one as well, this is the
only time a graduate degree will bementioned in any of the job descriptions
that I read today, even the 200, 000 job.
So if you're considering a master'sdegree, just know that anecdotally
(12:26):
out of the six jobs that we randomlypulled today, a master's degree was
only mentioned once and it was mentionedas a plus, not as a requirement.
Now back to the job as a common trend.
The pay is a bit low for what'sbeing required, especially
if you already have an MBA.
But one thing to consider here and for allthese jobs as well is the cost of living.
One of my favorite tools is the cost ofliving salary calculator from NerdWallet.
(12:49):
It lets you put in your current salaryand your current location and where your
new location would be and it would displaywhat the actual salary would be according
to the cost of living in that new place.
So this job would be six figures.
If it was in say, California, nowwe've officially crossed the six
figure mark and we are moving toour 125, 000 job or job number five.
(13:11):
And it's in the sunny state of Californiain the beautiful city of Newport beach.
It's a senior investmentoperations data analyst.
That is a mouthful with Pacific lifeinsurance company and it pays between
111, 000 and 135, 000 per year.
Now you've maybe heard of this companybefore and in the name it's evidence
it it's a life insurance company.
(13:32):
So analytics is really important becausethis business, this whole industry.
It's basically one big math problem, theodds of you dying and how much the payout
would be to your benefactors, so on and soforth, based off previous conditions and
your current health in this role, you'dactually be analyzing more financial data,
a lot of financial data in this video.
Don't know why you'd becreating and redefining
(13:52):
dashboards for all of that data.
Talking to stakeholders, validating thedata for accuracy and consistency as well.
They're asking that you have a bachelor'sdegree in finance or the famous line here,
similar field or equivalent experience andfive plus years of experience with SAP,
Power BI, Power Query, Excel, and SQL.
Remember guys, squint at these.
(14:12):
Don't take it word for word.
I actually think this pay ishonestly pretty realistic.
I think it's pretty fair.
Maybe they should add on an extra10, 000 because cost of living
in California is quite high, butI actually think especially the
upper end is fairly reasonable.
And I actually think that youcould land this role with three
years of experience, not the five.
Once again, that's how I'dpersonally squint at this role.
And I would apply if I hadthree plus years of experience.
(14:35):
Surprisingly, this role also requiresmore experience than our last and
sixth job does pay nearly 200, 000.
It's just down the road inSanta Monica, California.
And it's a company that you've.
Definitely heard ofand probably used snap.
Yep.
Snapchat, you know, the app thatall the teenagers use to like
send those like pictures of theirfaces and say, Hey, what's up?
(14:55):
What are you doing?
Nothing much.
Yeah.
That company, this is a businessintelligence engineer role.
And it actually pays and get readyhere because this is a big range.
It pays between 107 and 189, 000 per year.
I was right, right?
That's a huge range.
And why is it?
Well, it's because this role might beremote friendly in California and Arizona.
I'm not actually sure the job descriptionis very confusing, but snap as a
(15:17):
company actually has what's calledgeographic pay zones that vary your
salary based on where you're located.
So if you're located in Washington orCalifornia or New York city, you'll
get paid in the a zone, which is themost if you're in Austin, Chicago,
Colorado, and a bunch of other States.
You are in the B zone and all the restof us are in the C zone, the lowest pay.
(15:38):
Now you'll notice that this is ourfirst job description that we've
had in the tech industry, right?
We did the analytics firm, amotorcycle club, the grease for moving
service, a museum and life insurance.
And now we are in software.
We're in apps.
We're in like.
Tech, right?
That's one of the reasonsyou'll see a high pay because
tech does have high salaries.
That's partially because they're reallylike in Seattle or LA or San Francisco.
(16:01):
And the cost of living in those areasis quite big, but also this role
doesn't have a huge barrier to entry.
They're only asking for a bachelor'sdegree in computer science,
math, physics, or related field.
That's what they all kindof have asked for, right?
Or equivalent years ofexperience, whatever that means.
But they're only really askingfor three years of experience.
And minimum, you shouldknow SQL and Python.
(16:22):
One thing that I really liked that Snapdid with this job description, and this
is becoming more popular, but still alot of companies aren't doing it, is
they put the minimum qualifications.
And then the preferred qualifications.
Like I said, not a lot of companies aredoing this, but it makes the process
for the job seeker so much easier.
Like that whole squintingthing I talked about basically
doing the squinting for you.
(16:42):
It's telling you what you need toknow and where you can get a leg up.
If you do know any of these thingsfor this particular job and the
preferred section, they're askingfor experience in big query, get
airflow and ETL type processes.
And in terms of salary, I feellike this is a pretty fair salary.
I mean, obviously it's a hugerange, but with three plus years
of experience, I do think it is.
Pretty good.
So there you have it.
(17:02):
Our six different salaries ranging from35, 000 all the way to 200, 000 per year.
Now I can already hear some of you guysin the comments asking, you know, all
these jobs that we looked at rangingfrom 35, 000 to 200, 000 a year, they
all required some college degrees.
Most of them bachelors.
You're probably going to ask, are thereany jobs that don't require degrees?
(17:24):
And the short answer is yes, there are.
They are less common, but they do exist.
I actually made this playlist herewith some interviews of people who
were able to land jobs without degrees.
It'll be right here on your screen,or if you're an audio listener, it'll
be in the show notes down below.
And the other half of you areprobably going to comment in the
comments, you know, where do I start?
What skills should I start with?
What should I be focusing on?
(17:45):
And I have a great episode for you here.
That will help you get started learningyour tech skills, where to actually start.
So just click right here, or youcan find it in the show notes.
Thanks for listening.
Popular Podcasts
Stuff You Should Know
If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.
Dateline NBC
Current and classic episodes, featuring compelling true-crime mysteries, powerful documentaries and in-depth investigations. Follow now to get the latest episodes of Dateline NBC completely free, or subscribe to Dateline Premium for ad-free listening and exclusive bonus content: DatelinePremium.com
On Purpose with Jay Shetty
I’m Jay Shetty host of On Purpose the worlds #1 Mental Health podcast and I’m so grateful you found us. I started this podcast 5 years ago to invite you into conversations and workshops that are designed to help make you happier, healthier and more healed. I believe that when you (yes you) feel seen, heard and understood you’re able to deal with relationship struggles, work challenges and life’s ups and downs with more ease and grace. I interview experts, celebrities, thought leaders and athletes so that we can grow our mindset, build better habits and uncover a side of them we’ve never seen before. New episodes every Monday and Friday. Your support means the world to me and I don’t take it for granted — click the follow button and leave a review to help us spread the love with On Purpose. I can’t wait for you to listen to your first or 500th episode!