Job Description

Overview

We are seeking an experienced and motivated

Operational Excel Template Designe

r to join our team. This role is pivotal in driving continuous improvement initiatives across our operations, ensuring that we maintain the highest standards of efficiency and quality. To create, develop and maintain automated excel spreadsheet and Microsoft Word templates that support the company's operation. Using excel functions, and tools.

You will design and build user friendly, accurate templates across several departments to streamline procedures and automate the entire quoting process.

You will provide ongoing support, training and troubleshooting, as well as regular auditing to ensure accuracy and compliance.

Duties

To liaise with engineers and admin staff, to plan, design and build excel spreadsheets tailored to specific project or departmental needs.

To create dashboards and reports using charts, pivot tables and formulas, identifying opportunities to automate repetitive tasks and improve workflows using VBA macros or Power Query. Perform data imports and format as needed. Developing Data entry forms and tools to minimise errors and increase efficiency.

You will need familiarity with Microsoft Office 365 including SharePoint and Teams.

Excellent attention to detail is required to ensure spreadsheets are accurate, user friendly and error free, ensuring accuracy and compliant with branding and formatting standards.

This role requires advanced knowledge of Excel creating clear navigation with buttons, forms, and instructions so non-technical users can work with the files.

Support ongoing quality assurance by regularly auditing templates to ensure accuracy and compliance. Foster a collaborative environment that encourages innovation and continuous learning among team members.

Qualifications

Advanced knowledge of Excel (VLOOKUP, XLOOKUP, IF, IFS) charts data validation and conditional formatting. Microsoft Office Specialist or Advanced Excel Certification is highly desirable.

Problem solving

Good communication and documentation skills to translate team needs into functioning tools.

Ability to work independently and meet deadlines with minimal supervision.

Experience of finance of accounting an advantage.

Knowledge of Sage would be an advantage

At least 2-3 year's experience in a role involving advanced use of Microsoft Excel and Word.

Experience designing and maintaining business templates or reports is preferred, particularly in the construction industry.

Exposure to process automation or data management preferred.

Join us as we strive for excellence in our operations while fostering an innovative diverse environment where your skills can shine!

Salary depends on experience and hours worked.

Job Types: Full-time, Part-time, Permanent

Pay: 22,495.00-30,000.00 per year

Expected hours: 30 - 40 per week

Benefits:

Company pension On-site parking Referral programme
Work Location: In person