Related Posts
More Posts
Hi guys,
Need 11 likes to access dm's
Thank you
How many locations does Tiger Analytics have?
Additional Posts in Consulting Exit Opportunities
Received an offer as Engagement Director from Salesforce (CSG, pre sales, L9). Great benefits package, 40% increase in total comp and better WLB.
I do love the people in my practice and current client, but career trajectory has stalled after taking parental leave earlier this year and (yet another) change in leadership.
Realistically, making to Director is 2-3 years away and will require sacrificing time with my family that I am not prepared to give up.
Should I stay or should I go?
New to Fishbowl?
unlock all discussions on Fishbowl.





Depends what your exit plans are.
I had a background in Python via school but also was always on engagements that required some sort of coding (R, Python, SAS, SQL). I recommend just doing a bunch of leetcode/hackerrank. If you can comfortably solve all the medium and less ridiculous hard questions you should be good with the SQL portion. I would also focus on product sense questions as those can be tricky. I found that coding is secondary to knowing how to problem solve/finding thoughtful insights.
Usually there is a test during the interview . I’m in industry now leading my own analytics team. Just know you joins, sub queries, window function is a plus if you really want impress people in an interview. For python know your loops. Those are the usual things you need to know the rest can be taught or you’ll figure it out since consulting is all about learning on the fly. Come with real examples of taking data, cleaning it help doing some type of modeling/analytics and what business levers it pulled/improved. Also bring in sample code also to show some of your work and some viz. Good luck!
Just what my experience had been
Work in GPS? I need Python devs to do real data science. DC based role, hit me up if you’ve got skills.
PM me- clearance required.
Python - learn functional programming, and some basic ml/data science processes (numpy, pandas, jupyter notebooks, scikit learn, matplotlib, etc).
SQL: you'll really be mostly tested on joins and aggregations, I seriously doubt that you'll be expected to build any udfs (like some have suggested here). Bonus points if you can learn the basics of distributed systems like presto/hive/spark(pyspark), but this should be secondary to having a solid foundation of relational databases.
Also if your going for a DS role, know your stats too.
The secret to getting into industry is practicing leetcode and build up some personal projects on kaggle. HUGE BONUS if you create a website/portfolio of some of your analytics work, stuff you did professionally and in your free time.