Expire in: 24 days
We are looking for a excel database specialist who can support on a short term project focusing on developing standard project/commercial documentation tools.
The successful candidate will create robust Excel-based databases, templates, and automated workflows that allow information to be maintained in a single master file and automatically populate multiple linked documents.
The role will involve designing and building intelligent spreadsheets and databases for project execution documents such as Bills of Materials (BOMs), Packing Lists, Commercial Invoices, Product Data Registers (PDRs), Vendor Data Registers (VDRs), document trackers, and similar project deliverables. The objective is to eliminate duplicate data entry, improve accuracy, and reduce administrative effort through automation and standardisation.
Key Responsibilities
Design and develop advanced Excel-based databases and management tools.
Create master data files that automatically update linked project documents and reports.
Develop automated templates for:
Bills of Materials (BOMs)
Packing Lists
Commercial Invoices
Product Data Registers (PDRs)
Vendor Data Registers (VDRs)
Document Registers
Project Tracking Logs
Other project and commercial documentation Build formulas, data relationships, lookups, validation rules, dashboards, and reporting tools.
Implement automation using advanced Excel functionality, including:
Power Query
Power Pivot
VBA Macros (where appropriate)
Dynamic Arrays
Advanced Formulas and Data Linking
Simplify and standardise document generation processes across multiple project teams.
Create user-friendly interfaces and instructions for end users.
Work with Project Managers, Engineering, Procurement, Logistics and Commercial teams to understand requirements and convert them into efficient Excel-based solutions.
Test and validate all tools to ensure data accuracy and reliability.
Provide knowledge transfer and user training before project completionDo not include the following in your job application, CV, or cover letter:
You should not be asked for payment or irrelevant information. If you have concerns about a job advert or employer, seek guidance on how to proceed.
Looking for your next career move? Join a top company hiring Document Controller job near me in NG6, Bulwell, Nottingham! This is your chance to work on exciting projects, grow professionally, and enjoy a rewarding career with competitive pay and excellent benefits. Whether you're an experienced professional or looking to take the next step, this role offers the perfect opportunity to enhance your skills and make an impact. Don’t miss out—apply today via Vita CV and take your career to the next level!
© Vita CV: Registered in England and Wales (16187919).
Vita CV uses cookies to enhance your experience, analyze site traffic, and personalize content. By continuing to browse, you agree to our use of cookies.