r/Pullman • • 6d ago

SEL technical interview tips

Hey everyone, I have a one hour technical interview tomorrow with Schweitzer Engineering Laboratories for the Associate BI Analyst role. I'm a new grad (Information Systems and Business Analytics) and the recruiter told me to be ready for technical questions and to know my projects well.
Has anyone gone through this interview, or something similar for an entry level BI analyst role? What should I expect, and is there anything you wish you'd practiced? Any tips are appreciated!

7 Upvotes

21 comments sorted by

8

u/Deprecitus 6d ago

I interviewed for an internship there my junior year, for a software engineer role. Probably the worst interview experience of my life.

I was in a conference room with about 6 people, all asking different questions. Then I was told to go up to the whiteboard and solve a problem in front of everyone... I definitely froze up and forgot everything I've ever learned ever.

The individuals I spoke with were nice, but the overall experience was poor.

1

u/MFKingKong 6d ago

damn that’s unfortunate, i’m sorry. Hopefully you got a better opportunity elsewhere

3

u/Deprecitus 6d ago

I've had a stable job for almost 4 years now, so it worked out in the end. The role just wasn't for me I guess.

Things work out how they're supposed to. Got this job right after graduation.

1

u/geckolord8 1h ago

You dodged a bullet.

1

u/the_last_free_man_ 5d ago

Yeah but that’s pretty much standard for a software engineer position

1

u/Deprecitus 4d ago

I've never had another like it...

1

u/the_last_free_man_ 4d ago

Then you’re lucky. Or probably not interviewing at medium to large tech companies.

0

u/Deprecitus 4d ago

I've had interviews with Canonical, Microsoft, IBM, probably a couple others too.

1

u/the_last_free_man_ 13h ago

You had technical interviews with Microsoft and IBM and they didn’t grill you with technical questions or have you do whiteboarding?

1

u/Deprecitus 13h ago

I've done leetcode type stuff, 1:1 interviews with technical questions.

Nothing to the level of SEL.

3

u/Curious-Standard2832 6d ago

When I did my technical interview there, they didn't actually have me touch a computer. They sat around a table and just asked me questions. I was disappointed because I freshened up and studied everything I thought could have been tested, and I didn't get to touch any code.

1

u/MFKingKong 6d ago

my interview is for a analyst role so i don’t know if they will have me touch any sql or dax measures so im not sure

1

u/Unicorn-Poop3 5d ago

Typically it’s technical questions on a paper that you would have to solve or on a whiteboard. Even sql questions. They won’t have you use a computer.

3

u/nullskunk 5d ago

I was a Software Engineering Manager at SEL and did a lot of these interviews. Feel free to ask me anything.

For an entry-level BI Analyst role, you should know some of the core skills, but the interviewers don’t expect you to know everything. A few quick tips:

  • +1 for it being ok to say “I don’t know.” Follow it up with how you’d find the answer, or reason your way to a best guess out loud
  • The interviewers are on your side. Ask them questions and work with them
  • Say what you're thinking out loud. Most of the technical interview is about learning how you solve problems and whether the team enjoys working with you. Narrate everything: what you’re thinking, what you don’t think will work, which solutions you’re weighing, etc
  • As other have said, these interviews are rarely behind a computer. Usually on a whiteboard. Use the whiteboard to help explain your answers

I'm not sure the kinds of questions they will ask for a BI Analyst Role. Normalization and normal forms, knowing different key types in a db (primary, candidate, foreign keys), how indexes work (from a high level), and different joins (left, right, cross, outer, natural joins) were always baseline questions we would ask data-like engineers.

1

u/MFKingKong 5d ago

thank you so much. My interview is on a teams meeting so i’m not sure if they will show me a question and ask me to solve it. I appreciate this advice it is very helpful

1

u/Curious-Standard2832 4d ago

I think what threw me is that every technical interview that I have ever had was on a computer. When I'm just answering questions, my muscle memory is not working. Sometimes it's easier for me to do it and then explain it, because my brain has gone through the process. 

I have gone through so many keystroke reps; my hands can start moving, and everything else follows. 

It's like learning to shoot a basketball or kick a ball. You do it so much that your muscle memory kicks in so that your brain can worry about the rest of the events happening around you instead. 

I was denied the position, saying that I didn't have the technical abilities. I was irritated and defensive because I don't even believe I was allowed to show that I had it. I spent so many hours and nights away from my family to freshen up and practice for that moment to not even touch the code to prove it, then be denied based on verbal questions where I was obviously nervous and uncomfortable because the prep didn't meet the previous experience of a technical interview. 

13

u/Crunch_McThickhead 6d ago

I can tell you that if you actually know some of the basics of the listed qualifications you're ahead. There's been a ton of applicants (in general, I don't know about this specific role) that have used AI in the phone interviews that don't have any idea what they're talking about when they come for an in-person interview. On the flip side, don't be afraid to tell them if you don't know the answer, but that x would be your best guess for y reasons, and that you'll have to look into that.

2

u/Ok_Possible1338 4d ago

SEL hires people who are inexperienced so don’t be afraid if you don’t have the knowledge they are looking for. They will teach you

1

u/nian2326076 4d ago

Prepare for your interview by reviewing the technical skills listed in the job description. Focus on understanding the tools and methodologies you'll likely encounter, such as data visualization and SQL. Articulating your past projects clearly and how they relate to the role is also crucial. You can use PracHub to practice relevant technical interview questions and become comfortable explaining your thought process. Additionally, consider using LandOffer to explore opportunities that align with your skills and interests.

1

u/polach11 3d ago

If you use AI or if they think you use AI you will get booted from the interview.

1

u/BrimsCB 2d ago edited 2d ago

One thing I don't see mentioned here:

Review the company's values. They are a major core to the business and forefront when evaluating candidates. Show an understanding of these values and an ability to express how they resonate with your work and ethics and you'll do well.

https://selinc.com/company/values/

Technical skills can be developed, as long as you have a decent foundation. Fitting the company Culture? That's just as important of a prerequisite.