None
Patrick County Public Schools
Data Analyst (Central Government)
Description
Position: Data Analyst (Central Government)
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:
- Plan, scope, and manage own workload independently.
- Follow an iterative process to progressively refine requirements.
- Report progress against the 3-month time frame.
Technical Proficiency
Essential Skills & Experience:
1. Advanced Excel skills including extensive experience with formulas and VBA.
2. Ability to understand and translate VBA code (German/Austrian VBA knowledge is a plus).
Requirement Gathering:
1. Experience writing detailed business and functional requirements.
2. Strong documentation skills for business rules, calculations, and validations.
Stakeholder Management:
1. Experience working with end users to gather requirements
2. Manage expectations.
3 .Strong workshop facilitation skills.
Project Management:
1 .Ability to work independently
2 .Manage workload efficiently.
3 .A structured
4 .Meticulous approach to documentation.
5 .Iterative process skills refining requirements over time.
Government Experience:
Proven experience working on central government projects with an understanding of government operations regulations standards.
Other Information
If this role is of interest to you or you would like more information please contact Ryan Jordan or submit your application now.Triad is an equal opportunities employer welcomes applications from all suitably qualified people regardless of sex race disability age sexual orientation gender reassignment religion or belief.Triad Group Plc acts as an Employment Business for this contract position.