Business Intelligence Analyst - Chelmsford
Job summary
Business Intelligence Analyst
Chelmsford, Essex
£35,000 to £37,000 per annum
Full time - 40 hours per week
Weare 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 tosupport in decision-making.The company offers trusted security advice, risk mitigation strategies, secure support and integratedsolutions for strategic clients or those operating in complex or sensitive environments.
Responsibilities:
- 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
Main duties of the job
Responsibilities:
- 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.
Benefits
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
About us
Why G4S?
G4S Patient Transport Services is one of the UKs 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.
Job description
Job responsibilities
- 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. R, Google Analytics.
Person Specification
Qualifications
- Advanced Google Sheet and Microsoft Excel skills.
- Working knowledge of database (SQL).
- Working knowledge of SSRS.
- (Desirable) Working knowledge of R.
- (Desirable) Working knowledge of Google Analytics.
- Other Microsoft and Google tools e.g. Google Docs, Slides, etc.
- Experience of working with large data sets.
- Excellent attention to detail.
- Mathematical analysis skills.
- Team player.
- Google Sheets and Microsoft Excel skills including Macro & VBA
- MS SQL Server (or any other systems e.g. MySQL)
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Employer details
Employer name
G4S
Address
Unit 87 Waterhouse Business Park
2 Cromar Way
Chelmsford
Essex
CM1 2QE
https://careers.g4s.com/en/jobs
- Company
- G4S
- Location
- Chelmsford, United Kingdom CM1 2QE
- Employment Type
- Permanent
- Salary
- £35000.00 - £37000.00 a year
- Posted
- Company
- G4S
- Location
- Chelmsford, United Kingdom CM1 2QE
- Employment Type
- Permanent
- Salary
- £35000.00 - £37000.00 a year
- Posted