{ "media_type": "text", "post_content": "LinkedIn says they need Advanced SQL for this position, not intermediate, but specifies by saying “can use select and joins.” Can anyone at LI comment on how much SQL for analytics associate roles?", "post_id": "5e82861f17ce55001a71e010", "reply_count": 9, "vote_count": 1, "bowl_id": "5ae4a4f739e7cb001391ec8b", "bowl_name": "Consulting Exit Opportunities" }

LinkedIn says they need Advanced SQL for this position, not intermediate, but specifies by saying “can use select and joins.” Can anyone at LI comment on how much SQL for analytics associate roles?

Post Photo
like
Posting as :
works at
You are currently posting as works at

Lol reading this I’m thinking you probably don’t want that job - sounds a little boring!

like

So beginner: create and maintain queries Not beginner: create/maintain databases

like

I mean I think the description makes sense. Clearly written by an engineer, but I get it.

like

It sounds like they want you to have advanced skills like optimizing table structures and data normalization, using table indexes effectively, and being able to know the difference between queries that are O(n) and O(log n) for optimization.

like

LinkedIn went on hiring freeze today until further notice

OP how long did you spend reading this before posting? 5s?

Is this just an analytics role in the job title OP? Sounds more like a DBA. The use select and joins is in their beginner section.

Related Posts

Currently live in NYC, got an industry offer with a 4% pay raise but new role will be in Princeton NJ. Better work life balance but I’m single in my late 20s. Bad move or good move?

Is “Senior” at EY a high level role? I am currently a Senior and this is the first progression point after campus hire. Didn’t get an interview which is puzzling because I have great experience relevant to the posting. 2YOE

like

Slalomites - Got an offer to join as a C w/ 2.5 yrs exp at $105k all in. High COL area. Should I negotiate up? Other qq’s: is there a referral bonus? What’s their phone policy (type, reimburse., etc)?

like

Does anyone have idea about Liberty Mutual work culture? Interviewing for an IAM role. Thank you.

like

Two years into consulting and I still have absolutely no idea where I would want to « exit » or go to after this.. Anyone else in the same boat?

likefunny

How are the exit opportunities for Management Consulting Analyst/ Management Consultant from Accenture Strategy? Is Accenture Strategy considered a good brand?

likesmart

I have the choice between a Masters in Computer Science or a position at a FAANG. Which would be more beneficial for my long-term career path?

like

Hey I am a Software Engineer with a experience of around 3 years. I am looking for a switch to a Data Engineer position. Any refferals would help. Referal from Rakuten , Tredence , Tiger Analytics, Lowe's , Legato , GE and other healthcare and Data Analytics will be helpful for me. Thank you

like

Do you use semicolon to connect two relevant bullet points into one in your resume? How many bullet points/sentences did you use for one role?

like

I’m in a pickle. Currently working in multistate tax and I am not a fan. I just accepted a position with KPMG on their methods team (it sounds like interesting work and I’m sick of compliance). I put in my notice and my Deloitte manager is trying to fight for me. He wants to match the pay they are offering and get me into a group that I like more. I am a ball of anxiety. Loved the people I met with for KPMG, but having my manager push so hard for me is making me have second thoughts. Any input?

like

Digital Strategy M ready to move away from consulting and searching (a lot) for a connection into Cloudflare for a PM role - does anyone know somebody there?

like

I was laid off from a resource management role, working with employees approaching or on the bench, working with managers to staff projects, and support functions like report creation, scheduling, etc. Roles like this are few and many large consulting firms have frozen internal hiring. Do you think it would be beneficial to get a SHRM cert? Would that help get a "talent related" HR role? Worth the money? I have a background in recruitment as well.

like

Any CA-licensed corporate associates interested in San Diego biglaw? My firm is hiring there for general corporate, capital markets, real estate, investment mgmt, and venture/growth finance. NYC salary and hybrid office/remote. ☀️ DM me.

like

Have a senior consultant offer from a Big 4 and a product manager offer from a pharmacy retailer (cvs, walgreens etc), but both are similar roles in digital PM/strategy. Which offer would be best to take to help me eventually exit to the tech industry in a similar role?

like

