Business Support Administrator

2 months ago


Cardiff County, United Kingdom DVS Ltd Full time

Role Summary

Due to exciting growth, we are currently looking for a Business Support Administrator to manage and report on our business data using Microsoft Excel. This is a brand-new position for the business, providing a unique opportunity to create and maintain complex spreadsheets, develop formulas, and ensure data accuracy to support with business decisions covering various departments within the business. The successful person will have an excellent expertise with Excel, critical to helping the business achieve it’s operational and strategic goals.


Reporting to:

Head of Finance


Main Responsibilities

Data Management:

  • Create, maintain, and update complex Excel spreadsheets.
  • Import and export data from various sources into Excel including Sage 200, SQL and Power Query.
  • Ensure data integrity by performing regular audits and checks.

Data Analysis:

  • Develop and implement advanced Excel formulas, including VLOOKUP, HLOOKUP, INDEX-MATCH, and complex nested formulas.
  • Create pivot tables, charts, and graphs to visualize data effectively to enable users to analyse large data sets to identify trends, patterns and insights.
  • Support with analysing data to identify trends as and when required.

Reporting:

  • Prepare and distribute regular reports to stakeholders, including management and department heads.
  • Automate reporting processes using Excel macros and VBA (Visual Basic for Applications).
  • Develop and maintain dashboards for real-time data monitoring.

Process Improvement:

  • Identify opportunities to streamline and improve existing Excel processes.
  • Collaborate with IT and other departments to integrate Excel with other software and databases.
  • Provide training and support to team members on Excel best practices.

Documentation:

  • Document processes, formulas, and procedures for future reference.
  • Maintain version control for all Excel files and ensure proper file management.


Key Attributes and Experience

  • Proven experience in a similar Excel-focused role.
  • Proven experience with advanced Excel functions, data analysis, and reporting.
  • Proficient in Microsoft Excel (advanced level required). Including Excel VBA and macros.
  • Familiarity with database management and data visualization tools is a plus.
  • Ability to draw data from SQL databases.
  • Experience working with Power Query.
  • Experience with Sage 200 would be beneficial for the successful candidate.
  • Strong analytical and problem-solving skills.
  • Excellent attention to detail and accuracy.
  • Ability to work independently and as part of a team.
  • Strong communication skills, both written and verbal.


Salary and Benefits

  • Competitive financial package that can be negotiable and tailored to the successful candidate
  • 25 Days Holiday Per Annum Plus Statutory Bank Holidays; increasing to 28 Days Holiday Allowance after three years’ service
  • Private Medical Insurance
  • Company Sick Pay Scheme
  • Income Protection
  • Share Incentive Scheme
  • Company Funded Social Events
  • On-site parking
  • Workplace Pension
  • Charity Days & Events
  • Annual Flu Vaccination
  • Employee Assistant Program
  • Buy/Sell Holiday Scheme
  • Employee Recognition Awards
  • Casual Dress


