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

Just graduated from law school in 2021 and finishing up a one year clerkship. When applying for a new position, would I be considered "entry-level" or a "lateral"?

like

Thoughts on KPMG's Financial Due Diligence senior position? Thinking about a transfer from audit.

like

Girl Scouts has brought me to my last interview stage for Community Engagement Manger. What should I ask for? I have over 5 years of experience and I am also a military veteran and served 7 years.

like

The interview invitation doesn’t say who I’m interviewing with. Is it okay if I ask the name of my interviewer? I feel weird going into an interview and not knowing their name.

like

Dear Fishes,

Can you help me give a bit of description of EXL? How is it in terms of WLb Job security and Growth and hike?

YoE - 5 years

like

I'm applying for a job that wants at least two business or professional references. Thing is my current job is my first job out of college and I don't want them contacting my current employer. Who am I suppose to list as a reference? Leave it blank although they personally asked for references? List college professors? Ask a coworker to be a reference and not spread work I'm leaving?

like

Really confused with choosing careers-
Product management as next step or Remain in Strategy Consulting of an IT organisation and switch to pureplay strategy firms?

Could anybody please guide what factors would you deliberate on and what kind of personality would suit for these roles?
I come from Research, Financial analysis background and recently moved into Consulting. I love deliberating on macro solutioning and solving business problems. My current skillsets are more aligned to Financerole

like

Hi all, I’ve recently onboarded as an HR recruiter with a small NGO. It has been wonderful so far. I want to make the most of my new role. If you have any suggestions or advise, I’d greatly appreciate it.

like

Starting a new role at a consulting firm and may be traveling a lot for clients. What is the best way for me to take advantage of any points/rewards I may accumulate.

like
like

Dear all,
I have total experience of 1.8 where 1.2 relevant experience of react developer.
I need referral.
My current ctc is 3.5
How much can I expect...
Can I get 12lpa
Need your kind help
Thank you

Dear Nurse colleagues. What’s your opening statement on your resume (portion where you describe yourself and why you are a good fit for such role)? I am at loss as I haven’t fixed my resume for last 7 years.

like

Just started a role in client service last month. I was wondering was it is like to be a broker and how compensation structure works? How do you go about looking for new clients? Or are they given to you? Sorry new to this industry!

like

Why do all of you want to "exit" to tech so bad? Are you just following the money?

like

Hi All, Any wipro employees there please dm me, I need referral for one the post in wipro careers site
Thanks

like

Any tips for Amazon Web Services Senior Business Intelligence interview? Guess it would be SQL round.

like

What questions do you ask in an Account Executive interview? Other than the generic questions that you can ask at the end of any job interview. What questions can you ask that show you know your stuff in Account Management.

like

Hi all,
My lwd is 14 oct.
I am confused between EY GDS and Neudesic, for same role - Azure Data Engineer.
I have 2 yoe and EY is offering 13.5 fixed + 5% variable and Neudesic - 14 lpa.
Any inputs are appreciated.
Thank you.

like

Hello Fishes.. I had applied for a position and had completed the cultural assessment. Received an automated mail that said “we will be in touch soon”. It’s been more than 20 days and haven’t received any communication. Should I expect any reply now? What’s the usual procedure like?

How do I approach them in a way that makes me stand out?

I’m interested in a Success Operations Analyst or Sales Strategist role at a Y-Combinator FinTech startup. I’m a perfect match for the roles & I have the opportunity to speak directly to the founder but I’m not sure how to approach them in a way that makes me stand out but not too arrogant.

Any tips??

like

More Posts

When can we expect appraisal letters ?

Doing Agile project, the client is asking how will use QA to be effective in MVP release. Can’t figure out how to use QA in Agile framework.

like

Looking to hire a Project Manager in the LA office of our small independent agency (with big clients!). Work will involve shoots, retail and general branding/strategy - with hopefully one day some events back in there. DM for more details.

like

For those working agency-side, what is your requirement for daily/weekly billable hours and time tracking? Trying to find a balance between what is fair and contributes towards a positive work environment, but still profitable.

like

Anyone suggest working for Facebook?

likehelpfulfunny

Hello! Can anyone offer insight on the corporate/m&a groups in the following DC big law firms: Latham, Goodwin, Covington and Gibson?

like

Anyone doing multiple contracts at once in the UK? How does the taxation work?

like