Hello Fishes !! I am about to receive an offer from EY GDS for a role of a Business Analyst_Banking finance (Principal Consultant) with a CTC of 27 LPA (inclusive of 10% variable). I am having 10.5 YOE. Is this grade relevant which they have offered, taking my YoE into account? How much i can negotiate upto in CTC front? I mean the highest slab of Principal consultant? TIA

like

Being the only expert around? Hey everyone, I’m looking to head in-house in the next 12 months, but I work in a specialized area with v few openings. I just noticed a job posting for a senior counsel role at a startup. This would be my first in-house role so I was wondering if anyone could speak to their experience as the only expert/specialist in their area at a company? Recognize it’s a massive growth opportunity but also scared of the big jump in responsibility/no safety net.

likesmart

Facebook reached out to me for a role and I got the job. I was then told that I won’t be getting the offer because their immigration team thinks it’s a risk to give me the offer. Contd...

Media 🐠: Other than money and the potential of better work/life balance, what other reasons attract you to a client side role?

like

I received an offer from Bain for the Manager role. Does it make sense to make a transition for the brand value? My goal is to exit consulting in 1-1.5 yrs. Currently, I am an AS1.5 at OW, expecting to progress either to AS3 or Engagement Manager (somewhat unclear at this point) at the EoY. My content focus has been in FS (where Bain is less strong in my country) and Private Equity areas.

like

I’m interviewing for a PM job at a nonprofit. Any advice for how to talk about salary and annual reviews, etc.? I worked in nonprofit many years ago but not in tech or in a PM role.

like

Additional Posts

I have an interview with GEP Consulting tomorrow. Anyone worked/works there or has interviewed there? Looking for some pointers.

like

Water leaks out of the ceiling and onto the toilet when the shower is on. Marriott in LA. How many points?

If I make 85k tc with 71k base what should I expect as a raise after first year?

like

Any trial prep tips and tricks for an associate second-chairing a medical malpractice case for the first time?

like

EY folks, when do our skype positions update for promotions?

like

I want to get my start into marketing/advertising as a junior strategist and so I was wondering if anyone had tips when it comes to resume, portfolio, interviewing, etc.? Especially considering my lack of direct m/a background (mostly self-taught) compared to folks from miami ad school or vcu

like

Anybody have any personal experience or knowledge about the work culture at Visa.

like

I learnt that I earn almost the same than a Senior AD. Any advices to increase or re-evaluate my salary with my boss? (next post = more info)

Post Photo

Currently pegged as the defacto lead for my sub workstream with only one other project under my belt. I don’t know if this is complaining but I feel like I’m not ready to fill this role (contd)

Has anyone looked at/interviewed for/done the rotational program at Bristol Myers Squibb?

like

When's the best time post-undergrad to apply from another consulting firm? I'm approaching one year at a T2 after a handful of unsuccessful final rounds across MBB during recruiting. Does it make sense to wait for 2 YOE? Is applying noe best? etc.

like

Does anyone know if MBB (Toronto) is hiring a lot these days? Currently working at big 4 (manager) with no case interview experience/ no mba … thinking it would at least take me 2-3 months to prep and network. Would trying to get in by Jan be too late? Also, my spouse is thinking of potentially moving to the states next year. Do you know if US MBB helps new hire with their H1B visa? (Understand it may be difficult but want to check if it’s worth trying)

like

Good Marriott hotel in Vegas for Christmas time? Platinum elite member hoping for upgrades.

like

Which is better for exit ops, ceteris paribus - Deloitte or EY?

like

How important is getting a Six Sigma Green/Black belt? Does it make a difference in comp/offers/projects/promotion?

like

Any good MBA programs that include a joint engineering degree? I see both Wharton and HBS have them. Looking for others.

likefunny

Fishes need advice, I'm a M3 and my Partners have repeatedly told me that I am the strongest candidate for promotion this year, they haven't said it for sure though. I got contacted by Deloitte Digital, and I am being offered a Senior Manager role with a slight bigger pay when compared to my estimated salary after promotion (10k per year). Is it worth changing? what are your thoughts?

like

Hi Fellow Fishes, It is very important to take some time off every now and then. If you can take at least a week off every 2 months, and use that to get some office work done, trust me it will change your life...

like

Which is better for exit ops, ceteris paribus - Deloitte or EY?

like

Best Holiday gift from vendor / what was it? Bonus question: does this still exist?

likehelpful

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

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal