OA - CodeSignal 14excel+1sql DC - Airline Investment
Senior Data Analyst Interview Questions
2,902 senior data analyst interview questions shared by candidates
I did only tech assessments
behavioral question, SQL cases, and past project experience relating to SQL
Most of the interviews were case studies and digging deep into problems and the product. So do your research and show up ready to think on the fly, ask questions, and collaborate. Know your SQL for the live coding. CTEs, different JOINs, COALESCE, etc. And know stats from a data perspective (how to deal with different situations in data like outliers and averages, etc.)
1. tell me about a time when you went out of your way to help a teammate?
Describe your prior work experience and the data analysis part of it
Tell me a time how did you handle a challenge?
Walk me through your resume
Tell me about your most recent experiences
-compare json v csv files -take home: create model to measure performance score based on component additions -how do you find fastest 3 horses from 25 with no watch -how can you improve citibikes -weird isolated covid data question where say covid cases are doubled every 3 days.. provided all data collection was uniform and fair, what would you say as a data scientist to those wanting to know about future results -what is standard error (i unfortunately couldnt understand the interviewer's accent on this one, but later figured out what he said) -looking at a sample set of data, make a SQL query to pull time spent on working on a particular component that was opened and saved.... **use 'lead()' and 'lag()'** otherwise you're 'wrong'
Viewing 2761 - 2770 interview questions