Business Intelligence Analyst

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
  
  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.
  
  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.


• 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