Midwich Group is an equal opportunity employer and welcomes applicants from all backgrounds. If you meet the requirements of the role and are interested in this opportunity, please submit your CV for consideration.



  • Cardiff, United Kingdom Yolk Recruitment Full time

    **Business Support Administrator -PART TIME - Permanent - Full time - Cardiff** Yolk Recruitment have teamed up with a cutting edge and technologically driven establishment which prides itself on being a focal point for industry,health and social care when it comes to innovation. **What you will be doing: - ** The Business Support Administrator will...


  • County Down, United Kingdom GP Federation Support Unit Full time

    Priory GP Practice CIC Job OpportunityWe are seeking a highly organized and efficient individual to join our team as a Receptionist. This role will provide administrative support to our busy GP practice, working closely with our friendly team to ensure the smooth operation of our services.Key Responsibilities:Act as the first point of contact for patients...


  • County Down, United Kingdom GP Federation Support Unit Full time

    Priory GP Practice CIC Job OpportunityWe are seeking a highly organized and efficient individual to join our team as a Receptionist. This role will provide administrative support to our busy GP practice, working closely with our friendly team to ensure the smooth operation of our services.Key Responsibilities:Act as the first point of contact for patients...


  • County Down, United Kingdom GP Federation Support Unit Full time

    Priory GP Practice CIC Job OpportunityWe are seeking a highly organized and efficient individual to join our team as a Receptionist. This role will provide administrative support to our busy GP practice, working closely with our friendly team to deliver excellent patient care.Key Responsibilities:Act as the first point of contact for patients and visitors,...


  • County Down, United Kingdom GP Federation Support Unit Full time

    Priory GP Practice CIC Job OpportunityWe are seeking a highly organized and efficient individual to join our team as a Receptionist. This role will provide administrative support to our busy GP practice, working closely with our friendly team to deliver excellent patient care.Key Responsibilities:Act as the first point of contact for patients and visitors,...


  • Cardiff, United Kingdom Hoop Professional Services Full time

    Our valued client, based in Cardiff is seeking an enthusiastic Business Support Administrator to join their team and work closely with the Head of HR. In this role you will be delivering excellent office, facilities, and administrative support to the team and visitors. This a permanent part time position that requires you to work onsite. This position is a...


  • County Down, United Kingdom GP Federation Support Unit Full time

    Priory GP Practice CIC Job OpportunityWe are seeking a highly organized and efficient individual to join our team as a Receptionist. This role will provide administrative support to our busy GP practice, working closely with our friendly team to ensure the smooth operation of our services.Key Responsibilities:Act as the first point of contact for patients...


  • County Down, United Kingdom GP Federation Support Unit Full time

    Priory GP Practice CIC Job OpportunityWe are seeking a highly organized and efficient individual to join our team as a Receptionist. This role will provide administrative support to our busy GP practice, working closely with our friendly team to ensure the smooth operation of our services.Key Responsibilities:Act as the first point of contact for patients...


  • Cardiff, United Kingdom Carousel Consultancy Full time

    **Business Support Administrator - Cardiff - £23k-£27k + great benefits** We’re looking for an enthusiastic and proactive **Business** **Support Administrator**, with a ‘can-do’ attitude, to join a fabulous financial organisation in their sociable Cardiff office. Joining a great team, the Administrator will provide administrative support to various...


  • County Down, United Kingdom GP Federation Support Unit Full time £21,524

    Priory GP Practice CIC Job OpportunityWe are seeking a highly organized and efficient administrative professional to join our team as a Receptionist. The successful candidate will be responsible for providing exceptional customer service, managing front desk operations, and supporting the practice team.Key Responsibilities:Act as the first point of contact...


  • County Down, United Kingdom GP Federation Support Unit Full time £21,524

    Priory GP Practice CIC Job OpportunityWe are seeking a highly organized and efficient administrative professional to join our team as a Receptionist. The successful candidate will be responsible for providing exceptional customer service, managing front desk operations, and supporting the practice team.Key Responsibilities:Act as the first point of contact...


  • County Down, United Kingdom GP Federation Support Unit Full time £21,524

    Priory GP Practice CIC Job OpportunityWe are seeking a skilled and experienced administrative professional to join our team as a Receptionist. The successful candidate will be responsible for providing exceptional customer service, managing administrative tasks, and supporting the smooth operation of our GP practice.Key Responsibilities:Act as the first...


  • County Down, United Kingdom GP Federation Support Unit Full time £21,524

    Priory GP Practice CIC Job OpportunityWe are seeking a skilled and experienced administrative professional to join our team as a Receptionist. The successful candidate will be responsible for providing exceptional customer service, managing administrative tasks, and supporting the smooth operation of our GP practice.Key Responsibilities:Act as the first...


  • Cardiff, Cardiff, United Kingdom DVS Ltd Full time

    Job Title: Business Support AdministratorWe are seeking a highly skilled Business Support Administrator to join our team. As a Business Support Administrator, you will be responsible for managing and reporting on business data using Microsoft Excel. This is a brand-new position for the business, providing a unique opportunity to create and maintain complex...


  • Cardiff, Cardiff, United Kingdom DVS Ltd Full time

    Job Title: Business Support AdministratorWe are seeking a highly skilled Business Support Administrator to join our team. As a Business Support Administrator, you will be responsible for managing and reporting on business data using Microsoft Excel. This is a brand-new position for the business, providing a unique opportunity to create and maintain complex...


  • Cardiff, Cardiff, United Kingdom Vacancy ID: 5203 Full time

    About the RoleWe are seeking a highly organized and detail-oriented Business Administrator to join our team at Maximus Accountants. As a Business Administrator, you will be responsible for providing administrative support to our accounting team, including general admin work, attending and transferring phone calls, maintaining appointment diaries, and...


  • Cardiff, United Kingdom Public Health Wales NHS Trust Full time

    THIS POST IS FIXED TERM/SECONDMENT FOR 6 MONTHS DUE TO NEED OF SERVICE A fantastic opportunity has arisen for an experienced and proactive Business Administration Support Officer to join the WHO CC Directorate within Public Health Wales. In return, we offer great benefits including hybrid and flexible working, a fantastic NHS pension, excellent annual...


  • Cardiff County, United Kingdom Focus Resourcing Limited Full time

    Customer Support AdministratorWe are seeking a highly organized and detail-oriented Customer Support Administrator to join our team at Focus Resourcing Limited. As a key member of our support team, you will be responsible for providing exceptional customer service to our commercial customers.Key Responsibilities:Triage and manage Zendesk tickets,...


  • Cardiff County, United Kingdom Focus Resourcing Limited Full time

    Customer Support AdministratorWe are seeking a highly organized and detail-oriented Customer Support Administrator to join our team at Focus Resourcing Limited. As a key member of our support team, you will be responsible for providing exceptional customer service to our commercial customers.Key Responsibilities:Triage and manage Zendesk tickets,...

  • Business Administrator

    5 months ago


    Cardiff, United Kingdom Cardiff Distillery Full time

    Business Administrator £23,000/year - Full time Established in 2019 Cardiff Distillery has quickly become one of the outstanding distilleries based in Wales and indeed the UK, taking a modern approach to other UK distilleries. We are looking to recruit an Administrator to join our fast-growing business. This is an opportunity to grow your future career...