What sorts of SQL questions are typically asked in interview questions for senior data analysis jobs? Like is knowing SQL from freecodecamp enough or should I look into taking a course online?

I’ve unfortunately not gotten the chance to use SQL in my current position so I don’t feel like I have enough experience in it, but have experience in everything else (Python, tableau, storytelling, etc)

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

It depends on the company, but I've had a few that required a live coding demo - basically a leetcode/hackerrank SQL challenge that I had to do for the panel interview. If you want to practice, I'd say leetcode is good for interview prep.

like

Oooh this is really good to know. I was wondering this myself. I didn't know they ask for live coding demos. I will def need to practice this.

If you know what specific company you'll be interviewing with, Glassdoor "interviews" usually has intel on that sort of thing. Super helpful.

like

Agree with the suggestions above. I can’t imagine they would ask much more than joins, group by, and maybe nested queries and partition by. Other than that, most of your data analysis should be done outside of SQL, and you should tell them that 🙂

like

I'll add that for my last DA role I had some questions about stored procedures. I'm not sure if this is typically for a DA though - I thought it was more on the engineering side

like

Best case scenario is you get a take home assignment. For the most part most sql interviews are mid level so your joins, case when, percentages, etc. The hardest question I’ve had was utilizing a row clause in a windows function.

Also something to keep in mind is that you generally won’t be able to run any of your queries since they’ll usually just give you table names & fields but no actual data in the tables.

like

DA1 and A1, I’ll look into those. Thanks!

Related Posts

How do you keep up/in touch with your network? Mine barely post anything on LinkedIn, so commenting on their posts is out of the question, and apparently it's impolite to just message or email them if the job searcher doesn't have anything to share besides asking for a referral or opening. If I don't have any relevant information to share with them, what should I do?

like

Probably worst time but I’m looking to relocate to AUS from Canada - thoughts on this occurring in next 12 months giving hiring environment? Hard to tell without being there on the ground

like

Hi all,
Does Consultant specialist designation GCB 5 come@under the role of AVP?

like

It’s review season at my agency. I’m struggling with what goals to put down or things I want to learn. Not because I think I’m perfect (ha) but because our job description gets so amorphous as we elevate. I’ve been an Account Director for about 3 years. What are goals that y’all have set or things you’ve looked to learn as you’ve gotten more senior?

like

Hey new to this field..so what are some certs I should focus on as a newby... and what type of training I should be taking. I've been focusing in trailhead..but if u know of other training mods..lmk.

like

Should I expect any specific questions during an introduction call with a recruiter? I have a call setup with a BSG recruiter and just wondering if I should prepare for any interview type questions?

Thanks in advance!

Was having a chat with a recruiter who does a lot of work for me so out curiosity I am interested to hear what do consultants look for when they are moving into the industry.
- What are some of the key elements you look for vs deal breakers?
- What types of firms and industry are of interest?

like

I am a Customer success manager, I now want to go in product, its a dream job for me Product Manager.

Where shall i start?
What certifications?

like

For startup founders/people with a successful side project: How did you get the idea/inspiration for your business? I’m currently working at a Series B startup and my end goal has always been to found my own startup, but I graduated from college 2.5 years ago and I still have not had any great ideas cross my mind. I do spend a fair amount of time brainstorming. I don’t want to continue working here forever, but I’m struggling to generate that “this is it” idea to build a company for. Any advice?

like

Hi everyone,

I am looking for a switch in Customer Success / account management role in Salesforce.

I have 6+ Yoe in sales, marketing and partnership domain and currently working as a CSM for 75+ brands including enterprise businesses.

I will be highly obliged if anyone can refer me for an opening.

like

Hi i am working in TMB bank as assistant manager. Now I want to switch to IT since my qualification is MSc IT. What are the certifications I have to do. And is it possible to switch my sector.

Hi guys,
Any openings for GIS Mapping operations or as data analysis roles ?

like

Hi

