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.