No video :(

Data Engineer vs Data Analyst | Which Is Right For You?

Подписаться 856 тыс.

Просмотров 84 тыс.

50% 1

In this video we discuss the differences between a Data Engineer and a Data Analyst. There is actually quite of bit of overlap in terms of skills for these two positions. Hopefully this will help you determine which job is right for you!
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
Google Data Analyst Certification: coursera.pxf.i...
Data Analysis with Python - coursera.pxf.i...
IBM Data Analysis Specialization - coursera.pxf.i...
Tableau Data Visualization - coursera.pxf.i...
Udemy Courses:
Python for Data Analysis and Visualization- bit.ly/3hhX4LX
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON
Patreon Page - / alextheanalyst
Every dollar donated is put back into my channel to make my videos even better. Thank you all so much for your support!
____________________________________________
Websites:
GitHub: github.com/Ale...
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for

Опубликовано:

5 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 146

@mldylws 3 года назад

Thank you for posting this! I might be starting my career as a data engineer and this clarified what I might be doing at my new job :)

@AlexTheAnalyst 3 года назад

That’s super cool! Glad to hear it! Good luck in your (hopefully) new job 😁

@asadon1950 3 года назад

This helped so much! The number of job descriptions that put all the skills for both down as just a data analyst position will really grind my gears now.

@AlexTheAnalyst 3 года назад

As it should! Glad it helped! 😁

@Michael.storen 2 года назад

Well this confirmed I dont want to be a data engineer.

@TheArchmage100 Месяц назад

Scared of high tech programmes? 😂 I know the feeling mate.

@Lori_C 3 года назад

Before this video even starts, I want to thank you for making it. I’ve been following your channel and found it really informative but then learned about data engineering as a career path and feel it would suit me much better and have been desperately looking for more resources about it. I already work with data and have been trying to pick up the right skills to go for data analyst positions but now want to pursue data engineering- I’m just trying to figure out how! So thank you and I would love if you could explore this area further.

@AlexTheAnalyst 3 года назад

That’s super cool! I’m glad you found something that works for you. So glad my channel has been helpful for you in your journey 😁

@AntJK2008 3 года назад

Thanks for the video Alex. Helps me validate my choice to take some part-time courses in the Data Analyst domain to upgrade my skills and find a job as a Data Analyst. I’ve been doing some of that type of work in BA and Admin roles I’ve held in the past. Cheers, Antony

@AlexTheAnalyst 3 года назад

You're very welcome! I wish you the best of luck!

@mercantilism954 3 года назад

In my understanding, Data engineer is more like a software engineer focusing on database. It requires many technical skills. In term of number of jobs available, data engineering outweighs over data scientist and data analyst and also pays better. It’ s easier to transfer to a software engineer. I have no interest in data engineering but if data engineering is a better option, I might need to consider that.

@AfrooBlack 3 года назад

The pay is by far better and you know why? Nobody has no clue what a data engineer does so they don't purse it. Data scientists are now considered luxury roles. Not really needed. My company has about 20-30 data scientist but they rarely receive work. Our clients rarely needs there services. We're hiring 2-3 data engineers every SINGLE WEEK. I was one of those data engineers hired about 5 weeks ago. So right now I make 100k+. The company is in NY but I live in ATL.(NY pay no joke)

@_DOSS 2 года назад

@@AfrooBlack Do you have IT background? If so, what is it?

@kristenk708 2 года назад

@@AfrooBlack I am and a data analyst but want to work towards data engineer. What are the skills for that and what should I focus on?

@torontonian77 2 года назад

@@kristenk708 you should master Python and SQL. Learn everything you can about ETL and Data Warehousing (read the book by Kimball). You should get at least one cloud certification, whether AWS, Azure, or GCP. That's a start.

@davisonyeoguzoro9232 Год назад

@@AfrooBlack How do I get started please?

@imt3206 3 года назад

Dude, you're fucking awesome. Thanks to you I can get to know a lot of the data industry and a lot about what career is the best fit for me. Thank you. New subscriber.

