We are seeking an MS Excel Package Subject Matter Expert (SME) to support a UK-based client. The role requires deep expertise in designing, developing, and optimizing Excel-based solutions, including advanced formulas, macros, VBA, and integration with external data sources.

The SME will work closely with business stakeholders to automate processes, create dynamic dashboards, and ensure Excel models are scalable, accurate, and user-friendly. Strong problem-solving skills and the ability to translate business requirements into efficient Excel solutions are critical.

Key Responsibilities

1. Develop and optimize advanced Excel models, templates, and tools for reporting and analytics.
2. Create dynamic dashboards with pivot tables, charts, Power Query, and Power Pivot.
3. Write and troubleshoot VBA macros for automation and process improvement.
4. Integrate Excel with external systems/databases where needed.
5. Conduct data analysis and deliver actionable insights.
6. Provide guidance, training, and support to client stakeholders on Excel best practices.
7. Ensure quality, accuracy, and compliance of Excel solutions with business standards.