Business Support Administrator - Advanced Excel

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.