@AlexTheAnalyst 3 года назад

Haha super glad to hear it! Thanks for watching! 😁

@tatiana7278 3 года назад

Great content! Wow. Straight to the point and brief. Thank you

@AlexTheAnalyst 3 года назад

Thank you! That's definitely my style! Haha unless it's my ATA Show which is my longer form content

@wanderingwithyanvlogs 2 года назад

Thanks for this! This was super clear and well put together

@gianniprocida3332 2 года назад

Thank you for this video ! You really helped me to clear things up for me

@moonyaco Год назад

Thank you for this video. Before watching this, I had a call asking me about my understanding of the data analyst and data engineer role. I knew nothing about the data engineer role and the hiring company was mostly concerned about how good I am at SQL and Python. Since I was still trying to get my feet wet through an entry level data analyst job, I am still learning Python through online videos. I was surprised that they only had a data engineer position available and did not mind that I had a commerce degree instead of the a data/statistics/math related one. After watching this video, I'm pretty sure, as someone who has only gone through courses related to data analysis, data engineers are definitely require a whole lot more training before they can get hired relative to a data analyst.

@shibayamatomoki8430 3 года назад

Someone once said a Data Engineer is (in the simplest, layman, nutshell description): "Half data scientist, half software engineer (or analyst/developer)." I wonder how much of that is still true?

@AfrooBlack 3 года назад

Yes that's kinda true. I'm a jr. data engineer and i would say we kind code a lot. But honestly Devops knowledge will start becoming required later in the future I think.

@TheCazz10 3 года назад

Great info, thanks and Merry Christmas!

@AlexTheAnalyst 3 года назад

Merry Christmas to you too!

@jackiewhee 2 года назад

Thank you so much for this video and all the helpful replies in the comments. It really helped me a lot to decide what I should focus on now.

@fartinmartin5 3 года назад

Interesting, I like these analyst vs videos, but in my experience as an data analyst, you tend to end up getting roped into aspects of all of the above, business analyst, data scientist, and data engineer

@vinitransubhe6794 3 года назад

Thank you so much for video & making us aware of the data world. I have career in Data world for last 12 years. I can very well relate that how skill sets carries the stream in Data.

@ibraheemkhan3665 3 года назад

How smooth is the transition from being a data analyst to a data engineer?

@This_z_Bindu 3 года назад

Thanks for the video Alex😊👍

@loveisriveroflifemystic9887 3 года назад

A Clear and Neat presentation 👌

@AlexTheAnalyst 3 года назад

Thank you! And thanks for watching 😁

@charlesgrace2611 3 года назад

I'm currently finishing up a data analyst track, but after watching this video I'm more curious about data engineering. Is there a minimum I can learn in data engineering (in Python and Azure in particular) as an aspiring analyst that can make me fit for a minor role as an engineer and is that practical, more lucrative for me, and/or more attractive to prospective employers? Love this channel btw, you have been a HUGE help for someone like me with NO previous technical ability.

@AlexTheAnalyst 3 года назад

Super glad to hear that! I think the best thing to do is to take some courses on data engineering in your free time. You'll learn plenty of things that you can still apply to your DA work. Learning more advanced SQL or learning SSIS (ETL tool) will help you in a DA job too for example.

@mattiapancin3926 3 года назад

Thanks. Your contents are super relevant !! ciao😄

@AlexTheAnalyst 3 года назад

You’re very welcome! Thanks for watching! 😁

@mayurnarayan1 3 года назад

Here in India some companies expect a data analyst to know ETL , data warehousing i.e data engineering stuff

@CJ-fh5xq 3 года назад

I know Data Scientist is a hot field right now. Is there more job postings for being a Data Scientist versus a Data Engineer?

@rrahll 2 года назад

Thanks mate, it was helpful )

@equiwave80 3 года назад

Can't believe it... Amazing coincidence. ... I was just completing a udemy course for the DP-900 Data Fundamentals exam preparation. This was discussed briefly... Difference between a Data Engineer and Data Analyst!!! Thanks for the video 👍

