Excel Template Designer/builder

Blake Contractors is a family run business based in Southend , with a good reputation for a reliable and honest local service. We specialise in Fire, Security, Access Control, Electrical and Emergency lighting, and employ our staff for the right attitude. 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.

This is an office based role. 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.

Do you have experience in Microsoft Excel?, We are seeking an experienced and motivated Operational Excel Template Designer to join our team., 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.

This position would suit someone with a background in finance and experience creating user friendly spreadsheets.

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., * Microsoft Excel: 1 year (required)

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

Full or part time considered - Salary depends on experience and hours worked.

Job Types: Full-time, Part-time, Permanent, Temp to perm

Pay: £22,495.00-£30,000.00 per year

Expected hours: 30 - 40 per week

Benefits:

• Company pension
• On-site parking
• Referral programme