BI Analyst in Shrewsbury

BI Analyst in Shrewsbury

Shrewsbury Full-Time 50000 - 50000 £ / year (est.) Remote
E

At a Glance

  • Tasks: Create and manage impactful reports using SQL, Power BI, and PowerApps to drive business growth.
  • Company: Join EMED Group, the largest Patient Transport and Care Partner to the NHS.
  • Benefits: Earn £40,000-£50,000 with 33 days holiday, health benefits, and a supportive work culture.
  • Other info: Enjoy a remote role with occasional travel and excellent career development opportunities.
  • Why this job: Make a real difference in healthcare by transforming data into actionable insights.
  • Qualifications: Experience with Power BI, SQL, and data analysis; strong communication skills are a must.

The predicted salary is between 50000 - 50000 £ per year.

Contract type

Full time, permanent

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, Power Bi and Power Apps 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, Power Apps and Power BI 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 Power Query 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 Power Shell and Python.
  • Experience with the Microsoft Power Suite of products, including Power Apps, 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.

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 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.

BI Analyst in Shrewsbury employer: EMED Group

EMED Group is an excellent employer, offering a supportive work culture that prioritises employee well-being and professional growth. Located in Shepton Mallet, we provide flexible working hours and opportunities for overtime, ensuring a balanced work-life dynamic while contributing to the vital service of maintaining our ambulance fleet. Join us to be part of a dedicated team where your skills are valued and your contributions make a meaningful impact on community health and safety.

E

Contact Details:

EMED Group Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land BI Analyst in Shrewsbury

✨Get to Grips with Data Visualisation Tools

If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.

✨Join Local Business Intelligence Meetups

Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like EMED Group!

✨Engage with Online BI Communities

Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.

✨Leverage Your University’s Career Support

If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!

We think you need these skills to ace BI Analyst in Shrewsbury

Power BI
DAX Calculations
Data Modelling
Power Query M
SQL Server
ETL Processes
REST API Protocols

Some tips for your application 🫡

Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.

Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.

Tailor Your Documents for Us:When applying for a full-time role at EMED Group, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!

Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.

How to prepare for a job interview at EMED Group

✨Show off your analytical skills

In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!

✨Practice your technical know-how

Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.

✨Portfolio of Projects

Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.

✨Know their business model

Get familiar with EMED Group’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.