As a mid-level analyst, describe an example where you influenced a data-driven decision or improved a team process (mentoring, documentation, automation). What actions did you take, how did you get stakeholders on board, and what measurable impact resulted?

I was a mid-level analyst on a 7-person insights team responsible for weekly editorial performance reports. The process was manual—about 16 hours/week—and produced frequent reconciliation errors that delayed decisions. I built an automated SQL + Airflow pipeline and templated dashboards, created a single living wiki for the process, and ran three hands-on training sessions while mentoring two junior analysts. To get stakeholders on board I presented baseline metrics (16 hrs/week, ~28% reconciliation errors), demoed a working prototype, and proposed a six-week pilot with editorial and product leads. After rollout, reporting time dropped from 16 to 3 hours/week (an 81% reduction), errors fell 60%, and 90% of stakeholders were using the dashboards within four weeks. That freed roughly 676 hours/year for deeper analysis and improved our ability to deliver timely, impartial stories.