Who are you going to be in 5 years later?
Senior Data Analyst Interview Questions
2,903 senior data analyst interview questions shared by candidates
Nowadays behavioral questions for this role are almost always 1) accomplishment 2) failure 3) help others
q. Tell me about your background. q. why thus job?
Assessment using Python and need to complete the assessment within 5 days
Phone interview: Technical terms from the resume such as what is PCA, A/B testing, difference between A/B and multivariate Onsite: go through resume some basic sql join question some basic R syntax asked if each of the models mentioned in resume were supervised/unsupervised how would you go about to figure out potential customers, what all data points? why discover (all asked) decision trees, regression ques a ton of behavioral questions
Technical interview questions are based around your prior work as it relates to the job description.
walk me through your resume.
Experience in Data Analysis. How to handle large volumes of data?
Tell me about a time when you worked with a stakeholder
Screening Round – SQL & Data Visualization: 1. Easy to medium SQL questions focused on filtering, joins, and aggregations. 2. What checks would you perform to ensure data quality and cleanliness? 3. How to compare two tables to confirm if they have the same data. 4. Given a table with one categorical and two numerical columns, how would you visualize it? 5. What chart would you use to analyze correlation? SQL (Live or HackerRank format) 1. Table: Cust_visit(transaction_id, transaction_date, customer_id, total_amount, total_unit) Question: Identify premium customers who spent at least $300 and had at least 2 transactions in the past 3 months. 2. Tables: transactions(transaction_date, customer_id, product_id, sale) products(product_id, product_name, department) Question: Identify cross-department customers who have purchased from every department in the products table. 3. Tables: shipments(shipment_date, shipment_id, package_type, warehouse_id, customer_id, num_items, country) returns(return_id, return_date, customer_id) Question: Find the number of customers who had both a shipment and a return in the last 30 days. Final Round – Behavioral Focused on real-world experience: 1. TMAY 2. What types of analysis do you work on 3. What kinds of dashboards have you built - Follow-up questions around tools, business goals, and challenges
Viewing 2381 - 2390 interview questions