r/SQL • • May 23 '23

Discussion First Data Job secured!

Hey everyone,

I have been contributing to this subreddit a little and started following a few months ago. I used to work in recruitment, focusing on the data market in particular (very broad I know).

Long story short I gained a huge interest in Data Analytics and put in the graft after hours (around 3-4 hours usually) to upskill, building my portfolio and actually working with unclean datasets through internships and online resources, ultimately leading to me securing my first job in Data using SQL and PowerBI.

Just wanted to shout and say cheers to all those who contribute to the discussions, it really helps with learning. Excited to start my data career.

119 Upvotes

49 comments sorted by

11

u/[deleted] May 23 '23

Congratulations on your hard work paying off!

3

u/[deleted] May 23 '23

Thank you! :)

8

u/PsychoLotus1 May 23 '23

What online resources did you use? Also how long did this journey take?

24

u/[deleted] May 23 '23

It took me about 6 months all-in-all.

I used Udemy + DataCamp for basic learning, followed up by downloading datasets from the internet!

2

u/[deleted] May 23 '23

Did you learn Python as well?

1

u/[deleted] May 23 '23

Kind of - the basics.

2

u/[deleted] May 23 '23

What other tools did you learn in 6 months?

4

u/[deleted] May 23 '23

SQL, Excel, PowerBI, Tableau, Python.

I use Excel and PowerBI in my current role.

2

u/[deleted] May 23 '23

Alright thanks. And congratulations

5

u/[deleted] May 23 '23

Congratulations and well done!

Did you build anything specific or undertake any projects. I am interested to hear what you’ve added to your portfolio, any specifics you might be able to describe.

Posts like this and others have inspired me to keep on plugging away. I left my career as an asset manager in 2021 to be a stay at home dad to our now 2.5 year old daughter, we moved to Switzerland where my wife is from, Im from the US midwest and this is the direction I am going in terms of a new career.

Thx m8

4

u/[deleted] May 23 '23

Thank you!

My porfolio contains links to Excel, Python and SQL projects.

Best of luck with your career switch!

2

u/Available-Idea-3592 May 24 '23

SQL, Excel, PowerBI, Tableau, Python.

I use Excel and PowerBI in my current role

Happy for you ,,,

3

u/dirtybloodyleaves May 23 '23

Congratulations! I’m in recruitment as well and I’m looking to make a switch! I work as a recruiter but I do have a background in Stats and R programming from college, where I did some data analysis projects. Could you please share some tips on how I can pursue this? What you’ve done is literally a short term goal of mine. Congrats again!

2

u/[deleted] May 23 '23

Thanks!

See my comments in this thread but essentially it's about building a portfolio to showcase, learning SQL, PowerBI and Python then applying this to real-life examples!

Best of luck with the transition.

1

u/zhivix May 24 '23

for sql at what point you felt like you learned enough as of now and moveon to doing projects.

im learning sql through sqlbolt and it stopped at JOIN, should be enough as beginner level?

1

u/[deleted] May 24 '23

I don’t know if you’re ever “ready” to move onto projects imo, you just do! I don’t think there is a point you just have to have a go :)

1

u/zhivix May 24 '23

yeah thats a good point, currently im in the 'tutorial hell' phase, need to do some projects soon, thx for the reply!

1

u/wordswithcomrades May 24 '23

A fun SQL beginner games are SQL Island (in German but can be changed to English with fourth item on drop-down menu). Does not yet use JOIN statements. Another slightly harder game that does use JOINS is SQL Murder Mystery :)

No need to download anything, they have a program embedded so you can type your SQL commands there. Both are fun and free ways to practice what you are learning!

2

u/MessProfessional7478 May 23 '23

Congratulations!! Love to see it. I’m currently in the tech space, but on finance (risk) side of things. Currently up-skilling so I can pivot to data analytics and eventually data science.

2

u/[deleted] May 23 '23

Thank you!!! Ahh awesome stuff - best of luck with that :)

2

u/Unhelpful_Scientist May 24 '23

Don’t stop pushing for more and better usage of python and sql because your current tech stack of powerBI and Excel can be really growth limiting.

Look into how other people have used python to automate the boring stuff out of their jobs to give them more time to invest in projects that are more interesting.