I recently completed 2 rounds of interview with ORACLE, how much can i ask them, can i ask 12 LPA?

My CTC is 3 LPA
Holding Offer with 7.5 LPA from investment banking.
My EXP :- 2.6

Thanks in advance.

likefunny

Ex consultant, currently in industry. BCG HR contacted me for a role, process was a lil messy and unprofessional. Still waiting for the “exploratory chat” she was supposed to set up with the MDP since 2 weeks ago. Texted on whatsapp but no response. Normal?

like

Does anyone have any tips on how to crossover to governmental affairs? I love government work, but I would like to try it from a different perspective.

like

Can anyone please weigh in on base salary and bonus structure for Strategy& director level role? Also is the path to partnership similar across S& and PwC? TIA!

like

Trying to get into stand up comedy, any advice? Not sure where to start but am really serious about giving it a shot

like

Sr Associate - Product Management

What could be the salary range for this considering 2 Yoe.

If anyone is currently in this role, please dm

like

Are there any disadvantages of joining a C2H role purely on the basis of high CTC even though it is for a big client of the contractor company?

like

If money was not a criteria, what job would you do?

like

More Posts

I'm a little worried about microplastics in my food. Is this just hysteria?

like

Would anyone recommend a good place for indoor tennis lessons? Thanks 😊

like

Amazon is hiring a lot of migration specialist ,could anyone refer me ? Also what is the package they offering

like

LTI is Hiring for below Oracle - BU positions

Need immediate to 30 days joiners only

Location: Bangalore/Mumbai/Pune/Hyderabad/Chennai

JDE CNC
YOE :4 - 10 Yrs
Skill : CNC

JDE Finance Functional
YOE: 4 - 10 Yrs
Skill : FUNCTIONAL-FINANCE

OCC (Oracle Commerce cloud)
YOE: 4 - 10 Yrs
Skill :OCC

Oracle Flexcube
YOE :4 - 10 Yrs
Skill: FLEXCUBE

Oracle CPQ CLoud
3-5 years of experience in Oracle CPQ Implementation & Support
location - Mumbai

Interested plz DM with job codes

Post Photo
like

Hi Fishes anyone here working in ADDA project

like

What is the average salary for 5-7yoe full stack dev in Canada?

like

NYC struggles: 1st paycheck to rent, 2nd to pay off credit cards. Almost none for savings. Maybe it's time to rethink my lifestyle of drinks and debauchery ✌️

like

My boss won’t stop sexually harassing me. Verbally, email, texts - 400+. He even set up his office with a display of sex toys and edibles condiments to show me that he planned to give me oral sex. All started 3 weeks into the job. I moved my family cross country for this job and just bought a house. He promises me none of his requests or my responses will affect my job and is just begging now to be friends with me. Tell me what would you do if you were me.

like

Thoughtworks recently announced the Q3 result. Which wasn't that great though.

Can anyone share their views about TW strategy to handle the recession?

Is there any hint of layoffs from leadership?

like

I get asked all the time to consult for certain clients on the marketplace pertaining to my area of expertise at my current job. Is it unethical to take these paid calls even if I remain anonymous and do not disclose any confidential information?

like

what is the pay range for role - manager 1 assurance at pwc sdc kolkata?i have 6.5 yoe and joined at 21lpa + 10% vp, four months back. managers from other big 4 start around 28lpa. does sdc kolkata pay m1 this much only or have they underpaid me? i am considering dropping paper and looking out again.

like

Can someone refer me to Harman Connected Services ? I have 4 years of experience as a UI developer (React)
Thanks in advance.

like

What’s it going to take to make this bowl active?

What do people around here do on the weekends? It seems pretty slow so far

like

What are the benefits time off/sick days/etc offered at EY.

like

If you saw a job applicant left last job a little less than 2 years being there (20 months at job) would that raise a red flag? Fairly early years of career

like

Best place to find area rugs online or DMV area?

like

How much fractal analytics pays for grade 8 I meant consultant position in India Thanking you in anticipation

like

