Yeah that's fair -- maybe just focusing on becoming an expert in data and ML engineering in the long-run is a more prudent career choice than totally dropping those for another corner of engineering. There's some wisdom here.
Taking that much time off of any job is pretty hard to do!
The real goal of a bootcamp though (besides networking) is adding a project to your portfolio. You can then show off this project to hiring managers to demonstrate your competence.
You don't need to do a full-time bootcamp to make this happen! I just checked and Flatiron school and Hack Reactor both have online part-time full-stack bootcamps. Also, while not as big of an investment, online platforms like Codecademy have career paths with a capstone project you can complete and add to your portfolio.
So, overall there are a variety of pathways to do this. Totally fair to point out though a bootcamp of some kind is a nice option in the off-chance it's a possibility.
You're right, Google has been very supportive -- very thankful for that! That said, if you work at a technology company, you CAN build a portfolio and self-advocate for projects with engineering teams your data science team already works with.
I think it's worth seeing how far you can get with this approach before interviewing for engineering roles at other companies.
One notable caveat with my approach: pursuing a portfolio approach took me a whole year to switch from DS to engineering. As you point out, grinding leetcode may only require half that time.
Yes -- one thing I struggle with is choosing whether to work on data engineering projects (which I know I'm good at and can provide immediate value) or challenging myself with more "traditional" full-stack engineering work where I can learn a lot.
Hi! I'm Zach, the author -- I put together this doc since I couldn't find many resources I could recommend on metric design and evaluation, which pops up in data scientist/product analyst interviews and is a common task for data science teams.
Looking to hearing your feedback and if you've seen other good resources on this topic!
Hi! I'm Zach, the author -- I put together this doc since I couldn't find many resources I could recommend on metric design and evaluation, which pops up in data scientist/product analyst interviews and is a common task for data science teams.
Looking to hearing your feedback and if you've seen other good resources on this topic!
Agreed! Pandas is great but at this point instead of using logic to solve data structuring tasks I often find myself googling for an optimized built-in Pandas method to help me out. Leads to less elegant code -- not sure if it is less readable though.
Sure! Practically speaking, as a data analyst, I would probably notice a missing month when plotting the trend of MAU over time.
(You can make "but what if a month is missing?" a latter part of a multi-part interview question)
Generally I would assume that data engineers would have a month of no users set to zero or that I could ask them why that's not the case and note that for future reference.
One thing I mention in the doc intro is that SQL questions are one part of the data analyst interview, not all of it. If this doc helps people get through the SQL questions so that they can spend more time being thoughtful with open-ended analytics questions, that's good thing (both for interviews and for work more generally)!
Sorry about that -- in real life you would just ask the interviewer what MAU meant if they didn't spell it out.
The purpose was to make the questions more realistic, since at least in my experience in data analyst interviews the questions are asked in the context of actual business or product situations ... like company leaders, PMs, or others wanting to understand trends in MAU.
Sure, that's a fair criticism. That said, you can build multi-step interview problems with SQL (I tried to convey one or two in this doc) such that interviewers can build up towards needing a more advanced window function instead of starting there.
I've used BETWEEN ROW maybe once or twice in my career in a professional setting. Self-joins more often, but as others have pointed out window functions are more efficient here for writing dashboard ETLs, etc.
Btw, are you minimaxir who wrote gpt-2-simple? I was looking at your tutorial a month ago while putting together a solution for the Kaggle COVID-19 NLP challenge!