Interviewing with PwC for a Senior Data Analyst Position

[@SneakerFreaker97]

Alex, thanks for being one of the most transparent and genuine people in the Analytics realm here on KZbin. I remember subscribing to you when you ad like 100 subs and now you're at 100k thanks to those qualities!

[@AlexTheAnalyst]

Wow! One of the original 100! :D Thanks for sticking with me all this way!

[@GriefHC]

Thank you for sharing your story Alex. It was really interesting to hear the entire process that you went through. I recently got accepted into a Data Analytics role and I like to attribute part of my success to the interview prep videos, SQL tutorials, and the guided projects you shared on your channel. I can't say thank you enough for your commitment to this channel, and the knowledge you are able to share to so many people like myself.

[@ahmedtarek3782]

Congratulations bro🎉 .Which courses did u find very useful for getting the job ?

[@okojieamos82]

Congratulations, i hope you get to share more about it and the position

[@douglassandoval8304]

Congrats. That is a remote job or a presencial job?

[@GriefHC]

@@ahmedtarek3782 thank you bro. The SQL courses and portfolio videos were very helpful as from a corporate stand point as SQL is one of the primary ways data is explored and retrieved.

[@GriefHC]

@@okojieamos82 thank you! I plan to do a review of my roles and responsibilities of my first 30 days once I begin in the beginning of September

[@sergioramos3437]

Congratulations on a big 4 consulting firm and a fortune 500 company both offering you a job ! That's amazing. Congratulations again on the new gig!

[@AlexTheAnalyst]

Thanks man!

[@Arecapalm24]

Cant believe YT recommended this video to me today as I just finished a multiple offer situation for a senior data analyst this week too. I had a similar choice between a senior analytics consultant role with a major financial institution but ultimately chose to take a senior analyst role with a start up. I think it’s really crazy how much the salary bands for data analyst has clearly changed in the last year or 2 with the advent of remote work. Some of the start ups are legit throwing engineer money at senior analysts just to stay competitive with these big fortune 100 companies. Happy to hear that it worked out for you and I hope my new gig will be everything that I want it to be too. Cheers on a great video! Subbed

[@christinefreberg8176]

I’m so proud of you baby! Your transparency and candor is so brave and admirable! Keep it up! ♥️

[@AlexTheAnalyst]

I didn't see the username at first and though this was some adoring fan :D Glad it was you! Thanks my love!

[@youvegotmail9385]

@@AlexTheAnalyst Couple's goals! 👏

[@lauragonzalez5584]

I really love how honest and real you are with your experience. It really helps us all to consider this type of careers and also to preapare ourselves!

[@AlexTheAnalyst]

Glad to hear that - I'll always try to be as transparent as I can :)

[@stuart313]

Started watching these videos 1 year ago and since then I've gone HR admin to now getting an HR Data and System Analyst Lead, I honestly can't thank you enough for these videos, Thanks Alex :)

[@carlosdavila5517]

Hey!, greetings from Colombia, im a DA too for a big 4, but is not a direct contract, your videos inspire me to keep going Thanks a lot!

[@DaveyBooBoo]

Wow, bold move, putting the people (YT) before the position. Much love from the YT community, your content has helped me out a lot as I continue to grow as a data analyst.

[@AlexTheAnalyst]

Hey I know my priorities - in the end it wasn't a determining factor which was good - just found a better fit.

[@exit17th]

massive congrats to you Alex !! thank you for inspring me as well as other viewers. keep on the great work !

[@gabrielbulosan4928]

Congrats! Great and insightful content as usual and I'm sure we're all more than grateful that you stood your ground with this KZbin channel. Your videos help me on my self-teaching data analytics journey immensely.

[@jihoonwoo4099]

Thank you for sharing your valuable experience, Alex. It is really interesting to hear your job hunting story as I've been recently looking for new position as well . Congratulation on your new role.

[@AlexTheAnalyst]

Thank you!

[@XpatJohn]

Congratulations on the new managerial position! I just started at one of the big 4 about a month ago. My interview process was pretty much identical, though I am in a different tech related field. One of the reasons why they are SO into domain knowledge rather than technical knowledge is that, to be honest, there are hordes of people who can do the technical part, but it is more difficult to find someone who can sit in front of a HUGE client and really dig out all of the details of the project from them. Then that same person needs to relay that information to the developers so they can do the coding work. Consultants, at the big 4 level, are more advisors and SMEs (Subject Matter Experts) than coders. If anyone has any questions about what it is like to be a consultant in the big 4, I would be happy to share my experiences.

