
Johnson Controls Business Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 20 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Johnson Controls.
Systems Analyst
A technical review of your skill sets and work experience was conducted. You were interviewed by 3 staff members plus the Manager. You were asked to describe situations where you multi-tasked, and how you prioritized work assignments. You were also asked to describe workflow improvements and data quality review examples.
- Can you describe instances of multitasking?
- How do you handle prioritizing your work?
- Tell me about workflow improvements you've made.
Business Analyst
I got a call from a consultancy and we scheduled an interview. There were 2 technical rounds, 1 HR round, and another round for salary discussion. The technical and HR rounds went really well and were quite easy, with friendly interviewers asking direct questions. However, the salary discussion was terrible and didn't meet my expectations. The person was also quite rude, so I declined the offer.
- Can you explain the difference between a calculated column and a measure in Power BI?
- What is the difference between partition by and group by in SQL?
- Could you solve the rat and poisonous milk puzzle?
IT Analyst
So, for this data analytics intern role, the interviewer hit me with some data science and data analytics fundamentals. They also had me map out the SQL query logic on paper and threw in a puzzle at the end.
- Could you walk me through your projects?
- Can you explain the fundamentals of data science?
- Can you explain the fundamentals of data analytics?
Johnson Controls Business Analyst Interview Questions
Quoted word for word from Johnson Controls interview reports.
“What is the difference between partition by and group by in SQL?”
Read reports →“Can you explain the difference between a calculated column and a measure in Power BI?”
Read reports →“Could you solve the rat and poisonous milk puzzle?”
Read reports →“Can you explain the fundamentals of data science?”
Read reports →“Can you explain the fundamentals of data analytics?”
Read report →“Could you write the logic for an SQL query on paper?”
Read report →“What information do you have regarding our building efficiencies operations in Hong Kong?”
Read report →“Can you list the reports you have created?”
Read report →“What is your English proficiency level?”
Read report →Formats, difficulty and experience
Across all 20 Johnson Controls interview reports.