Overview
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 for meetings, events and in-office touchpoint days.
Contract type: Full time, permanent
Location: Remote with national travel
Role
The BI Analyst will be responsible for creating, developing and maintaining 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, Power BI and PowerApps technologies. The role will also focus on performance reporting and the development of reporting suites covering operational, people, financial and other transactional data sources. You will work closely with stakeholders across departments to deliver insightful dashboards and data models using Power BI, SQL Server, and cloud-based data sources.
Benefits
* £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 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 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 to provide analytical solutions to support business decision making and continual improvement and business development.
* Undertake trend analysis and forecasting to inform users of key performance information relating to demand, capacity, systems, process management and compliance.
* Validate numbers and material quality in collaboration with colleagues.
* Own data quality practices and procedures, ensuring data is validated and cleansed as necessary across all key data sources within the organisation.
* Use workflows, data dictionaries and applications as relevant 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 projects to ensure accurate and on-time delivery.
* Understand business strategy, goals and objectives to provide value-adding BI tools.
* Ensure reports and analytics are up to date and meet requirements.
* Collaborate with IT, Finance, Operations, HR, Bidding, Compliance and other teams as needed.
* Deliver responsibilities in the most cost-effective way.
Qualifications
* Power BI Experience and/or qualifications essential – designing dashboards, complex DAX calculations, data models, dataset structures, and relationships; keep up to date with new releases.
* Power Query Experience – Power Query M, transforming datasets.
* SQL Server Experience – database maintenance, queries and procedures, ETL processes across multiple data sources.
* Experience of REST API protocols and applying APIs to extract/load data is desirable.
* Other coding experience such as PowerShell and Python is desirable.
* Experience with the Microsoft Power Suite (PowerApps, Power Automate, etc.).
* Experience as a business analyst, data visualisation analyst, BI analyst or related qualification.
* Conceptual knowledge of data modelling and relational databases.
* Ability to explain complex data structures to both technical and non-technical stakeholders.
* Strong data storytelling and the ability to visualise data to emphasise the main story.
* Ability to communicate and translate data effectively.
* Experience managing large data sets from multiple sources.
* Strong analytical and problem-solving skills with the ability to simplify the complex.
* Excellent written and verbal communication skills; ability to produce accurate, concise data that is easy to understand.
* Ability to work under deadlines and independently prioritise workload.
* A track record of delivering results in a progressive, dynamic, fast-paced environment.
Note: This role is subject to several regulatory pre-employment checks. You may be asked to provide details of your full employment history during the interview process. Your HMRC record may help you prepare this information.
Our Values
Collaborative – we work as one team with a shared purpose to meet the needs of our patients, passengers, colleagues, customers, communities, and the planet.
Agile – We listen, learn and adapt to improve the business, each other, and ourselves.
Reliable – We do what we say we will do, we take responsibility and we behave with integrity.
Empowered – We are confident and committed to taking responsibility to deliver the highest quality service.
About Us
The exciting merger of ERS Medical and E-Zec Medical has enabled us to rebrand, therefore as a combined business we are now known as EMED Group. We are the largest Patient Transport and Care Partner to the NHS with circa 4,000 colleagues across 60 depots. Our ambition is to continue developing patient care transport services that improve health and wellbeing for people across our local communities by providing transport that supports patient care, community support, secure mental health and medical courier services.
EMED Group is committed to providing services for our patients, service users, clients, and community, and is supported by employees with diverse backgrounds. We promote equality, diversity and inclusion and treat all employees, patients, service users and clients with dignity and respect. We are committed to equal opportunities and to an inclusive and safe working culture for all.
#J-18808-Ljbffr