BI Analyst

• 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-adding BI tools.
• Make sure reports and analytics are up to date and meet the requirement.
• Collaborate with and cooperate with teams (IT, Finance, Operations, HR, Bidding, Compliance, etc.).
• Deliver responsibilities in the most cost-effective way

Do you have what it takes?

• Power BI Experience and/or qualifications essential - designing dashboards, complex DAX calculations, create data models, not just structure data sets, understand relationships between different data sets, keep up to date with all the new releases, building foundations of data set.
• Power Query Experience Essential – Experience and knowledge of Power Query M, application of PowerQuery to connect and transform datasets.
• SQL Server Experience Essential – database maintenance, creating queries and procedures, applying ETL processes to collate, store and process various data sources from within and outside of the organisation.
• Experience of REST API protocols, and application of API’s to extract/load data, is desirable.
• Other coding experience highly desirable, including but not limited to utilisation of PowerShell and Python.
• Experience with the Microsoft Power Suite of products, including PowerApps, Power Automate, etc.
• Experience as a business analyst, data visualisation analyst, BI analyst or computer/coding related qualification.
• Conceptual knowledge of data modelling and relational databases.
• Can explain complex data structures and analyses to both technical and non-technical stakeholders.
• Have a good grasp of “data storytelling” – you can visualise data to emphasise the main story.
• Ability to communicate and translate data.
• Knowledge of data modelling and relational databases.
• Strong analytical and problem-solving skills with the ability to simply the complex.
• Ability to analyse, interpret and apply complex data and information.
• Background in managing big data sets, including relational databases.
• Display a natural curiosity into data and the ability to instil this in others across the business.
• Excellent observation and analysis skills. A sharp eye for detail.
• The ability to handle multiple tasks effectively and prioritises workload to ensure targets are achieved without compromising performance.
• Excellent written and oral communication skills, with ability to produce accurate, concise data that is clear to understand.
• Ability to work within challenging deadlines and independently prioritise workload.
• You will have a proven track record in delivering results within a progressive, dynamic, fast-paced and complex operational environment, comfortable handling large data sets from multiple data sources.

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 the 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 are committed to providing services for our patients, service users, clients, and community and is supported by employees with an increasing variety of backgrounds.

To do this effectively it is essential that we promote equality and embrace diversity and inclusion and treat all of our employees, patients, service users and clients with dignity and respect.

EMED Group is committed to encouraging equality, diversity and inclusion among our workforce, and eliminating unlawful discrimination, with our aim being to be truly representative of all sections of society and our clients, and for each employee to feel respected, valued and able to give their best.

EMED Group are committed to providing equal opportunities and we endeavour to provide an inclusive and safe working culture for all.