Senior Data Analyst

Description

Auto-generated position for Senior Data Analyst

Interview Questions (17)

Q1Can you describe a project where you utilized SQL to analyze large datasets and what insights you gained from it?
Experience
Q2Can you describe a time when you identified a significant trend in data that led to a strategic change in your organization?
Behavioral
Q3How do you approach cleaning and validating raw datasets?
Technical
Q4Describe a project that you worked on where you had to align multiple stakeholders with conflicting priorities.
Behavioral
Q5Write a query to pull users who made more than 2 purchases in the last month.
Technical
Q6What’s the difference between INNER JOIN, LEFT JOIN, and RIGHT JOIN?
Technical
Q7Use a window function to find the top 3 performing campaigns by ROI.
Technical
Q8Explain p-value in simple terms.
Technical
Q9How would you test if a new landing page is performing better than the old one?
Situational
Q10What is the difference between correlation and causation?
Technical
Q11If website traffic drops by 30%, how would you investigate?
Situational
Q12Which metrics would you track to measure the success of an email campaign?
Situational
Q13How would you estimate customer lifetime value for a subscription service?
Situational
Q14How do you build a dashboard in Tableau/Power BI?
Technical
Q15Show how you’d present CTR, CAC, and ROI to a non-technical manager.
Technical
Q16Tell me about a time when your analysis influenced a business decision.
Behavioral
Q17How do you handle stakeholders who disagree with your findings?
Behavioral