BI Analyst

Contract type: Full time, permanent
Location: Remote with national travel

We have a fantastic opportunity for a BI Analyst to join our business intelligence team, this will be a remote role with national travel required occasionally as and when required for the attendance of meetings, events and in-office touchpoint days.

The BI Analyst will be responsible for creating, developing and managing critical reporting suites to drive business growth and efficiency. This will encompass both planned and ad hoc reports derived from all software platforms and will be predominately harnessing SQL Server, PowerBi and PowerApps technologies.

A key focus of the role will be to analyse and dissect Time and Attendance data to produce comprehensive reporting, whilst identifying efficiency improvement, and create relationships to other data sources within the organisation to identify and quantify value.

The role will also focus on performance reporting and the development of reporting suites covering operational, people, financial and other transactional data sources.
Benefits for the role include

- £40,000-£50,000 per annum, depending on experience.

- 40 hours per week

- 33 days holiday, inclusive of Bank Holidays, increasing with service

- Life Assurance

- 24/7 online/telephone GP Consultation and access to prescriptions.

- 2nd opinion medical support following diagnosis or where a colleague is on a treatment pathway.

- Cash-plan benefits, providing colleagues the option of protecting themselves in case of illness and recuperation, including dental, optical, chiropody.

- Access to mental health consultations.

- Access to physiotherapy consultations.

- Access to legal advice on domestic issues e.g. motoring offences, wills and probate, and personal injury.

- Financial guidance re retirement planning, tax savings and state benefits.

- Long Service Recognition Scheme – recognising colleagues for their continued service after 5 and 20 years’ service.

- Values-based Internal Recognition Scheme with financial reward, which will lead to an annual recognition event.

- Refer a Friend recruitment incentive scheme with financial rewards.

- The EMED foundation, to provide support to colleagues and our local communities.

- Pension Scheme.

- Blue Light Card access

- EAP (Employee Assistance Programme) to support a range of health and wellbeing requirements.

- Flu vaccination (through an internal campaign in Autumn/Winter).

Role Responsibilities

- Use the in-house systems to produce 1st in class daily, weekly and monthly reporting, including the use of SQL, PowerApps and PowerBI to display key metrics in a way that can be clearly understood across the business;

- Develop reporting to measure both commercial, operational success and quality of service delivery across multiple contracts and functional areas.

- Support Operational Managers and Heads of Departments with analytical and concise reporting and summaries.

- Undertake projects as directed to provide analytical solutions to support business decision making and review in the development of continual improvement and business development.

- Undertake trend analysis and forecasting to inform users of key performance information relating to demand, capacity, systems and process management and compliance

- Communicate with colleagues to validate that numbers and material have the right level of quality.

- Own data quality practices and procedures, ensuring data validated and cleansed as necessary across all key data sources within the organisation.

- Use workflows, processes, data dictionaries and applications as relevant and followed by functional areas to meet business strategy needs.

- Collaborate with colleagues to identify and describe requirements and test solutions.

- Create and manage positive relations with internal users and manage the projects to have accurate and on-time delivery.

- Understand business strategy, goals and objectives to provide value-addin