What level of python/sql proficiency do I need for a decent exit as an analyst? Tired of just making slides for people who don’t understand tech

likeuplifting
Posting as :
works at
You are currently posting as works at

Depends what your exit plans are.

like

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.

like

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.

Related Posts

I am currently working as a delivery manager for a data science project where I manage both ML and DE teams. I am not sure what career path should I follow.

Should I move into either a core technical data science/data engineering role or move into a techno-managerial role like a program or project manager? What role would be best in terms of money, growth, and job security?

like

Hey guys, I have the first short 15-minutes call with a product guy from Hugging Face today wherein he is likely going to take a guess at what roles I could be suitable for. I had applied for Post-Sale Machine Learning solutions Engineer. Is there anyone who’s gone through the process for a similar role at similar organisations or best case scenario would be if anyone has gone through the process with HF.
I have been working for a year and am doubtful if I’m mature enough for the role. Help lol

like

Hello,
I’m a MRI technologist with bachelors in radiologic science. My goal is to become epic analyst. I do have a proficiency in Radiant. However, I am not having much luck with any applications. Almost all the postings require actual certification or build experience. I am thinking that I may have to go back to school. My options are either go for masters or go for another bachelors in IT/computer science. What could be my other options? Thank you.

likehelpful

Hello everyone, I need suggestion regarding carrear transition. Devops or data engineering which path should I choose, I am software test enginner with 7 yr of experience.

like

Hey Guys, I am a data science associate at ZS. Let me know if anyone wants a referral in any of the below profiles. 😊

Post Photo
like

Can someone share any openings for JPMC Bangalore related to freshers.
Tech stack is SQL and Tableau. I am a fresher with 10 months of experience in internships and 1 month of full time experience.

Thank you for your help!

I am in a tech IC position. One of friends switched to FAANG by converting the profile to consultant profile. The friend who might have less tech knowledge than me is now in FAANG and earning more. If the end goal would be that the friend might one day be a product manager and me an engineering manager taking instructions from the same friend, isn't consultant profile an easier path to growth. I had been practising DSA for years and the competition is only ever growing.

I recently accepted an offer from Amazon and will be joining in a month. From what I gather from my friends who currently work there , your experience at Amazon is solely based on the team that you join. Some really like it there and others are waiting to get out. How easy is it to switch teams within Amazon ? And what's the process like ?

Got a call for Jamaica location, QA role.
It’s through some Indian consultancy. They would pay in INR (2.5 lakh per month) .
Is that good to go and survive in Jamaica. Accommodation would be from consultancy.

like

Is there any plan of opening new office in chennai? Considering current situation

like

Friendly tip: Don't burn bridges even with those who are leaving - our industry is small (even in Manhattan) and you will almost certainly see that person again if you stay in pharma

likehelpfulfunny

How long is it taking to hear back from companies (Accenture, Deloitte etc.) after applying with referral? Is it quicker because of great resignation or still the same amount of waiting time?

like

Currently a software engineer at FAANG (four years out of college) interested in getting involved in tech private equity. To reset my career, what is the most efficient route to get there? MBB -> PE?

like

Looking for some advice on how to branch off into a job in tech. I’m a Mechanical engineer interested in working in a big tech company. I have some programming experience but excel mostly in mechanical and product design as well as 3D CAD. Was wondering if any other mechanical engineers have managed to make the shift from a traditional mech job to a tech job and if you could give me advice on the best path that worked for you. Thanks!

like

What’s your advise for someone looking to get into soft IP litigation (not an engineering / science major) but have been working in L&E for 3 years now. I want to make the move, but feel like my background makes firms not want me. I’ve applied to a few places but don’t get an interview. I know my litigation skills are top notch — so I don’t know what to do. I started branching out to orgs to network , but any other ideas?

like

Hi folks, I noticed Mastercard is actively hiring for Analytics role. Really appreciate if someone can refer me for that role? Thanks!

like

I am currently practicing insurance litigation but am looking to transition into corporate law (M&A, private equity). I have heard horror stories about this practice area though. I am looking for input from those who practice in this area. Do you like it? Is it interesting? What are the hours like? It seems a lot of people in this area are looking to get out...am I making a mistake by looking to get in?

like

Does anyone have leads for a recent MPH Epidemiology grad with 0-2 YOE to get into consultant roles in Healthcare/life sciences?

Second question: what sort of work experiences are companies like flatiron and komodo health looking for to work in RWE/heor? I'm not sure how to leverage Epidemiology to get into that space :(

Hi Fishes,

I have joined coforge on November 2nd and I got offer from ITC today...Can I switch to ITC by obscanding will there be any issues...Please guys please give your suggestions

I am a Strategic Sourcing Manager with 7 YOE in both direct and indirect spend across various industries (Life sciences, IT and Insurance) I have been offered a role with Fidelity for 13 lpa + 1.5 variable. Offer seems better than the national average for similar roles but I feel I would be underpaid based on the current market, my skills and value I will be bringing to the table. Any suggestions for offer negotiations?

like

More Posts

like

What are some of the things that were a MUST when buying your first home and what were some things that you were more flexible with and why? I’m having a discussion with my partner about what we absolutely need and what can be worked on later.

like

What should one disclose/not disclose in an exit interview or should it be mum’s the word, don’t burn any bridges, any advice fellow fish?

like

If dogecoin continues to moon and miners don’t step up their game, someone’s going to 51% attack the network and start stealing coins

