Massachusetts Bay Transportation Authority Data Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 5 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Massachusetts Bay Transportation Authority.
Massachusetts Bay Transportation Authority
Data Analyst
Entry Average Negative experience No offer 1 round
Interview process
Take home
Interview formats
Technical
communication was not good, got a text 2 weeks later asking me to do an Excel assessment. Instructions were not clear until the assignment came via email, at which point I was told I could use SQL if I imported the CSVs myself. The questions themselves are okay, but the tools are old. If SQL or Python is an option, it should be through official links so I don't waste time setting it up. Using Excel for these assessments is a bad idea.
Confirmed questions1 question
- Are you interested in this position and would you like to complete the Excel assessment?
Massachusetts Bay Transportation Authority
Data Analyst
Entry Easy Positive experience Accept offer 1 round
Interview process
Recruiter call Technical screen Onsite Offer
Interview formats
Behavioral Technical
It was a smooth behavioral interview with the manager, and they were very friendly. The whole process took about two weeks, but I was eager to hear back. There was only one round, which was great. The questions were typical, asking about my experience.
Confirmed questions1 question
- Can you walk me through your background?
Massachusetts Bay Transportation Authority
Data Analyst
Entry Average Negative experience No offer 2 rounds
Interview process
Recruiter call Take home Background check
Interview formats
Technical
HR first pinged me via text and asked me to send my resume, even though I'd already attached it to my application. Then, I had to do an hour-long Excel test. After that, I was totally ghosted by HR. I don't think I bombed the assessment, but maybe it was bad enough that they just decided to ignore me.
Confirmed questions3 questions
- Could you analyze this Excel dataset of train operations, looking at things like travel time and delays?
- Please plot your findings from the data.
- Based on your analysis, can you tell a story about what you discovered?
Massachusetts Bay Transportation Authority Data Analyst Interview Questions
Quoted word for word from Massachusetts Bay Transportation Authority interview reports.
“Could you analyze this Excel dataset of train operations, looking at things like travel time and delays?”
Read reports →“Which software have you used the most?”
Read reports →“Could you describe any challenges encountered when working with extensive datasets?”
Read reports →“Based on your analysis, can you tell a story about what you discovered?”
Read reports →“Are you interested in this position and would you like to complete the Excel assessment?”
Read report →Formats, difficulty and experience
Across all 5 Massachusetts Bay Transportation Authority interview reports.