[@mish9523]

Hi John, do you know if pwc does consulting in the f&b industry? Or hire data analysts in that field?

[@XpatJohn]

@@mish9523 Hi Michelle, I am sure that they do. PWC and the rest of the big 4 are into just about every industry. I would recommend taking a look at the careers section on their website (Don't go through a recruiter if you don't need to). Just apply directly if you see a job that you are interested in. If for some reason they think you might be a better fit in another area, they will let you know. That is what happened with me. I applied for one position, but half way through the interview process, they said that I would be a better fit for another discipline and got me in touch with the right people. All the big 4 are hiring like crazy right now. So it is the perfect time to apply if you are at all interested in working in the consulting field. But be warned, the consulting field is not for everyone.

[@damondupre5350]

Very interesting to hear about your experience. Thanks for sharing this, Alex!

[@ikcijci]

Let´s gooooo. My dude over here about to spill the tea.

[@oludipe737]

Alex is such an honest guy, most people might not share some of this private information. Thank you Alex for all you do..

[@nwaebonyijoshua7651]

Congratulations, Alex. I appreciate your down-to-earth approach. Your disposition to your KZbin channel issue is also very commendable. I hope you are able to keep it up. All the best on your new role.

[@GamalJesus]

In my experience, best way to get into a big 4 company is through employee referral. They get preference on the "interest" scale. But it's not a 100%.

[@goldengriffon]

Very interesting about the primary focus being on your industry knowledge. I guess that truly is more rare, and most firms can assume that any reasonably bright person can be taught or learn the data analysis stuff.

[@malcorub]

Thank you for choosing your KZbin family over a new job.

[@AlexTheAnalyst]

KZbin > CEO of Amazon

[@malcorub]

@@AlexTheAnalyst Rewatching this after getting my new position as "Senior Health Care Economics Consultant" in October and getting a 25% raise. Wow! So much of this resonates with me now watching this the a second time! Right down to the HR recruiter asking question I could tell they knew nothing about. hahaha. Alex, you inspire me as I am sure you do many others. God bless you and your family bro, nothing but good wishes for you and yours.

[@thuhuongdoi]

Congratulation on your new role. You have inspired me a lot, Alex. I have learned through your helpful contents and hopefully I can get something in the future. Thanks thanks thanks a lot!!!

[@subhiyousef7240]

Good luck nice to have you with us alex

[@emmanuelifediora5282]

That's great more wins to you my mentor

[@chrism3790]

120k a year is pretty low for a *_senior_* consultant in a technical role, especially for a really large consulting firm like PwC. Consulting is a notoriously intense line of work. Despite what they told you in the interview, you always go into those jobs knowing you're going to be working long hours. They know that and they compensate you accordingly. They retain you with money, not by making you happy. And you end up having to sacrifice plenty of things if you want to keep that salary. The fact that you don't know this makes me feel you would have burnt out quickly because of misaligned expectations. There just aren't enough hours in a week to run a youtube channel, spend time with your family, sleep _and_ have a consulting job.

[@AlexTheAnalyst]

I knew this to an extent. I have never worked at one of these companies, but I know many who do. I definitely knew it would be more work, but I wasn’t/am not certain since I decided to go another direction.

[@valerianmp]

How big is the overtime allowance, though?

[@youvegotmail9385]

Given Alex's knowledge, he should be at $200k+ full package. Working at a couple of startups, I know how much those folks make.

[@theactuarialdatascientist]

I agree that just stonewalling a recruiter on salary can result in wastes of time, however, I still don't think you should give a range because you could be low balling yourself. If a recruiter is pushing for a number, I'd ask the recruiter what the salary range is for the position and will just say yes or no if that range is worth moving forward (without them knowing if you are jumping with joy or they need to hit the top of the range to get you :) but this way you still get the desired result of both of you knowing you aren't wasting anyone's time. Great content as always, thanks Alex, and looking forward to hearing your perspective on the management role!

[@СаятОразов-ф7у]

Congratulations Alex! Love your channel! Hope to find a Data Analytics job soon enough)

[@beintentional982]

Great thanks. I am from a biological background, I have started the Google Data certificate Hope I'll be successful like you

[@emmanuelowusu9602]

Hello Alex. I decided to quit a Data Science Master's Degree that I enrolled on online after I found out about all the other resources like Khan Academy and Udemy through you. It sounds like knowing the skill is more important than having an expensive Master's Degree. I'm pretty sure i did the right thing. Congratulations to you Sir.

