Candidates applying for Business Systems Analyst roles take an average of 41 days to get hired, when considering 3 user submitted interviews for this role. To compare, the hiring process at Santa Clara Family Health Plan overall takes an average of 30 days.
Common stages of the interview process at Santa Clara Family Health Plan as a Business Systems Analyst according to 3 Glassdoor interviews include:
Skills test: 40%
Phone interview: 40%
Group panel interview: 20%
Here are the most commonly searched roles for interview reports -
I applied online. The process took 3 weeks. I interviewed at Santa Clara Family Health Plan (Santa Clara, CA) in Feb 2024
Interview
Applied online through indeed.There were two rounds of interviews. First interview was the phone screening from Hiring Manager. Second round was SQL technical screening with hiring manager and other manager.He gave the remote access to write the queries. Database has 3-4 tables.They were 6-7 queries, completed in 40 mins , answered almost 80-90% right. He didn't ask any other questions.After few days I get a rejection email from the HR. I was very dissappointed,I was expecting third round .
Interview questions [1]
Question 1
SQL questions on joining three tables, youngest patient(MIN/Max) function, dates question on how many patients were active in 2019, count of claims denied
I applied online. The process took 2 months. I interviewed at Santa Clara Family Health Plan (San Jose, CA) in Apr 2023
Interview
HR reached out to me to schedule the first round with the hiring manager. During our first round, the manager did not show up for the call, he mentioned he forgot the call. After clearing the first round, the second round was a panel round with 4 IT managers and the hiring manager, none of the managers asked any questions, and they were even not ready to show their faces for a video interview. I was asked to solve some SQL questions through remote access, the goal was to complete all the SQL queries that were asked on a Zoom call, but while I was on the second question and working out the problem, the hiring manager abruptly stopped me and said we get an idea of your SQL skills and we can stop the interview process right away. He mentioned that they don't have any questions to ask and also did not let me ask any questions regarding the role.
I applied online. I interviewed at Santa Clara Family Health Plan
Interview
HR reached out to me to set up a phone interview with the manager. Phone interview with the manager was mostly the manager describing the role. Next interview was a panel-style through Zoom with 3 people such as the director and the managers. The interviewers asked technical questions about SQL and Tableau. They will ask you code through remote access. The interview felt rushed because the interview length is 1.5 hours which I think is NOT enough considering there were 3 people interviewing you.
Interview questions [1]
Question 1
Tell me about when scenario questions? Experiencing doing QA? SQL joining tables? Tableau IF THEN statements?