like

What is the average salary for a data engineer with 5.5 YoE?
Skillset: Spark and Hadoop with hybrid cloud.
CCTC 13.5 fixed

Which companies offer good salaries for data engineers?

like

How is the manager role of Deloitte India for analytics and cognitive practice? Anybody from this practice who can help me on this decision please. How is wlb, I know mine is going to be client facing and that I would be expected to do more that just project work but does that mean I would have to work on getting projects for practice or how it will be?

likeuplifting

Anyone joining Deloitte india in the month of October?

like

Am I the only one who is a victim of emails going to outbox and not sent before you sign off? Happens only when i don’t check my outbox as I close my laptop 😩

like

Just accepted a job at big 4, I have 1 YOE experience as a data scientist, plan is to stay for 2 years then go to MBB or masters…thoughts?

likesmart

Hi All,
I Need Referral
Total experience - 3.5 years
Skills - Java, spring boot, spring cloud, microservice

like

Hi have an offer 7.5 lpa + 50k bonus from NSEIT, i have 2 yoe in .net my current CTC is 4.8, please suggest if this is an good offer.

like

Any Big 4 fish who are not really pursuing MBB for exit ops... what are your exit goals?? And for what reasons? Trying to find options other than chasing MBB

Interviewed for a role last week and have not heard back. Is it too soon to follow up with the recruiter on status?

like

Hello Fishes, looking for an opportunity for below mentioned role.
If anyone could share some leads.

Role: Scrum Master (PSM I Certified)
Total experience: 5.2 years ( 2 yrs as SM and 3.2 yrs as QA)
Location: Pune or remote

like

Hey guys. I recently graduated with a bach in business, a graphic design bach, and an MBA this past May. I thought this would help make me look like a stand out on job applications along w/ my international internship but I can’t get an interview for an entry level job at big companies like Deloitte, Goldman Sachs, or Leo Burnett. Should I take my MBA off my resume?? What am I missing??

like

Immediate joiner, React js + .net + MsSql - Please refer
🙏🙏🙏🙏🙏

like

How quickly do we have to commit after decisions are released (e.g, for Wharton, Haas, Booth, Columbia, Kellogg)? TIA!

like

Hi guys,
Need 11 likes to access dm's

Thank you

likehelpful

How many locations does Tiger Analytics have?

like

Additional Posts in Consulting Exit Opportunities

How well does 1 year in a top 4 looks on the resume when trying to look for a software development role?

likefunny

Reports are that the average tenure of people in top consulting firms is 2.4 years. Interesting how the industry is even shorter. Thoughts?

Post Photo
like

For those who’ve interviewed or worked in PE Operations, how much of a finance background is needed? Any accounting knowledge?

like

Two years into MBB post MBA, I realize my passion lies in technology. Although to progress in tech, you need to be a product manager. I have no prior product experience so will have to start from scratch. Have I wasted my two years at MBB when I could have recruited for product roles in business school?

like

Got reached out to by a Google recruiter for an interesting role. They said they would send my info to the hiring manager after our conversation. Can anyone who has done the interview process with G tell me what time timeline is usually like from phone screen to first interview?

like

What are some good online resume review service out there that anyone can recommend?

like

Anyone have any experience interviewing for/working for any of the Blue Cross insurances?

Can folks share their application stats lately? Time period of applying, number of apps -> number of hr screens -> number of first round interviews -> second round interviews -> Superdays -> number of offers ? Thanks all.

like

Feeling disheartened after sending out 100+ applications with radio silence back. No rejections but no invited to interview either. I feel like my resume looks good, but I have not gone the referral route as of now. 1 YOE

like

Any advice on landing a strat & ops role in a tech firm? The JD is my dream role, but these opportunities are few and far between, and yet I keep getting rejections even at the CV stage. Currently in a DD shop, so could be a fit issue (but I can’t pivot…)

like

Can someone explain the difference between FB’s Partner Solutions Manager and the Strategic Partner Manager? From an initial recruiter call, it seems the SPM provides the consultative product recs while the PSM onboards the client onto that product and tracks performance to provide actionable recs as needed. Anyone know career growth and salary for these two? I don’t want a sales heavy/only lateral growth role like their client solutions manager roles so these seem like good compromises?

like

Does studying for top consulting firms’ case interviews help in any way for interviews with other firms (e.g., FAANG case interviews) ?

like

Have been approached for a "Transformation Officer" role at a PE held port co with high probability of getting it. Torn staying in consulting ( 1.5 year post MBA till now) or new role? Suggestions?

4YOE @Amazon & trying to lateral to a similar role @FAANG. Have my undergrad GPA (3.8/4) on resume from top 15 school but colleague says to take it off (looks silly). If it’s a good school & high GPA, why ever take it off your resume? Even if 10 YOE...can’t hurt?

like

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?

like

IBM - Official cloud and AI partner of the US open.. for all other BS, we are here.. #greendot

likefunny

Went into an industry PMO role after consulting and literally hating every second of it after a year. What to get back to more S&O / BizOps focused roles. Any advice from others that made the transition?

like

Should you mention side hustle work in an interview? Not gaining transferable skills in my current role but have been doing freelance work on the side that is highly applicable.

like

Best way to find work in the US without MBA or company transfer? (As a foreigner)

like

IT audit, 3 YOE. I want to exit to industry but it seems like every role I look at is tailored to either financial accountants or IT/systems engineers. Help!

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal