Business Intelligence Analyst

Company	G4SSee more
Address	Chelmsford, Essex
Category	IT

Job description

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.

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

THE IDEAL CANDIDATE:

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

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.