@AlexTheAnalyst 3 года назад

Haha great minds think alike 😁

@ninamncube4476 11 месяцев назад

Great video, very clear and concise

@icelerate8141 Год назад

I prefer Data Scientist and Data Analyst compared to Data Engineer. Not sure what I prefer between Data Scientist and Data Analyst though. Due to that, I am aiming to eventually master skills from both.

@nemuelpaiva3738 Год назад

i am in the same path but it is hard to get a data analyst role and I heard that a data engineer pays more. i like data analyst and scientist tho.

@icelerate8141 Год назад

@@nemuelpaiva3738 Is it hard to get a data analyst role compared to data scientist or data engineer or both?

@nemuelpaiva3738 Год назад

@@icelerate8141 lol I do not know that my friend I am just looking for an entry data analyst role right now since I graduate in May but it is very competitive because nowadays entry levels jobs= have 3+ years of experience. what I do know because of his channel is that to become a DS you will need to have a master's degree. I stick to my decision to become a data analyst because, at the end of this video, he mentioned that DA is more like an entry-level and it kinda fits my personality as well.

@arcaneknight9799 3 года назад

Nice! Mosh said that Python Programmers with experience can make $115K in the US on average. Thoughts?

@AlexTheAnalyst 3 года назад

It’s definitely possible in certain industries! I don’t know if that’s the average, but definitely achievable.

@yishaktaye1951 3 года назад

Thank you sir for your video....I find this and the other videos you talk about interview questions are very helpful....I have been thought most of the data analytics tools...I have applied on some data analytics jobs but have not got a chance for interview...I would appreciate if you share us your experience on job search or creating network with recruiters. Thank you sir..

@AlexTheAnalyst 3 года назад

Hey Yishak! I do have 2 videos that may be helpful to you - one is specifically on working with recruiters. Another is how to find a job on LinkedIn. Hope those help!

@assiat6695 2 года назад

very helpful , thanks Alex

@romansorokin2747 Год назад

I love your videos and description. However weather I was an Analyst and Engineer, I have never ever got asked about my degree during an interview. Just fyi, I have a GED.

@mahdiamjadi1887 3 года назад

thanks alex it's so useful video

@MariaSantos-uk1go 3 года назад

Hey Alex, just starting following your channel today and I've enjoying your videos a lot. I'm graduating from my Bachelors in Physics in June and I like programming a lot, I have learnt for the past 3 years. I also found myself archiving very good results when working with data and "treating" it. I'm looking for a job before I move on with a higher degree and I find myself between Software Development and Data Analytics. My fear is that working in Data Analytics I start to lose my developer side that I like so much. Anyways, what job would you say that it would be a good marriage between my scientist side and my developer side? Thank you and I'm sorry if this question is too specific :D

@AlexTheAnalyst 3 года назад

Data Scientist will probably be a good mend of those skill sets. I can't think of much else that would combine those together haha and so glad to hear you're enjoying the channel! :D

@MariaSantos-uk1go 3 года назад

@@AlexTheAnalyst thank you for the reply! Do you think it is possible for me to start as data analyst and then become a data sciencist? I currently have good skills for the first one and I can't afford a Master's right now and all the job searches I've been doing here in Portugal require a Master's for data science.

@The_Original_Hybrid 2 года назад

@@MariaSantos-uk1go Have you seen the online master's degrees in DS from Georgia Tech and UT Austin? Both programs are ~$10K.

@danielsampedrorosello9313 3 года назад

every day I'm more sure that I wanna be a data analyst😂 btw next year when I finish the big data master I will have to decide😬😳

@JJ_TheGreat 3 года назад

So what is the difference between a data engineer and a data scientist? I am surprised you didn't compare all 3 in one video.

@jonathannali7682 3 года назад

