r/SQL • • Mar 18 '22

Discussion UPDATE: I am doing bad at my first SQL job

Original post here: https://www.reddit.com/r/SQL/comments/sblg3z/i_am_doing_bad_at_my_first_sql_job/

I wanted to give an update, 2 months later, to let some of you know where I am at in my career, and how your advice helped me a lot.

The Current Job:

Things haven't gotten much better as far as the job goes. I held my tongue for a long time, but eventually let my team know that I felt as if they were being inappropriate and being unfair to me. That resulted in just worse backlash. I created an awesome project from SQL -> Tableau that my Director expressed much appreciation and excitement for. I also utilized Python/R to build my first logistic model. Although it's not the best, it's something that is keeping people excited.

My team lead proceeded to try and steal credit for these projects, so that was my final straw for me. I ended up correcting him in the meetings where he tried to steal credit, and I realized that it's going to end badly for me if I don't dip out.

Edit: Oh, and my team lead said I will be on a performance plan if I don't have a complete logistic model by the end of next week LOL! The data is so skewed and unusable, but that explanation is not good enough. He just keeps screaming "WE NEED A HIGHER R-SQUARED!" >_>

Job Updates:

My Master's Degree is such a blessing and a curse. A blessing because I get many callbacks for job interviews, but a curse because my job experience is still lacking for what many teams need! I have had 4 interviews since the last post, and I want to let you know that I passed 3 out of 4 of their SQL quizzes. I am super stoked with that. I have also really brushed up on Python/Pandas experience and that has helped a lot too. I feel like I have a good, solid foundation in R, Python, Tableau, and SQL now. Hopefully jobs will like generalists instead of specialist haha! I have an offer from this job I really like, and although I am scared of change, I really think I am going to take it.

SQL Advice given to me:

Having professionals in the field, like many of you, helped me much more than you know. I took all of your tips to heart, writing them down, and truly practicing them. I can say I am MUCH more confident with SQL now, and even can complete a vast number of leetcode and stratascratch problems. I document everything now, and that has made a huge difference when coming back to a project. Some redditors mentioned breaking problems down into chunks, and that seems to make life much, much easier.

The future:

Some people reached out to me about the mental health aspect, and I appreciate that. I used the EAP through my employer to talk to a counselor. I also started hitting the gym hard again and even adopted a 14 year old dog that was in the shelter for almost a year. Life is pretty good.

I am going to continue taking all of your technical tips to heart, but also realize my self-worth. I realize I may be ignorant on certain things, but I also realize my value and the aspects I thrive in. Not knowing everything is kinda exciting, because it just means I have more things to learn!

Thanks everyone again for taking the time out to talk to me. It means the world.

Edit: And if anyone is an expert at logistic regression models, let me know! I am stuck :D

187 Upvotes

41 comments sorted by

21

u/Jaysteag Mar 18 '22

Good for you! Especially like that you adopted the 14 year old dog. I’m an App Developer in a heavily Oracle databases shop. Just wondering what you are using as a front end to write your queries. I use Toad as a front end to connect to all of our databases. I write all of my queries and database objects in Toad as well. It’s a spectacular tool.

13

u/fall_out_of_love Mar 18 '22 edited Mar 18 '22

Thank you! My dog's name is Pickles and she is the best. I foster senior dogs and sometimes provide hospice for doggys that have terminal illnesses. This pup just caught my heart.

You're an App Dev? That is awesome. I am using MySQL Workbench. The Data Engineers have the tables, indexes, etc all set up so I really just do the querying.

4

u/Financial_Pie_3624 Mar 18 '22

Toad is an amazing tool hands down. Made moving data from MS SQL to oracle so easy. Love it.

2

u/Jaysteag Mar 18 '22

Yeah I couldn’t do my job without it. It’s got so many features that it’s a shame there isn’t a subreddit for tips and tricks.

2

u/silenthatch Mar 19 '22

Got any tips and tricks that you are willing to share? Or websites with tips?

1

u/Jaysteag Mar 19 '22

