Scroll down for a complete overview of what this job will require Are you the right candidate for this opportunity
Document ControllerBased Nottingham Area – 3 month contractJob DescriptionWe are seeking an experienced Excel Database & Automation Specialist to support a short-term project focused on developing standardised project and 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.This is a project-specific assignment expected to last approximately 2-3 months.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 completion. Qualifications Required Advanced Microsoft Excel expertise. xwwtmva Demonstrated experience creating database-style Excel solutions. Strong understanding of relation
Please click on the apply button to read the full job description
…