Careers Image 1440px_By_600px

Business Intelligence Analyst Chelmsford, Essex £35,000 to £37,000

Business Intelligence Analyst

Location: Chelmsford, Essex |
Salary: £35,000 to £37,000 |
Posted: 9 Feb 2024 |
Closes: 8 Mar 2024 |
Job Type: Full Time and Permanent |
Business Unit: Health Services |
Region / Division: UK & Ireland |
Reference: 15312

Role Responsibility:

Business Intelligence Analyst 

Chelmsford, Essex

£35,000 to £37,000 per annum

Full time - 40 hours per week 


We are seeking a Business Intelligence Analyst to joins its expanding team based in  Chelmsford. You will be joining a team who are broadly responsible for the reporting and analysis to support in decision-making. The company offers trusted security advice, risk mitigation strategies, secure support and integrated solutions for strategic clients or those operating in complex or sensitive environments.


  • Interoperate data and produce scheduled and ad-hoc reports for both internal and external stakeholders, areas include business performance, HR and Governance.
  • Perform in-depth data analysis to identify trends and highlight issues, support the management in making better business decisions.
  • Write T-SQL codes in the database to collect and manipulate the data for analysis.
  • Design and create new dashboard/ tracker/ report in Google Sheet as per business requirement.
  • Review and optimise existing T-SQL codes and Google Sheet/ Excel reports, to minimise the amount of manual input and enhance data accuracy.
  • Create new reports and manage/ review existing reports in the SSRS as per business requirement.
  • Opportunity to perform further meaningful analysis using various tools e.g. Looker Studio

The Ideal Candidate:


  • Advanced Google Sheet and Microsoft Excel skills.
  • Working knowledge of database (SQL).
  • Working knowledge of SSRS.
  • (Desirable) Working knowledge of Looker Studio or other dashboarding tools (i.e. Power BI, Tableau).
  • (Desirable) Experience performing statistical analysis and understanding of statistical principles.
  • (Desirable) Familiar with ETL concepts and processes,
  • Other Microsoft and Google tools e.g. Google Docs, Slides, etc.




  • Company pension scheme with employer contributions

  • G4S Life Assurance Scheme

  • Charity work- Match-it  and Payroll Giving

  • Employee Assistance Programme Scheme  (Confidential Counselling Services, 24/7 support specialising in health and medical )

  • Discounts on high street shops and brands including several leading high street brands, retailers and travel suppliers

  • Refer a Friend Scheme 

  • Progression, training and development opportunities.

  • Subsidised healthcare plan


Why G4S?


G4S Patient Transport Services is one of the UK’s largest Non-Emergency Patient Transport providers, carrying out over 50,000 journeys on behalf of the NHS every year. With 12 operational bases across the UK and a dedicated call centre, we employ over 720 members of staff to deliver safe, caring, high-quality patient transport.

At G4S, we understand that our people are our greatest asset and an essential part of our long-term business strategy. As such we are committed to the ongoing professional development and wellbeing of our staff, offering extensive training and progression opportunities and investing in the physical and mental health of our workforce.




  • Experience of working with large data sets.
  • Excellent attention to detail.
  • Mathematical analysis skills.
  • Team player.

Advanced Search: