Required—advanced Excel: Direct/needs clarification. Evidence: weekly 45-person workbook using Tables, XLOOKUP, SUMIFS, and validation with measured correction change. Strong tool/workflow evidence, but the employer does not define “advanced.” Required—two years operational data: Direct if dates through application date meet two years; retail staffing and stock counts are operational data. Required—writing: Direct, weekly trading notes to area manager; content quality/sample not supplied.
Responsibilities: weekly capacity reporting—Direct via staffing workbook; variance investigation—Direct/transferable via stock-count differences; manager partnership—Direct with three store managers; process improvement—Direct via revised checklist and rota correction result; director recommendations—Weak/implicit, because area-manager notes do not establish recommendations to director level. Preferred SQL/Power BI—Missing; logistics—Transferable retail operations, but not explicit logistics.
Truthful edits: lead the staffing bullet with capacity purpose, retain exact formulas and 12→5 result; clarify what the trading notes contained if verified; do not add SQL, Power BI, “advanced,” or director presentation. Evidence gap to gather: workbook scale/refresh/quality checks and one written recommendation example. Clarify before major effort: sponsorship, required Manchester days, and depot travel area. Interview priorities: explain correction metric, investigation method, stakeholder handling, and boundaries of current BI experience.