Skip to contentSkip to footer

Intelligence Research Specialist Interview Questions

Salaries
Interviews

1,455 intelligence research specialist interview questions shared by candidates

1. Leadership Principles (Behavioral) i. Describe a time when you had to dive deep to come up with a solution.  – Follow-up questions included: Why did you choose that approach? What alternatives did you consider? What was the outcome? 2. Data Visualization i. You’re given a table with 3 columns. How would you visualize it?  – What types of visualizations would you use and why? – What would go on the X and Y axes?  – What filters would you apply? ii. Now, a fourth column is added to the table. How would your visualization strategy change? iii. Instead of using size for one of the variables in your viz, what if we used different symbols or shapes? Would that be better? Why or why not? iv. Given a sample visualization (image-based question), do you think it’s effective?  – Do you notice any errors or misleading design choices?  – Would you start the X-axis at 200 instead of 0? Why or why not? 3. SQL i. Write a query to return the top 10 and bottom 10 records based on certain conditions.  – This involved CTEs, joins, RANK(), and handling NULLs. ii. Calculate year-over-year churn rate and attrition.
avatar

Business Intelligence Engineer

Interviewed at Amazon

3.5★
Jun 20, 2025

1. Leadership Principles (Behavioral) i. Describe a time when you had to dive deep to come up with a solution.  – Follow-up questions included: Why did you choose that approach? What alternatives did you consider? What was the outcome? 2. Data Visualization i. You’re given a table with 3 columns. How would you visualize it?  – What types of visualizations would you use and why? – What would go on the X and Y axes?  – What filters would you apply? ii. Now, a fourth column is added to the table. How would your visualization strategy change? iii. Instead of using size for one of the variables in your viz, what if we used different symbols or shapes? Would that be better? Why or why not? iv. Given a sample visualization (image-based question), do you think it’s effective?  – Do you notice any errors or misleading design choices?  – Would you start the X-axis at 200 instead of 0? Why or why not? 3. SQL i. Write a query to return the top 10 and bottom 10 records based on certain conditions.  – This involved CTEs, joins, RANK(), and handling NULLs. ii. Calculate year-over-year churn rate and attrition.

Viewing 1211 - 1220 interview questions

Glassdoor has 1,455 interview questions and reports from Intelligence research specialist interviews. Prepare for your interview. Get hired. Love your job.