I am a little confused. What I understand and know is that a Data Analyst's work can shape/determine the future of a company by finding trends and predicting behavior. So then why does a Data Engineer earn more? Secondly, which of these two is more likely to head towards MD or CEO of a company?

@AlexTheAnalyst 3 года назад

It definitely can, but data engineers typically require more technical skills and education. This leads to higher pay. I think a data analyst is more likely simply due to the critical thinking and problem solving skills.

@handsomelok 3 года назад

Thank you for your video, it has been very helpful keep up the good work

@jesso6670 3 года назад

Hai, I did a project in my course with team. We collect data from different websites and saved into our pub/sub in gcp from there we use kubernetiecs to activate our process to collect data everyweek one specific day. Once data come to pub /sub using big query we clean data and analyze data ml. And visualize using Java script on another website. Basically I designed the cloud system did api to call data to the pub sub. So am I a data engineer

@junior91913 Год назад

Hi Alex I'm a big fan of your videos now I'm taking your data analyst bootcamp course on RU-vid and already fall in love with this course. I have one doubt doing data analyst job for 2 years and then shift to data engineering job did that previous 2 years experience in D.A count in D.E ?

@blackmyth208 3 года назад

I'm a civil engineer with python tableau and sql experience. What else do I need to add to become a data engineer? Thanks.

@AfrooBlack 3 года назад

SQL, ETL fundamentals, ADF and databricks. Learn these and you'll be soooo marketable. I'm a jr. data engineer and not gonna lie, it's tough depending on the company you work for but worth it. My co-worker makes 210k in NY as a data engineer and I see why. Dudes a monster when talking with these clients.

@blackmyth208 3 года назад

@@AfrooBlack you're out there with the sharks and wolves. Thank you for this! Now I have a guide. Seems a lot of videos take forever to get to the point.

@AfrooBlack 3 года назад

@@blackmyth208 Honestly since you have SQL experience things will be easy for you. If your good with joins and using stored producers then don't worry. The big gains where you'll need to learn is data factory and building pipelines. There so many tools you can use but ADF is what a lot of company's use so try and get familiar with it. Then Databricks would be next. Understanding spark will be sooo helpful as well. Working with a few clients lots of them use scala so if you can get familiar with it then u'd be a beast. Data engineer on our team don't even touch anything with scala, they only use python and sql which is okay too. Money is 100%%%%% worth it. Gonna quit December tho and take a offer as a sql developer. There's levels to becoming a data engineer. I got 4 certs and a company hired me as a jr. DE and i realized wtf did I just do. Working as a SQL Dev, or ETL Dev, or even a data analyst are the small steps i'd need to take to be a real good data engineer instead of just jumping to the role.

@blackmyth208 3 года назад

@@AfrooBlack this is awesome! Thanks bro I really appreciate it truly.

@Aiu-sama 2 года назад

@@AfrooBlack would u recommend to become a data analyst first and then data engineer, if so how smooth is the transition?

@Havish_Arizona 3 года назад

Hi Alex, tanks for providing your expertise and information on these carriers. Could you please share good books for Data Analytics?

@AlexTheAnalyst 3 года назад

Here are the only 2 books I read on analytics I actually liked: Python for Data Analysis Book - amzn.to/3dDneGq SQL Beginner's Guide to Managing and Analyzing With SQL Book - amzn.to/2X5341B

@raal6766 3 года назад

Hey Alex, thank you for your content. Currently I’m looking into switching careers and start in a wider field with more opportunities, I was introduced by somebody a Data Scientist boot camp , I would like to know your thoughts about this? is this worth it ? I do not have any experience in SQL, phyton, or in any of this field , however, I’m a quick learner . I have experience collecting data as past jobs in a junior engineer position . but not too much experience, I have seen job postings for data analysts and data scientist that they requieres specific engineering’s, What are the odds of getting a job after doing a high intensive boot camp of 4 months ? Thank you

@AlexTheAnalyst 3 года назад

I think it can definitely be a possibility, but it depends a lot on the bootcamp as well as the industry you're going into. I think that you definitely could make it happen.

