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.
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.
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
Experience:
Microsoft Excel: 1 year (required)
Work Location: In person
Beware of fraud agents! do not pay money to get a job
MNCJobs.co.uk will not be responsible for any payment made to a third-party. All Terms of Use are applicable.