Data Analyst

Posted 5 days ago by Sagacity Solutions Ltd
Easy Apply

As a Data Analyst at Sagacity Solutions, you will often work on client sites in multi-disciplinary project teams and under-take client work. You will be passionate and committed to seeing transformational change projects and programmes through to successful completion as time efficiently as possible for the ultimate benefit of both our clients’ and the Sagacity teams.

Tasks will include:

Data Sourcing

  • Define required datasets for analysis
  • Obtain data though available channels

o Work with Sagacity developers or client BI / technical teams

o Use client management information systems (e.g. Hyperion / Business Objects etc.)

o Query directly from source tables / databases

o Build from existing flat files / SharePoint repositories

  • Ensure secure transfer and storage of client data
  • Load and transform / manipulate data as required to get into a suitable format for analysis
  • Validate data quality or fix isolated issues as required

Analysis & Modelling

  • Data analysis and identification of key and emerging trends
  • Investigate key drivers and draw relationships between different items of information
  • Undertake business casing and scenario modelling
  • Use statistical techniques where appropriate to test and model predictive relationships
  • Identify actionable insight from datasets in response to business questions


  • Design and streamline processes to obtain and prepare regular and ad-hoc reporting
  • Utilise data visualisation software (e.g. Tableau) as appropriate
  • Design and prepare management information packs

Presentation & communication

  • Work with Sagacity team members to discuss and develop findings
  • Prepare material and communicate to summarise findings, using non-technical language as required by audience
  • Use commercial understanding & awareness to present findings, key trends, issues and potential solutions in context



Our Data Analysts have excellent communication, planning, prioritisation and organisational skills. They demonstrate strong commercial awareness, which promotes and protects the interests of both Sagacity and our clients alike. Key competencies and requirements include:

  • Excellent planning and reporting
  • Clear and transparent communication
  • High level attention to detail
  • Client relationship management
  • Logical and structured approach
  • Critical thinking and problem solving
  • Decision-making
  • Influencing, leading, negotiating
  • Team player
  • Conflict management
  • Adaptability
  • Stress tolerance
  • Presentable, professional, punctual
  • Responsible
  • Ability to travel throughout the UK to client site

Education, Training, Skills & Experience

You will have strong problem solving and quantitative skills, as well as a demonstrable ability to articulate complex and inter-connected concepts clearly. You will have good commercial awareness and the ability to understand and analyse key business drivers, and the impact they have, and make recommendations for change, for example, to mitigate risk or enhance business performance for a business.

You will have the ability to work to very tight deadlines, but also to manage your own time and deliverables whilst working on large projects. The ability to effectively prioritise and execute tasks in a high-pressure environment and to meet fixed deadlines is essential. Excellent communication skills are also required as you will liaise with senior professionals both within Sagacity and with our clients.

In the role, you will initiate and manage the regular review and interpretation of information and data. You will manipulate large amounts of data in Excel and use extraction and reporting tools. You will manage the delivery, commercial analysis and presentation of the data to the client.

You will ideally be educated to degree level in a numerate subject, and with strong A-levels (in mathematical/ scientific based subjects) and will have proven experience in undertaking detailed analysis in a variety of relevant industries and the ability to operate effectively in unfamiliar environments, remaining calm under pressure and agile in approach.

In order to be successful in this role, you should be able to demonstrate the following:

  • Ability to write succinctly and clearly
  • Experience of financial planning, analysis and scenario modelling
  • Comfort in building business cases
  • Agility - able to turn hand to a problem, resourceful
  • Problem solving & resourcefulness and ability to find an innovative approach to a problem
  • Ability to communicate findings of complex analysis to non-financial and non-technical stakeholders
  • Self-starting - ability to manage and prioritise your own workload
  • Desire to learn and improve skills

Desired Skills & Experience:

  • Commercial experience in relevant industries (Telcoms, Banking, Utilities)
  • Excellence in MS Excel including advanced Pivot tables
  • Experience of MS Access and other database tools
  • Experience of using to SQL to generate basic queries (more advance SQL skills beneficial)
  • Experience of business information solutions such as Business Objects or Hyperion beneficial
  • Experience of data visualisation tools such as QlikView / Tableau/MS PowerView beneficial

Required skills

  • Analytical Skills
  • Data Analysis
  • Management
  • Project Management
  • Stakeholder Management

Reference: 37080354

Bank or payment details should never be provided when applying for a job. For information on how to stay safe in your job search, visit SAFERjobs.

Report this job