Description
Daily Rate:
Circa £400-£450 per day (a status determination assessment has been carried out and the outcome placed the role outside IR35)
Location:
Remote/Client Site (as required)
Duration:
Initial 16-week contract
---
About Triad:
Triad is a leading digital and data solutions consultancy, recently awarded Digital Transformation of the Year at the Digital Technology Leaders Awards. We have a proven track record of delivering impactful work that benefits UK citizens.
---
Role Overview:
This project involves reverse engineering complex spreadsheets, documenting their functionality, and translating them into business requirements. The spreadsheets contain numerous formulas and VBA macros, with some VBA code written in German/Austrian.
The successful candidate will work closely with subject matter experts but will be responsible for deciphering the technical details independently.
---
Key Responsibilities:
*Reverse Engineering Spreadsheets:*
- Analyse and document the functionality of existing spreadsheets (ALR, UBA tool, ALAN, ETS analyst tool, registry upload functionality).
- Translate VBA macros, including those written in German/Austrian.
*Requirement Documentation:*
- Write detailed business and functional requirements.
- Identify and document business rules, calculations, and validations.
- Prepare solution-agnostic documentation for the upcoming bespoke development project.
*Stakeholder Engagement:*
- Collaborate with end users and subject matter experts to understand business needs.
- Facilitate and manage workshops to gather and refine requirements.
- Communicate progress and findings to the delivery manager.
*Project Management:*