[@AlexTheAnalyst]

Good luck!

[@tessmuiruri7418]

Me too!!

[@jacksonroper22]

Thanks for sharing your valuable insights! Best of luck in your new gig

[@ldsudduthhanover]

Congratulations on scoring the interview and in your decision to move in a more project management oriented path. My take on Travel-having been in a role that was 3 weeks every month, travel from M-Thursday and back in the office on Friday. It's not all it is cracked up to be. It puts a strain on families and relationships (it was single-handedly the reason my first wife and I divorced). Most of all, it's simply exhausting. That's my take…YMMV.

[@wilsonman8661]

Hey Alex, thanks for sharing your interview experience. Congrats on the manager position! :D

[@AlexTheAnalyst]

Thanks man!

[@fmym9923]

it may be out of data analyst context but i really like how your videos are very calming. maybe u can make a video on how you record your videos

[@AlexTheAnalyst]

I appreciate it! I probably won't since it's not really the type of content I create

[@lavadman1]

I 100% agree. I just got a consultant/analyst role and they were getting applicants left and right with plenty of SQL experience, but I got the position because they are an ERP/CRM implementation and support company which I have obtained extensive knowledge of over my previous roles.

[@ondrejgazo5835]

Congratulations! Just applied for Data Analyst position at PwC.

[@ciscokid4266]

Hey Alex love your content. Also came from industry as a SA at PWC. Seems mike Big4 are looking for SME over core consulting candidates. Was a huge learning curve for me but fun picking things up

[@shatuers4823]

I found your yt channel week ago, and I already like you. Good luck with your Manager position :)

[@shatuers4823]

btw if you are reading this, I forgot it was almost year ago xd Do you like being a manager?

[@Himothy]

Very Informative Video, Thanks For Sharing Your Story Alex!

[@sultanfolawiyo355]

Congratulations Alex 🎉

[@VishwamKulshrestha]

Congratulations mann, I am pursuing some courses for the same. Your videos actually help alot, thanks for the videos ❤️🔥

[@AlexTheAnalyst]

So glad to hear that!

[@Romial34]

As a recruiter, the main takeaway that I already knew is that "Time kills all deals". In recruiting, you have to move fast because if they are a good candidate, you're not the only company that would want them.

[@vincentvalentine9417]

Interesting. I'm astonished you had next to no technical questions though.

[@azadehabou]

In the UK for £50K , Senior data analyst, I had to sit for one hour data analysis exam which I could not finish it. Last year, I went to 3 interviews.I have masters degree in Computer Engineering and just recently passed Azure data engineer associate exam but found it really difficult to find a better job in the UK as a non native english speaker. I have an interview next week and it has SQl exam . They ask so many competency questions.

[@fmym9923]

great video as usual, alex

[@alirezaa6530]

Great vid. Keep up mate.

[@trustedsource1273]

About 15 years ago, we received an RFP (Request for Proposal) from a major company - the day before it was due! We cranked out a response and sent it in before the deadline. We were then informed that we were one of two finalist companies. My company was small but comprised of well known leaders in the field; a boutique, specialist firm. We were invited for an interview along with the remaining competitor who turned out to be PwC. We walked in and they were immediately "Oh, it's you!" They were going to ask interview questions - using my book as the reference! They saw the other person I brought with me and they knew him well too; I planned it that way. We got the deal. Later, for marketing research, I asked the client where PwC was judged to be better than us. They said that PwC had "really nice brochures..."

[@HakamAbuShanabb]

Congratulations dear Alex

[@MrJbrowwn]

Thanks for this video Alex

[@s7ventude]

Great video and insight 👍🏾

[@alexuvere]

Thanks for sharing your story. Great to hear your feedback.

[@yoyo-ue5pf]

I had a similar experience as a data consultant for deloitte

[@vectoralphaSec]

whats the difference between an interview for a senior data analyst versus an entry level/ junior data analyst interview?

[@rudroroy1054]

If possible would you make a video on terminologies associated with the pharma industry and how data modelling is done by analysts for data analysis?

[@sakshisingh-nt8re]

Hey Alex, I wanna be a data analyst very soon, tell me if i learn Sql , tableau , power bi , advenced excel and dbm these skills, am i able to get a job in the field of data analyst as a fresher b/c currently i'm learning these skills

[@AlexTheAnalyst]

Those are great skills to learn! You should check out my video called Data Analyst Skills Path

[@sakshisingh-nt8re]

@@AlexTheAnalyst sure Alex 🙏 thankyou

[@dean8147]