Additional Posts in Data Analytics & Data Science

What is the market like for entry level data scientists/ data analyst. I have a graduate certificate in data science and have spent the last 27 years as a mainframe dev so I have great SQL skills.

like

I am quite early in my career and currently working on my masters in data science. Any tips on what kind of projects I should include on my resume and if I should include them?

like

I like to pursue in the data science field. I have business Analyst experience but to switch to data science field could you guide me on what should I learn? Where should I start?

like

Here is my go-to interview question, "What is the difference between data science and data analytics?"

What questions does everyone else include when interviewing or is the best question you've been asked in an interview?

like

Let's build a playlist! Share what artist. songs or podcasts you like to listen to while spending hours writing endless amounts of code.

like

Hi All, I am currently a Data Analyst with 1 year of experience and pursuing a masters in Computer Science (expected to graduate 5/2023). I am looking to transition into an entry Data Scientist role (preferably remote or Philadelphia, PA). Can someone refer me or let me know who is hiring?

I can provide my resume if needed.

I have 5 YOE in Analytics... always thought I wanted to be a DS, but every job (even the junior ones) required experience in ML development. Though I am part of the ML project, I'm not the person develop the model. And I have a hard time when the interviewer ask about how I develop the model and what hyperparameters I tuned. I know the thought process and stuff but 'I' wasn't the one who did that part in the project. How to convince them that I could do the job without taking credit of others.

like

Just started a new Data Analyst position in which I have constant meetings with senior leadership and executives. I have a bad habit of giving too much background info and not getting straight to the point. I just feel like every little detail is important (even though that’s not always the case). Any tips for breaking this habit or just become more efficient with advising?

like

Could someone help me break down the differences between a Data Analyst vs Data Scientist vs Product Manager? And add any pros/cons from personal experience? In my mind they’re all related, but I don’t have experience working with any of these roles.

Good morning, hope everyone is having a great week! Does anyone have any advice on breaking into an analyst role? I am currently a Senior Customer Success Manager, with a background in Operations/Process and Project Management as well. I have always enjoyed the analysis pieces of my roles and would love to expand my skills to show how qualified for a position in data analytics. Thank you in advance for the help!

like

There is a MS program in Data Science at CUNY SPS. I am considering to take that program or do the CFA. Does anyone have any insight about the program?

Would like some opinions about how likely it is to make product analytics self serve by PMs? Anybody have success here? Or is it hopeless to think that product managers can pull their own data, look at their own dashboards, and do basic data tasks themselves?

like

I have worked with Forbes top companies, for-profits, non-profits, & startups. I consider myself a solver of complex & complicated problems requiring mixed method research & novel solutions. This has led to issues in self-referencing title. I’ve been project manager, data engineer, developer, modeler, analysts, principle DB developer, etc. Most of my w2 work has been from offers of 1099 clients so I am usually asked to define my own title. Any T-shaped data people who run into this?

like

How is it to work as a Data Scientist at Morgan Stanley ? How os the data culture ?

like

I have been seeing all of these "studies" saying that many people prefer working in the office versus working from home... I'm doubting these results and want to conduct my own little poll.
Do you prefer:
A) Working from Home
B) Working from the Office
C) Hybrid

likesmart

Where are good companies to apply for to get into data science? My offer right now for data science in the big4 is only 66k and I definitely can’t go that low. Industrial engineering background with experience in analytics.

like

I’ve got about 20 years cross channel experience in marketing, split between big brands and startups, and I’m considering pivoting into a data science/data analyst role. I know it will initially be a step back in comp but is it at all realistic for a person with certificate level experience in data analysis but a decent marketing management background to expect $150-200k comp or is that mostly for degreed candidates (or not realistic at all)? Any guidance here is greatly appreciated.

like

I have a JP Morgan code interview happening soon for a data science position. Anything I should know before I get started?

like

Any recommendations on data warehousing solutions? Struggling to find something that covers all the bases but is still economical. Considering looking into consultants at this point

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