Describe a time you used data to solve a business problem or improve a process.
Why This Is Asked
To gauge hands-on experience with data manipulation and whether the candidate can think analytically about business operations, core to a BA role at SMIC's corporate center.
General Approach
Choose an example that highlights a methodical approach: how you defined the problem, structured the data, and measured the improvement.
Sample STAR Answer▾
Situation
During an internship at a local food manufacturing company, the accounting team was manually reconciling supplier invoices, causing delays.
Task
I was asked to find a way to reduce the reconciliation time.
Action
I used Excel to organize invoice data by supplier and date, then created a VLOOKUP-based template to match purchase orders with delivery receipts. I recorded a macro to automate the repetitive steps.
Result
The team reduced reconciliation time from three days to one, and errors dropped by about 20 percent. My supervisor praised the simple tool and asked me to document the steps for other interns.
Attempt Your Answer
Write your own answer, then get instant AI feedback graded against:
- •STAR Structure
- •Specificity & Numbers
- •Ownership Language
- •PH Workplace Context
Log in to get AI feedback on your answer.
Log In