Id personally drop half of them and go straight into Python. SQL, sure, the rest? I wouldn't. But then again, I'm in the Data Science / ML field.

[@sakshisingh-nt8re]

@@dean8147 actually i wanna be a data analyst nd seriously i'm very confused whether should i go for certification courses or should i watch youtube videos and i found 2 or 3 youtube channels very helpful i.e. Programming with mosh nd freecodecamp I mean will i get job after self learning nd certification courses?

[@dean8147]

@@sakshisingh-nt8re certification will certainly help without the academic background. Learning online using the sources that are available is of course ideal. But without building a portfolio, you’ll certainly need fortification. Learn online with free resources = build a kaggle page to demonstrate your abilities with your own projects and hope you can compete with Master degree candidates with experience which is the reality of the situation or, Use online courses for certification and it will somewhat help you compete. Real honesty- online certification, + kaggle + online learning. I’m just finished my masters in DS/ML and have 2 years Analyst experience .. it’s certainly not easy to land a job relevant to my field of interest. I only just landed one recently and i believe I’m underpaid. But machine learning is very competitive so I’ll take it

[@AndyDoNZ]

You're awesome!

[@aidanoconnor594]

Thank you Alex, for this valuable insight into the interview process for PwC. Especially since it was for a senior position. There doesn't seem to be much info on the net about how these types of interviews go. Keep up the good work! I would also like to apologize for my conspiracy theorist-esque comment on your "I am no longer a data analyst" video. I guess I was just scared of possibly loosing access to high quality free content like this some day!

[@AlexTheAnalyst]

Haha no worries at all - I don't plan on stopping any time soon :)

[@Raphaelogwu]

Congratulations Alex. You’re literally hot cakes now

[@anupamavarshney3448]

Hi thanks for giving information about data analytics course.I am thinking to do this course from google and I don’t have any experience and I am also 40 years😊

[@anupamavarshney3448]

So my question is that after doing this course what is the chances to get entry level job without experience and where I can do internship to gain experience? Thanks

[@konstantinradu4399]

In my country I’d have a 25.000 yearly as business analyst/data analyst but low living costs. I’m based in Italy

[@demr5251]

I'm italian too, buona fortuna!

[@datanerd6935]

Porca miseria si guadagna così basso li?

[@konstantinradu4399]

Guarda su google io ho trovato questo da noi Ma vuoi mettere che non abbiamo prestiti studenteschi o la sanità come li da loro? Comunque su Glassdoor 25.900 su altri siti dicono 24.000-27.000 ma contate che parlo di junior entry level comunque netti

[@bangerasiddharth]

Great insights. Could you suggest few good reads regarding the pharma domain. I have worked in the same domain, but I want to learn more about the same. Any video/links about pharma domain?

[@GeorgeRodriguez72]

Thanks for the deep dive. Very helpful. But why do I have a sense you were more like Ben Affleck saying "Retainnnerrr" during the Good Will Hunting interview scene???

[@titusmazima4187]

Alex,thank you very much. I'm starting out in Data Analytics and I was kindly requesting if you can recommend a book on the subject that would help me

[@srdjanix]

Did you have to do a case study while one of the interviews ? Thanks

[@The_Bri_Cli]

What was your answer to why you took the opposite road? Going corporate and then going into consulting?

[@douglassandoval8304]

Im new in this data analyst jobs and im just starting to learn withe one of the courses you recommend. But I need to know if your advices for getting jobs applys for remote jobs or primarly to get full time jobs in the USA?

[@merttutuncu9271]

Hey Alex, what does a Catalog Quality Specialist(at Amazon) do? Do you think it would be a good starting point as a data-analyst wanna-be with no experience? I've been asked if I would be interested in that job just now. Hoping for an answer from you!

[@brothermalcolm]

This is gonna be interesting

[@zhejianzhang1150]

Hi Alex, I am wondering which is the best course (and which Uni) to study to become a Data Analyst ?

[@naazishshahab1225]

Got into KPMG this week

[@AlexTheAnalyst]

Congrats!

[@nwaebonyijoshua7651]

Congratulations @Naazish

[@JD_2]

Thanks Alex

[@toshifchhipa8938]

Is it necessary to learn data structures and Algorithms for a aspiring data analyst?

[@AlexTheAnalyst]

No not really - that's usually software engineers or data scientists that may use it

[@toshifchhipa8938]

@@AlexTheAnalyst Thank you so much for clarification

[@muhammadibtisaam2115]

Tableau is best or power bi for data analyst?

