1.
Behavioral Question Preparation (STAR Method)
We'll use the STAR method (Situation, Task, Action, Result) to structure your answers.
Here are common behavioral questions they might ask, and how you can approach
them:
➤ “Tell me about a time you solved a difficult problem with data.”
• Situation: Briefly describe the scenario (e.g., during your performance analyst
support role).
• Task: What were you expected to solve?
• Action: Steps you took (e.g., conducted root cause analysis, cleaned data, used
Excel pivot tables).
• Result: What changed or improved? (E.g., increased validation accuracy,
reduced AHT.)
➤ “How do you handle tight deadlines or pressure?”
You could highlight how you maintained 100% quality in DCC/DCE while handling
backup PA tasks.
➤ “Tell me about a time you worked on a team project.”
Draw from your experience as a Program Manager or in your university leadership roles.
2. Technical Interview Prep
They’ll likely want to know you can work with data tools and do some analysis. Here are
example questions and how to prep:
➤ Excel-based Questions:
• How do you clean and transform data in Excel?
• Can you explain pivot tables, VLOOKUP/XLOOKUP, and conditional formatting?
• Do you know how to use Excel formulas to spot trends or errors?
Tip: Mention specific formulas you've used (e.g., IF, INDEX-MATCH, SUMIFS,
COUNTIFS, TEXT).
➤ Tool Familiarity:
If asked about SAP, AWS, Tableau, or SFS:
• Be honest if you're not deeply familiar, but say something like:
“While I haven’t had deep hands-on experience with AWS or SAP, I’ve worked
with large datasets and am confident in quickly learning new platforms. In
previous roles, I’ve successfully adapted to validation tools, custom systems,
and internal databases.”
➤ Scenario-based questions:
• “What would you do if you noticed discrepancies in a data report?”
Talk about checking the source, verifying formulas, consulting team leads, etc.
3. Presenting Yourself Confidently
Use this structure when they say: “Tell me about yourself.”
Keep it to about 1–2 minutes, and focus on:
1. Who you are professionally – (e.g., “I’m a data-driven individual with 3 years of
experience in data entry and performance analysis support…”)
2. What you’ve done – Highlight key experience (e.g., report generation, root cause
analysis, creating validation reference tools, Excel expertise).
3. Why you’re here – (e.g., “I’m excited about this opportunity at ASTRO because I
enjoy turning data into actionable insights, and I’d love to bring that skill to your
team.”)
4. Extra Tips
• Smile, be calm, and pause before answering—it shows confidence.
• If you don’t know something, it’s okay to say:
“That’s a great question—while I haven’t encountered that exact situation, here’s
how I would approach it…”
• Prepare a couple of questions to ask them at the end (e.g., “What are some key
projects the data team is focusing on this year?”)