Tell me about a time where you mentored a colleague

On my last team, an intern was contributing to a small feature in an area I had worked on a lot, and I noticed they were getting stuck whenever a test failed. Instead of just fixing the failures with them, I asked them to show me how they were debugging so I could understand where the process was breaking down. I realized they were making guesses too early, so I walked them through a simple step-by-step way to narrow down the issue and then had them try it on the next failure while I watched. I checked in again the following week, and they were able to come to me with a likely root cause and evidence instead of just saying the test was broken. By the end of the internship, they were debugging most issues on their own and even added a note to our team onboarding doc with the approach that had helped them.

A new product analyst on my team needed to produce weekly funnel reports but had limited experience writing SQL against our production schema, which was intimidating for them. I offered to run three short pairing sessions where I explained the most important tables, showed safe ways to run queries against a read-only replica, and walked through a few common mistakes that caused incorrect results. After each session I gave them a small exercise and a template query they could reuse, and I reviewed their first few reports with constructive comments. I also created a one-page cheat sheet with the standard joins and date functions we use. Within a month they were independently shipping accurate dashboards, and they later caught a data regression themselves that saved us from making a bad product decision. The experience felt rewarding because I helped a teammate be confident and reduce our reliance on engineers for routine analytics.