@jralz4620 3 года назад

@@AlexTheAnalyst What makes a good bootcamp good? :) so I can see if the one that Im thinking about it is worth it or no haha

@mohamedshams9347 2 года назад

thanks much alex for this informations , i have a small question if you can help me with it please , i am doing a career shift as a fresh graduated civil engineering to data science and i was confused about which field would be better for me to become a data engineer or data analyst, which one would be easier for me to go with and would be better in the feature as someone who would start from scratch. any advice would be appreciated. thanks much

@applepeel1662 3 года назад

Hi Alex love your videos. I have a business undergraduate and am planning to get into business analytics. However, as I have a 3 year degree and to get into analytics programs, I have to do a MBA of sorts So is it better to get all these degrees or will knowledge from the internet be enough?

@AlexTheAnalyst 3 года назад

If you have any experience with your business degree and you can learn all of the data analyst skills on your own, I think that’s a great route to go. If nothing else you can learn in your free time and see if you’re learning quickly or if you think you’ll need to go back to school to really invest your time.

@Gamezone_Bike 3 года назад

Thank you for this video ❤️ help full

@AlexTheAnalyst 3 года назад

You're very welcome Manish!

@kapuriaritik 3 года назад

Hey Alex, great video! Does a Data Engineering position typically require experience? I can see many Data Analyst / Scientist job openings for new grads but fewer openings for Data Engineering.

@AlexTheAnalyst 3 года назад

There are some entry level/junior jobs, but not many. A lot require experience from what I’ve seen. Probably more so than Data Analysts.

@johnjacoby6457 3 года назад

@@AlexTheAnalyst I see more entry-level jobs titled things like "database developer." Is that another good entry point for data engineers?

@AlexTheAnalyst 3 года назад

@@johnjacoby6457 yes! That’s a great alternative!

@sonicbroom8522 3 года назад

So would a career path be Data Analyst -> Engineer -> Scientist?

@JoseReyes-sd7pr 3 года назад

Hey Alex! Awesome video! Do you know of any updates on the Google Career Certificate (Data Analyst Track)? Any info would be appreciated. =)

@extrov1 2 года назад

thanx a lot for the full description .. i'm a computer engineer at the time certification in marketing from edexcel , can i attend course in data analytics and work in that field or data engineer is more appropriate...need ur advice .. thanks and regards

@pierrepucheu 8 месяцев назад

Degrees are NOT necessary and don’t matter for these roles.

@okaforchinyerematthew1937 2 года назад

Hello Alex, i Just stumble upon your channel, thanks for the video you put up, Please what would you recommend for someone who has intermediate knowledge of SQL? thanks in anticipation for your honest reply.

@sephiroth7818 2 года назад

I'm a Data analyst, engineer, and scientist...

@sbd8825 11 месяцев назад

thank you so much

@Nathan00at78Uuiu 7 месяцев назад

i saw you covered career foundry for Data Analyst program. do you have a boot camp recommendation for becoming a data engineer?

@moidakhtar1904 Месяц назад

I am not from an engineering background, how can I become a data engineer or analyst?

@lams8415 3 года назад

Hey Alex, hope your well. I am currently an undergrad HEALTH information management student and will graduate in a couple of months. Interested in become a healthcare data analyst. I know I have to lear SQL, r studio, python and sort but do I need to know a lot of math? No very good at that. Thank you!

@andreasgamer6805 11 месяцев назад

I have some questions. Im a little confused about the difference between data scientist and data analyst. So if you can to explain me. And another question is about how easy is to change your role from data analyst to data engineer or the opposite.

@harshavardhannayaka6257 Год назад

Which can be considered as entry level? Data analyst or engineer

@marinanoshy5347 Год назад

thank you

@darshanpatel5980 6 месяцев назад

Hey alex is it possible to pivot from data analytics to data engineering?

@ar_kn Год назад

The explaination was very clear🤍

@AbcDef-ei6oc 3 года назад

