DREAM Interview Questions
& Process

it's good and a little hard, with many technical tests and lots of questions, also asking about internship experience. First, submit your resume, cover letter, and portfolio. HR will review and shortlist based on qualifications. Then, there's an initial HR interview (15-30 mins) via phone/video to check your background, communication, and if you fit the culture. They'll ask things like 'Tell me about yourself,' 'Why this role?', 'What do you know about us?', 'Salary expectations?', and 'Experience with SQL/Python/Power BI?'. After that, a technical assessment (30-60 mins) as an online test or take-home assignment to see your skills in data analysis, SQL, Python, Excel, or visualization tools. Tasks could be writing an SQL query for top products, cleaning and analyzing data with Python or Excel, creating a dashboard, or interpreting trends.

I had a phone call with Donna Choi Ellis, the Manager of Recruitment. It wasn't a great interview; they didn't ask thoughtful, high-level strategic questions. Many questions felt like they were just checking boxes, like "How do you stay organized?" It was off-putting, and she didn't seem to understand the role well enough to ask or answer questions. The question about DEI was insulting, especially coming from a Latina woman with extensive experience working with BIPOC and being a first-generation individual myself. It felt like she didn't grasp the context. They need better recruitment training. It didn't feel like a conversation; they kept asking the same questions in different ways. Good luck.

The hiring process wasn't bad, and everyone I met was friendly and easy to talk to. Since it was an entry-level role for college students, it wasn't too demanding for our experience. They asked about my past work experience, specifically if I had experience teaching and supervising children. I was offered the position, and the actual job turned out to be less demanding than described. They were looking for candidates with good character. The job involved supervising children on field trips, assisting with their English and writing assignments in class, and helping with other tasks as needed by supervisors.

The interview process was okay, but they asked me to do a presentation that didn't make sense. They wanted a presentation on creating college lists, but asked me to present to 9th-10th graders, which seemed odd since list creation is typically for 12th graders. They also had me print out materials for the presentation, costing me $89, which I felt they could have handled themselves. As a new school, they seemed to lack a clear system for college readiness. I decided against working there when the director of college counseling admitted he didn't even want that role and had applied for HR, getting the director position instead. For those experienced in college advising, I'd advise waiting until they establish a better system, as they appear to be still figuring things out.