[@douglassandoval8304]

Do you think is possible to find a remote job as a data analyst if I am in another country (not USA)?

[@okojieamos82]

thank you Alex for sharing, i am currently taking the Google certification you talked about in 1 of the previous video, i am hoping after this, i should be ready for a data analyst entry job interview.

[@mubaraq8853]

how has it been going for so far Amos!

[@tanushreepareek8208]

Hi Alex, Which pharma company do you work for? I have watched your whole video, it was very interesting.

[@AlexTheAnalyst]

I used to work for a company called AmerisourceBergen - quit my job back in December of 2022 to start my own consulting company though.

[@tanushreepareek8208]

@@AlexTheAnalyst thanks Alex for replying.

[@akshaydabholkar2606]

hey alex even i m trying to get the job in data analyst is that possible for fresher can u just guide me

[@ionescumada]

What camera you use for your videos Alex?

[@ruddvann]

Hi Alex, - silly question - age = 40yrs with no experience in coding / data science (the person has been working on the oil patch for more than a decade) ...is it too late to train to be data scientist / ML eng? Most of the jobs require a few yrs experience which in this case (data science) is 0. Whats your take on it? Should the person try something else?

[@ukau706]

no age is old. I am taking a SQL course at the moment and some of my classmates are in their 50's. you could learn in less than a year

[@shehrozebahadar3097]

Alex i want to ask one question: Is google data analytics certificate give me financial analytic job ?

[@fun2badult]

no

[@bendoverDN]

@@fun2badult honestly, if you have a stem background from university, then companies are willing to take a chance on you with just the google cert. that was definitely the case for me.

[@kikalaloka]

domain knowledge?

[@Kitiwake]

Isn't speaking in depth about your previous data work in your previous company a beach is data protection law? Absolutely.

[@method341]

So, basically PwC is not worth it unless you're a grad and you want to work 60+ hrs a week?

[@AlexTheAnalyst]

I wouldn’t know - didn’t work for them lol but from people who I know who did… that sounds pretty accurate

[@kotisenagala7214]

Can I have your Resume?

[@adeniyiawokoya6360]

Hi Alex. My name is Sodeeq, I am an upcoming data analyst, learnt a major of the tools needed, excel, R, SQL, Tableau (not completely) but despite all the knowledge I've acquired, I still can't bring myself to do any project. I'd be very glad if you could provide any guidance for me in the is journey, tried to get your mail, but I couldn't, I'd be extremely glad if you could reach back to me. Thank you.

[@doit997]

Why there're too many interviews?

[@AlexTheAnalyst]

Big companies tend to overdo it with the interviews to be honest lol

[@doit997]

@@AlexTheAnalyst I appreciate the honest reply, Thank you,

[@orlandocastellanos9263]

New subscriber, one question as a data scientist can I work in machine learning and AI ?

[@Nonchalant2023]

the hiring manager was right on asking you why you were going backwards to consulting...really long hours and almost no personal time is the target they look for, young unskilled people (right out of college) so they can exploit them at their fullest. you were in the wrong place trying too hard to get into a big4

[@barryrims9098]

Alex read your emails! I sent you a mentorship request!

[@AlexTheAnalyst]

I'll get to it soon I'm sure :)

[@zaifonnn5893]

Crazy 105-150 k per year sounds crazy. While football player could get that amount in a week. I know it is different thing. But still. There is so much unbalance resources spread in the world. The person back door that make improvement to this world to become better really get paid by a peanut

[@tarikcavalcanti4867]

105 to 120k holy crap

[@onlyfoolriding8223]

Damn, 120 to be in that work environment is not worth it. Seems low with those skills.

[@stuckdata3484]

First comment! :D

[@AlexTheAnalyst]

:D

[@youvegotmail9385]

Two months, talk about respecting your time.

[@AnyFactor]

Aren't we going to talk about the elephant in the room? Where is that mustache?

[@AlexTheAnalyst]

Trimmed it on the livestream the other night when I hit 100k haha

[@Mehendi_boutique96]

Welcome to PwC 😊

[@AlexTheAnalyst]

Well I didn't end up taking the position haha I accepted a Manager position at my current company

[@Mehendi_boutique96]

@@AlexTheAnalyst 😂I have misunderstood 😂😂. Anyway Congratulations 😊😊.Being manager is a good choice 🥳

[@tahsinserkanyaman3459]

You didnt solve any case problems? This is problematic. I think your knowledge base doesn't deserve a job in PWC.

[@mrgenetics4063]

Unsubbed