Junior Intelligence Analyst Interview Questions

5,593 junior intelligence analyst interview questions shared by candidates

Technical questions: 1.How comfortable are you with using R and Python? 2.Give me a detailed idea of the projects you had done in Data Analytics, where did you get the data. 3.Which data formats you are familiar with (csv,tsv,web data etc) 4.Tell me about how good you are at using excel formulas, macros, pivot tables, VBA 5.How much you know about SQL, give me an overview what you can do with SQL. 6.What software development languages you are familiar with. General questions: 6.Why should we hire you among all the other candidates?What is special about you as compared to other candidates. 7. How much time you can commit to AMA
avatar

Business Intelligence Analyst

Interviewed at Alberta Motor Association

2.9
Jun 23, 2019

Technical questions: 1.How comfortable are you with using R and Python? 2.Give me a detailed idea of the projects you had done in Data Analytics, where did you get the data. 3.Which data formats you are familiar with (csv,tsv,web data etc) 4.Tell me about how good you are at using excel formulas, macros, pivot tables, VBA 5.How much you know about SQL, give me an overview what you can do with SQL. 6.What software development languages you are familiar with. General questions: 6.Why should we hire you among all the other candidates?What is special about you as compared to other candidates. 7. How much time you can commit to AMA

1. Describe a situation where you resolved a conflict as a team. 2. How to join tables SQL in two ways 3. Describe what a primary key is in SQL 4. Difference between a list and an array in Python 5. Describe what a module is in Python and explain one module of your choice
avatar

Bussiness Inteligence

Interviewed at TD

3.8
Mar 16, 2022

1. Describe a situation where you resolved a conflict as a team. 2. How to join tables SQL in two ways 3. Describe what a primary key is in SQL 4. Difference between a list and an array in Python 5. Describe what a module is in Python and explain one module of your choice

They asked about my experience working with clients and stakeholders and how I manage multiple tasks. I was also given SQL queries and asked to identify errors in the code. Additionally, they presented three tables without common columns and asked how I would join them. In the Python section, I was asked to write a function, but I don't recall the exact question.
avatar

Business Intelligence Analyst

Interviewed at TD

3.8
Mar 28, 2025

They asked about my experience working with clients and stakeholders and how I manage multiple tasks. I was also given SQL queries and asked to identify errors in the code. Additionally, they presented three tables without common columns and asked how I would join them. In the Python section, I was asked to write a function, but I don't recall the exact question.

Viewing 2881 - 2890 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 5,593 interview questions and reports from Junior intelligence analyst interviews. Prepare for your interview. Get hired. Love your job.