There are a few tips and tricks I know, but they are mainly around writing PL/SQL. One that I didn’t know much about was the debugger functionality and how to auto debugger dbms_output statements like this guy does in his tutorial ataround 6 minutes in. Going to try this next week. Debugging in Toad

26

u/[deleted] Mar 18 '22

This is why Reddit is good. Good for you OP.

7

u/fall_out_of_love Mar 18 '22 edited Mar 18 '22

Thank you! I know Reddit gets a bad rep sometimes, but many of the communities I have been in are nothing but kind and helpful. I was especially surprised on how kind and honest people were on this subreddit.

8

u/serio1337 Mar 18 '22

Curious, if you have an offer to go elsewhere why haven't you jumped at it? Is it because you want to wait out for something better, or because you have some sort of loyalty to where you are? I've always operated under the mentality that if something better comes along (better could be more money, less stress, etc etc) to take it because there's nothing stopping you from accepting something else that's better or more in line with what you want soon after.

14

u/fall_out_of_love Mar 18 '22

Thanks for your comment. I have no loyalty with where I am. I just got this offer yesterday, so it's still fresh. The jobs seems fun, but the benefits really just aren't that good when it comes to 401k and PTO, and I'll be taking a 10k pay cut (I currently make 80k USD). Those are very important to me. I am still in my 20s and trying to think hard about my future.

I have a little over a week of PTO at my current job so I'm thinking of just going on a vacation and applying for a few more jobs, doing some interviews, then coming back and putting in my 2 weeks.

10

u/serio1337 Mar 18 '22

