Summary: The Data Analyst role within Central Government involves reverse engineering complex spreadsheets, documenting their functionality, and translating them into business requirements. The successful candidate will work independently while collaborating with subject matter experts to ensure accurate requirement gathering and documentation. The position requires advanced Excel and VBA skills, particularly in translating VBA code written in German/Austrian. This is a remote role with an initial contract duration of 16 weeks.

Key Responsibilities:

• Analyse and document the functionality of existing spreadsheets.
• Translate VBA macros, including those written in German/Austrian.
• Write detailed business and functional requirements.
• Identify and document business rules, calculations, and validations.
• Prepare solution-agnostic documentation for the upcoming bespoke development project.
• 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.
• Plan, scope, and manage own workload independently.
• Follow an iterative process to progressively refine requirements.
• Report progress against the 3-month time frame.

Key Skills:

• Advanced Excel skills, including extensive experience with formulas and VBA.
• Ability to understand and translate VBA code (German/Austrian VBA knowledge is a plus).
• Experience writing detailed business and functional requirements.
• Strong documentation skills for business rules, calculations, and validations.
• Experience working with end users to gather requirements and manage expectations.
• Strong workshop facilitation skills.
• Ability to work independently and manage workload efficiently.
• A structured and meticulous approach to documentation.
• Iterative process skills, refining requirements over time.
• Proven experience working on central government projects, with an understanding of government operations, regulations, and standards.

Salary (Rate): £450

City: City of London

Country: UK

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: Mid-Level

Industry: IT