Kingswood Group

Job Description

  • Job Title: Business Analyst / Systems Administrator (FTC)
  • Location: Chelmsford/Hybrid 3 days in office
  • Contract: 12-Month Fixed Term Contract
  • Department: HR / IT
  • Industry: Legal / Professional Services

Key Responsibilities:

  • Extract and analyse HR data to produce regular and ad hoc reports for management and leadership teams.

  • Maintain and manage data integrity across HR systems.

  • Use advanced Excel skills (including VLOOKUPs, Pivot Tables, and complex formulas) to manipulate and analyse data.

  • Write and execute SQL queries to support data extraction and reporting needs.

  • Collaborate with HR, IT, and third-party vendors in the migration to a new HR system, assisting with data mapping, cleansing, and validation.

  • Troubleshoot system issues and support end-users as needed.

Key Requirements:

  • Proven experience in a business analyst, systems administrator, or data/reporting role. HR system experience is desirable but not essential.

  • Strong proficiency in Microsoft Excel (including VLOOKUPs, Pivot Tables, and formulas).

  • Working knowledge of SQL for querying and reporting.

  • Experience in data migration or supporting system transitions is highly advantageous.

  • Strong attention to detail and excellent communication skills.

Skills & Experience

  • Proven experience in systems administration, ideally within HR or professional services.

  • Knowledge of management systems 

  • Strong understanding of process mapping methodologies and experience in automating workflows.

  • Familiarity with BI tools and reporting platforms.

  • Experience with system configuration, optimisation, and integration.

  • Strong analytical and problem-solving skills with the ability to identify process improvements.

  • Excellent communication and stakeholder management skills.

  • Ability to work collaboratively in a fast-paced, global environment.


Please enter First Name
Please enter Surname
Please upload CV/Resume
Please enter Email
Please enter Phone
Covering Letter is required.