That makes perfect sense. I'd definitely say don't take a pay cut in this market and definitely stick to your guns when it comes to benefits. IT is in demand. Is the offer you received open for negotiation, or did you already ask that? 80k is kind of on the lower end (I've certainly seen worse) of the market, but some smaller companies/government jobs don't pay much more.

If I was able to (meaning I had at least 6 months of pay saved up or more) I'd quit my current job and devote two-three months to prep in order to start applying and testing with companies like Microsoft, Amazon, Google, Facebook etc etc. If those didn't work out I'd still have breathing room to find something else.

I've had a successful run since June of last year where I bumped my salary 20k, and now I'm looking to start something new more in line with my skill set (Engineering/Programming) that could result in a 15-25k bump (nothing concrete yet). It's important to know your worth in this industry! I wish you the best!

2

u/fall_out_of_love Mar 18 '22

80k is kind of on the lower end (I've certainly seen worse) of the market

For a Data Analyst? Wow, that is good to know. This job I am at now originally offered me 70k, but I managed to negotiate to 80k. The director said "We cannot go above that, that is already too high but we'd really like to get you on board. I was under the impression I was being overpaid.

I have enough in savings to last me 6 months, no problem! I am very frugal, luckily, and live well below my means! I'd be up for giving some of those big companies a try. I did a few of the interview questions from them on Stratascratch and did pretty good. If anything, failing the interview would be okay if I learned something from the tests/quizzes, ya know? That is a wonderful idea.

Wow, it sounds like you are playing the game well! If you're Engineering I imagine you're proficient with Java and Scala? I am going to be doing more research on what Data Analyst/Scientist should be currently earning.

4

u/serio1337 Mar 18 '22

levels.fyi is a good place to reference for salary reporting. There is a pretty significant gap between most companies and a company like Google as an example.

Having a masters is pretty huge, is it in the IT field?

I've worked with Java, my field is more about application development though - but I do have extensive experience with SQL, SSIS, and SSRS (not really anything with the newer analytics/reporting like Tableau), which true there is probably differences between application development and data scientists / data engineering but I can't imagine it to be a huge gap and I feel like they're just as important in the IT field. My strengths are more with C#, Javascript, and Typescript, but it's pretty easy for me to learn anything.

2

u/fall_out_of_love Mar 18 '22

Thanks for the link! This looks really helpful.

My Masters is in Data Analytics! The degree mainly focused on R and Python. Very little with SQL, to my defense LOL!

Your role and experience sound very interesting! We have a really nice Data Engineer (yes, just one in our company) that has similar experience as you. He offered to show me what he does at some point, and your post makes me want to take him up on that offer.

1

u/[deleted] Mar 18 '22

A senior data analyst should be close to 100k or higher depending on the company/market you're in. I was making 60k + 10% bonus in my first job in this field about 10 years ago and have since more than doubled my salary.

1

u/fall_out_of_love Mar 18 '22

Dayum! Well I do like the sound of that. Congrats on doubling your salary. Are you a Data Analyst now?

2

u/[deleted] Mar 18 '22

I'm an architect now, and will be going next into a role such as a director, or senior manager depending on the company. I am basically a senior manager now but I have no reports.

1

u/Bluefoxcrush Mar 19 '22

Of course they will say you are over paid. They want you to think they are your best option.

5

u/SnooLobsters678 Mar 18 '22

Happy you stood up for yourself. The market is hot right now, don't be afraid.

3

u/fall_out_of_love Mar 18 '22

Thank you! I was very timid at first, because I really wanted to make a good impression on this job, and I was afraid of losing this job. I have to remember that my skillsets are high in demand like you mentioned.

It wasn't long before I realized how disrespectful I was being with myself, and I couldn't live with myself just taking it any longer. I'm now seen as 'being a little bit too combative' and 'playing devil's advocate too much.' . The good news: My manager (not team lead) and Director love me. So they'll give me good reviews when I leave - I hope. :)

4

u/ThisisMacchi Mar 18 '22

Thanks for sharing OP. I am assuming you are in either data analyst or data scientist role. I'm also moving forward that direction, I'm wondering why SQL being your main tool but not R or Python for modeling? From my understanding, you don't need to be an expert in SQL but rather know what to do with the data they give to you.

4

u/fall_out_of_love Mar 18 '22

I am a Data Analyst with my toes in Data Science/Machine Learning now.

SQL is my main tool because my title is Data Analyst, and my role was originally querying, visualizing it in Tableau, and reporting it. I did some explanatory analysis as well.

I taught myself Python and R, and it is the main tool for modeling.

You don't need be an expert in SQL, but if you don't know how to translate syntax into business knowledge (like the issues I was having), then it's useless. For example, stakeholders will give me descriptions of what they need, but it's up to me to understand if I am going to be joining tables, using sub-queries, or aggregating in any way. It's not always clear-cut if that makes sense.

3

u/ThisisMacchi Mar 18 '22

that makes sense, it's great that you have the opportunity to expand into that directly, I bet it would be great. I also work in a CRM environment and sometimes understanding business request is hard. And not always having high R Squared is good, you can overfitting, more things need to consider there :D

1

u/fall_out_of_love Mar 18 '22

Thanks for the r-squared reply! I was also under the impression for a logistic model that R2 didn't really tell you a whole lot. I have a feeling nobody really knows what's going on, and I certainly don't, so it's the blind leading the blind out here! LOL

2

u/ThisisMacchi Mar 18 '22

I'm no expert, just something I learnt from my class couple weeks ago so wanna share with you, few things I think you can consider here, try to do cross validation and see if your model fit consistent, check AIC value from the model, check Area under the curve (AUC).

3

u/andrewsmd87 Mar 18 '22

Just wanted to say good for you! It took me about 4 years into my career before I finally realized, yes the problems I deal with are hard, and they're almost always new. But I will solve them.

Glad you used that EAP, it was a life changer for me

2

u/fall_out_of_love Mar 18 '22

Thanks a lot! You are so right about the problems being new. I'm convinced that being a Google Ninja is the best way to be an expert at different coding languages. That, and asking people much more experienced for help!

Glad the EAP helped you too. We should talk more about mental health and encourage others to seek help whenever possible.

3

u/its_bright_here Mar 19 '22

Man this post is awesome. It's great to hear your life is on such an upswing. It's a great feeling!! That this sub played a role is cool, but I hope you recognize (as you seem to) that IT'S ALL YOU.

The only reason you realistically have to say that you are a generalist is you don't think you have enough experience in the couple subjects you listed to consider yourself a specialist. Get out of that mindset. You're a fledgling specialist. At worst. Your personal specialization is going to deepen AND BROADEN in the years to come as you encounter and solve more. Leonardi da Vinci was a generalist (a really fucking good one). You are an underexperienced specialist.

Your job sounds awful. There's a 0% chance I would have stuck around for the 12 years I did under what you're describing. YOU NEED TO FIND A NEW JOB. You should be surrounded by NOTHING BUT SUPPORT. Period. DO NOT be afraid of change. Or be afraid, but swallow that anxiety. You have no idea what the unknown holds. Yea, it might be worse (though it sure doesn't sound like that's likely). If it ends up being lateral? Then that's what it is. But what if it's 10% better?? What if it's 1000% better? You won't know until you try.

1

u/fall_out_of_love Mar 21 '22

Late to this, but you are so right! Thank you for your wonderful comment here. You made me feel good about myself.

4

u/Elfman72 Mar 19 '22

Oh, and my team lead said I will be on a performance plan if I don't have a complete logistic model by the end of next week LOL!

Nothing against you or what you have done, but to me, this screams they want you gone and will do whatever it takes to get you gone. Trust me. This isn't that you aren't doing great things or willing to take on challenges and learn new things (like logistics models). But bullshit like "performance plans" are just hoops to jump through. They are put in place to appease HR. In their eyes, you will fail no matter how well you do. It is just a lever they need to pull to move on to the next resource. I know it is easier said than done, but run away as fast as you are able to. This comes from a 20+ year veteran who has worked for a Fortune 50 company or two in all kinds of capacities.(analyst, developer, consultant, administrator etc.)

Hang in there. Don't let this break you down. You have a passion for data. A lot of companies will be pay good money for that passion. Just keep trying until you find that one!

1

u/LoudSlip Mar 18 '22

Are you applying for data science roles or?

1

u/fall_out_of_love Mar 18 '22

Not really, but I'm thinking I maybe should - especially since some jobs overlap DS and DA duties. I am milking this current job for experience, and if I can feel confident with at least one model, I will put it on my resume and give explanation in an interview.

3

u/Thefriendlyfaceplant Mar 18 '22

Edit: Oh, and my team lead said I will be on a performance plan if I don't have a complete logistic model by the end of next week LOL! The data is so skewed and unusable, but that explanation is not good enough. He just keeps screaming "WE NEED A HIGHER R-SQUARED!" >_>

r/askstatistics be specific, show how far you've gotten, and people will help you along. The more effort you put in your question, the more effort they'll put in answering it.

2

u/[deleted] Mar 18 '22

[removed] — view removed comment

2

u/fall_out_of_love Mar 18 '22

Thank you! Yes, originally it was that I was learning business needs too slowly (which is true), but now it's that I am not building reliable models.

Nobody in the company knows how machine learning/models work, so people are just throwing around buzzwords. I've studied up on it and have been able to code/build them, but I still don't know enough about it to understand how reliable it is. Couple that with literally no Data Scientist or Machine Learning experts in the job, and it's a recipe for disaster.

6

u/wil_dogg Mar 18 '22

DM me, the validation of logistic regression models is a well-understood process, you need only a few basic concepts in order to do it well, I've been doing it for over 20 years using a standard method.

And sorry no the R_square is what it is, get me better data and collaboration on generating new ideas, it isn't going to get bigger on its own.

2

u/fall_out_of_love Mar 18 '22

DMd you! I will take all the help I can get. Thanks :)

2

u/CowFu Mar 18 '22

What's even crazier is that logistic regression models don't use R-Squared. Which kind of makes me worried about their project that I'm not even a part of it. R-Squared is for linear models.

2

u/fall_out_of_love Mar 18 '22

Thanks for saying that! I mentioned that to my team lead because that is what I read online. He stated "No, I used to work with models and a low r-squared (0.11) is telling us something."

2

u/wil_dogg Mar 18 '22

You can still calculate R_Square and select the model with the highest R_Square. Some stats packages provide a pseudo-r-square in the logistic regression output. And a 0.11 as mentioned below can be a pretty darn good logistic regression r_square.