Branch Insurance interview questions

The process had 4 stages: 1. Recruiter Screening (30 mins) – General discussion about my experience, skills, and interest in the role. 2. Take-home Assessment – assignment focused on querying and data insights 3. Hiring Manager Interview – Focused on technical skills (SQL, query optimization, joins, handling duplicates, aggregation). The questions were pretty standard, but there was minimal discussion about my work experience or background. The interviewer seemed somewhat disengaging in the technical round. 4. Final Interview – behavioral and culture fit questions. Observations: The company does not follow Agile methodology, which may indicate a less structured workflow. Experience with dbt was discussed. I didn't have it. The feedback mentioned that they went with a candidate more closely aligned, likely due to my lack of dbt experience.

The interview started with a 30 minute Zoom call with the talent acquisition specialist. I heard back very quickly that they would like to move forward. The next step was a presentation/assignment that took 45 minutes. I emailed my thank you after and didn't hear back. Followed up and was told they would be reaching out with the next steps soon. I then received an automated rejection email that wasnt personalized at all. I felt a little lead on when I got the email saying they would reach out with the next steps soon, because it made it seem like I would be moving forward in the process, so it was a shock when I got the rejection.