Great video. Would you recommend someone with no degree in IT to have internship as data analyst? And what r the steps for getting that intern role?

@AlexTheAnalyst 3 года назад

Depends on the kind of IT experience you have, but I think if you have the right skill sets you may be able to get an entry level job instead of starting at an internship level. Either will help a lot though! To get an internship or entry level job I would try to look on LinkedIn as well as talking with recruiters.

@Mohamed-Hassanin 2 года назад

Which of them have bright future

@ALZulas 3 года назад

What the heck is a DataOps engineer??? I've seen it while looking for jobs, and I'm not sure what it is.

@Dineshsharma-ec6ys 3 года назад

I m from computer background but don't have domain knowledge like finance, economics so should I go for data engineer.?

@AlexTheAnalyst 3 года назад

If you like databases and building data pipelines I say go for it! Definitely a tech heavy position.

@Ali-bk1hr Год назад

Im starting a data engineeer course and part of the syllabus is data visualization. Do data engineers use tableau etc?

@s.h5836 2 года назад

Can you do a video on analytics engineer?

@arockiachristopher604 3 года назад

Hey alex, can a data analyst with 2 yrs experience become a data engineer?

@AlexTheAnalyst 3 года назад

Depends on what the analyst is working on and what tools they use. If you're working mostly on visualizations I would say no, but if you're working mostly on the ETL side it may be possible!

@JackLiuSuperHuskies Год назад

Alex, Khafka is misspelt

@sh0kwerm 3 года назад

Do you have any thoughts the BS in Data Analytics and Data Management from WGU ?

@LUCAS-lu1ii 2 года назад

Hi Alex, is it possible to switch career from data analyst to data engineer?

@Rajomega1 2 года назад

I have bachelors degreee in mechanical and what should i do to become either one of this position?

@bhadribhadri4779 3 года назад

I am from bcom background Can u suggest one ? i am confusing on choosing of two these jobs of data engineer or data analyst

@gunix28 3 года назад

If your end goal is Data Engineer should you start with Data Analyst role?

@reslisalam7086 7 месяцев назад

Hey same question...u found any answers for the same?

@gunix28 7 месяцев назад

@@reslisalam7086 not yet!

@manu93ize 3 года назад

U should colab with code basics

@AlexTheAnalyst 3 года назад

Haha speaking of... be on the lookout for a live stream with him on the 10th of next month 😁

@VITORB82 2 года назад

Data Engineering for me.

@TheInternetFan 3 года назад

isn't it "Kafka" ? without the H? 4:39

@willownot 3 года назад

hello, I'm starting in data engineering, is it possible to create a startup/company, so I can earn more? I see salaries from 100 to 180k as an entrepreneur it would be possible to reach 250,350k??

@zergenzerg6853 2 года назад

Jr Data Engineer underpaid compared to software engineer. Thanks, but not worth it

@alex_di_plaris Год назад

Interesting. My only remark…please speak a wee bit slower…there is no rush!😊

@antigravityfrequencies7416 3 года назад

You're up super early 🤓

@AlexTheAnalyst 3 года назад

Haha I’ve been up since 4:30am - kids always gave me up early lol

@JoanC412 2 года назад

Is data engineering really hard to do?

@cricbuzz_SG Год назад

Please share anyone data analytics syllabus.

@adoniskomplex91 3 года назад

I always thought that the engineer also cleanses the data.

@AlexTheAnalyst 3 года назад

The do - that is often part of the ETL process

@adoniskomplex91 3 года назад

@@AlexTheAnalyst So it's done by the engineer or the scientist.

@overlord7096 11 месяцев назад

Data scientist tops both of them 😂😂

@shivamsingh-mm2oc Год назад

Sir which is future proof (for upcoming 20 years )

@sonoffire4978 Год назад

Both

@jimslyrics8071 3 года назад

Give me job that don’t need coding

@AfrooBlack 3 года назад

You'll have the best success in finding a high paying IT job that requires coding. You should be saying "find me a IT job that doesn't require much coding".