State Street
Practice questions for the skills this job lists, plus common questions for any interview. These are for practice: we don’t know the employer’s actual questions.
Explain optionals and how you safely unwrap them.
Swift
When would you use XLOOKUP or INDEX/MATCH, and how do pivot tables help summarise data?
Excel
What is DAX, and how do measures differ from calculated columns?
Power BI
Tell me about a dataset you cleaned. What problems did you find?
This kind of role
How would you explain a model's result to a non-technical manager?
This kind of role
What do you know about State Street's products and customers?
State Street
Tell me about yourself in two minutes, focused on this role.
About you
Why this company, and why this role?
About you
Tell me about a time you disagreed with a teammate. What happened?
About you
Describe a time you failed or missed a deadline, and what you changed afterwards.
About you