Skip to main content

Jobs
Companies
Extension
Resources
About

Loading page

Join the community

Get new openings in your feed

We post fresh jobs and internships on Instagram, YouTube and X. Every post links back here, and from here straight to the employer’s official application page.

Instagram@jobwithjoe(opens in a new tab)
YouTube@jobwithjoe(opens in a new tab)
X@jobwithjoe(opens in a new tab)

Free job discovery for India and remote roles open to India: internships, fresher jobs and every level after. Each listing links to the employer's own application page.

Jobs with Joe is not a recruiter and cannot promise interviews, offers or jobs.

Logos provided by Logo.dev. Company names and logos belong to their owners and identify the employer only.

Crowd illustrations: Open Peeps by Pablo Stanley (CC0).

Contact: jobwithjoe@gmail.com

Browse jobs

Internships
Fresher jobs
Remote jobs
Jobs in Bengaluru
Jobs in Hyderabad
Jobs in Pune
Jobs in Mumbai
Jobs in Chennai
Jobs in Delhi NCR
Jobs in Kolkata
Jobs in Ahmedabad

Jobs
Companies
Extension
Resources
About
Saved jobs

Scam check
Resume studio
Job alerts
Referrals
Application tracker

No-fee pledge
How we verify
How it works
Changelog
Open stats
Privacy
Terms
Contact

Home
Jobs
Assistant Vice President, Project Management Office
Interview prep

State Street

Interview prep: Assistant Vice President, Project Management Office

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.

Question bankexcelpower bi

Practice questions

Skills

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

The role

How do you keep a cross-team programme on track when a dependency slips?
This kind of role

The company

What do you know about State Street's products and customers?
State Street

About you

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

Checklist

Read the full job description twice and highlight every requirement you meet.
Research State Street: what it sells, who its customers are, recent news.
Revise the basics of excel, power bi, and prepare one example of using each.
Prepare 3 STAR stories (Situation, Task, Action, Result): a success, a conflict, a failure.
Tailor your resume to this job, and make sure every link on it works.
Be ready to explain your notice period and why you're moving.
Prepare 2 or 3 questions to ask the interviewer about the team and the work.
Test your camera, mic and internet the day before for an online interview.
Remember: a real employer never asks you to pay for an interview or a test.

Back to the job