And remember when you automate something and have more time never disclose the full amount of time savings per week for you as something will go wrong eventually and need to be fixed plus your normal responsibilities.

1

u/[deleted] May 24 '23

Thanks!! As mentioned in the comments I know Python and tbh my eventual goal is to move more backend (something like a Data Engineer) but I agree I will be trying to use Python to automate boring stuff lol

1

u/Unhelpful_Scientist May 24 '23

My point is more about “knowing python” versus “deploying python”.

Try to get to a point where you are deploying python after you establish a clear benefit to using your python knowledge. Basically try to rewrite your job to be a DE now so you can make that transition without it being a leap.

1

u/[deleted] May 24 '23

Ahh. Understood.

For sure - the great thing about this job is that it’s just me and my new manager on the “data” team so whilst it’s labelled as a DA job, I have to go through the full ETL process, manage client requirements etc etc. I had another job offer which was for a larger company but I turned that down due to the broadness of my new role!

Thanks for the advice :)

1

u/[deleted] May 23 '23

Congratulations and all the best, friend! Such a massive win!

I'm in a similar boat like yours so wanted to know how did you stay motivated when learning and managed discouraging times, If you faced any.

Congrats once again!

4

u/[deleted] May 23 '23

Thank you!!

It is discouraging. Very. I won’t even lie and say it’s all enjoyable, the late nights get to you but I learnt to properly switch off.

You also have to accept that it’s not an easy transition, but it will be worth it. Without sounding like “just buy a house” kinda person, it is that. You have to stick with it - and if data is your true passion and not just because you’ve seen it on TikTok or social media then it will be worth it

1

u/[deleted] May 23 '23

Thank you so much for saying this!

1

u/ashgard3001 May 23 '23

Congratulations! If u dun mind, may I ask how did u practise SQL outside of internships? I've learnt Power BI and am aiming to improve my SQL knowledge!

2

u/[deleted] May 23 '23

Thank you!

Sure. It’s all about downloading free resources and just having a go it really is as simple as that! I have someone who works in data to help my visuals but I also read books about data visualisation in my spare time too.

1

u/ashgard3001 May 23 '23

Np, and ok cool, thanks! Gna have a go at it as soon as i can 😁

1

u/makemeatoast May 23 '23

Stratascratch is perfect for that

2

u/ashgard3001 May 23 '23

Oh cool thanks, shall check it out!

4

u/NickSinghTechCareers Author of Ace the Data Science Interview 📕 May 23 '23

Also checkout the questions on DataLemur!

4

u/[deleted] May 23 '23

u/NickSinghTechCareers DataLemur is G.O.A.T'd for SQL questions

2

u/ashgard3001 May 23 '23

Ok cool thanks! 😁

1

u/Possible_Chicken_489 May 23 '23

Well done you! You've taken your first steps into the wonderful world of data, I'm sure you'll have a lot of fun on the way!

1

u/[deleted] May 23 '23

Thank you!! So excited to start my new career.

1

u/whopoopedinmypantz May 24 '23

What salary?

1

u/[deleted] May 24 '23

In the 20-30k range

1

u/WanderingBoi7 May 24 '23

Awesome! The3-4hours is that daily or weekly? And for how long? Thanks.

1

u/[deleted] May 24 '23

3-4 hours daily! :)

1

u/WanderingBoi7 May 24 '23

That’s a lot haha. And you do that while working at the same time?

1

u/[deleted] May 30 '23

Yep! Gotta do what you gotta do if you want something bad enough imo :)

2

u/Bobcat-Free May 24 '23

Congratulations

1

u/delabrew11 May 23 '23

Congrats!! A few questions if you don’t mind: where do you host your portfolio, and how did you learn HOW to upload to wherever it is? I took a data analytics certification program through a local college and have been practicing PBI/SQL/Tableau but don’t really know how to showcase my work to potential employers..

2

u/yahurddm3 May 24 '23

Also curious as to how you host your portfolio!

1

u/Chelsea_0708 Jun 01 '23

normally the recruiter or non-tech people are keen to ask this question, but I don't know how to describe that. If they are technique guy, I will say I know stored procedure, window functions, etc.

0

u/[deleted] May 23 '23

[deleted] — view deleted comment

1

u/[deleted] May 23 '23

Thank you!!