Hey Salt peeps. I’m curious what kinds of practices you specialize in and how long you’ve been doing it? Would you specialize in something different in tax if you could turn back the clock?

helpfullike

If anyone is hiring in the DMV area or remote for a Mechanical Engineer, please feel free to DM me!

like

What are the travel opportunities for a functional consultant at PWC AC Banglore and also any info about moving abroad internally

like

Any leads for good headhunters ir recruiters? I am looking for full time
in the LA area- Thanks!

like

At my firm we do 50hrs a week in November. I’m giving my 2 weeks tomorrow. Do I need to do 50hr weeks for my last 2 weeks??

Openings at VMware interested please DM

Post Photo

Any books/self help materials for someone who is constantly worrying (and waste a lot of unnecessary time)? E.g. No matter if i pass or fail an interview, there is always something to worry about. The worrying/anxiety multiplies when I proceeded further in the interview stages. Now that I signed the offer and is pending background checks, my anxiety is off the roof as it itches closer to my starting date.

like
like

Can anyone shed some light on Area Manager position with Amazon in Houston, Tx? Specifically the Salary, work life balance etc. Also what is your experience with this position. Any insight will be helpful

like

If you’re going to AICP LA tomorrow night DM me. Let’s make this dream reality.

like

Hubs and I were planning to buy a house next year. Waiting to ensure we still have some cash in hand after the transaction and don’t end up house poor. Thinking now we should make our move sooner

like

Additional Posts in Data Analytics & Data Science

Can anyone please share what salaries for Data Analysts are like in Bangalore, India for someone with about 2-4 years experience? Roughly how much per year can Data Analysts for large organizations expect to make?

like

Open to Moonlight as an NLP researcher / developer. Currently working as a Data Scientist at Walmart (4+ YoE), 2 published papers in NLP + 1 in CV (Neurips). Will work for free if work is with an academic or concerns an altruistic cause like cancer, environmental, etc. Previous work experience in academics (graduated with research award)

like

Looking for sparring improving resume for getting interviews in global companies.

Background 10 years of data science/data experience (around 50 ds projects) with 5 years of manager/head of data science experience with P/L responsibility. Lead program creating 25M $ annual ML portfolio with 15x ROI within 1 year. I've sent approx 200 applications starting only 5 processes. Any thoughts? Looking only private companies.

Currently working as Principal AI & Data consultant in a Finnish company.

Post Photo

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

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

Hello All! Does anyone know of anyone companies doing an immediate hire for a Data Analyst. Or If anyone could help with a Referral. I’m currently a Data Analyst with Capital One but my contract is ending soon.

like

Can someone refer me to a DS position at their company if they’re hiring? I’m looking for a DS role in tech. YOE: 5+, located in Canada.

like

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

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

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

Hello everyone!
What would you choose between P&G, pwC and a small consulting firm for a data science internship. The three positions are based in Paris and in data science, I have to take a decision this week and I'm completely lost :/
I don't have any clear idea about what I would like to do after (sometimes I think about a phd but others I prefer consulting...)
Thank you so much for your help

Senior to Manager-level Data Scientists, what is the minimum set of skills and experience you require someone to have in order to train them to be a Data Scientist?

I have a handful of people from BI and Marketing who want to learn how to be a "Data Scientist" where some of them have stronger SQL knowledge and ability than others, but some of them have more exposure to languages like Python and R, and a little bit of machine learning exposure.

Appreciate the input in advance.

Hi all,
I graduated during Covid with a double major in business administration and business management with a minor in marketing and magically ended up in sales because I needed a job. I’m about to take a data analytics course to make an attempt to break into that field. I’m currently looking for a mentor to help guide me during this time. Also, if anyone is willing to look over my resume and give me tips on how to make it more presentable for recruiters in DA that would be very helpful. Thanks

like

We just brought a guy onto our team who specializes in Data Science and Machine Learning.

He's really the only guy on our BI team who has studied it and can do the work. Existing members of the team are interested in furthering their analytical skills and learning Machine Learning, but the new guy seems pretty closed off to showing them his work or teaching them.

The guy has worked hard; he went to top 10 schools for undergrad and grad, and has openly mentioned that the sacrifice...cont

like

Hi there,
I’m a bit newer to data science and recently read through a few academic case studies on ethical fairness in ML/modeling. Would love to start a thread to hear some more from data scientist/ML perspective.
The most harmful example I came across was bias in ML for the criminal justice system.

Is anyone currently in a