Document Controller

Document Controller - Excel & Automation

Contract | 2-3 Months | Hybrid

We are currently recruiting for an experienced Document Controller / Excel & Automation Specialist to support a short-term project focused on developing standardised project, commercial and document control tools.

The role will involve creating advanced Excel-based databases, templates and automated workflows, allowing project information to be maintained in a single master file and automatically populate multiple linked documents.

The successful candidate will work closely with Project Management, Engineering, Procurement, Logistics and Commercial teams to develop efficient solutions that reduce duplicate data entry, improve accuracy and streamline project administration.

Key Responsibilities

• Design and develop advanced Excel databases and management tools
• Create master data files that automatically populate linked project documents
• 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
• Build formulas, lookups, data relationships, validation rules and reporting tools
• Develop automated workflows using Power Query, Power Pivot, Dynamic Arrays and VBA
• Standardise document generation processes across project teams
• Test and validate tools to ensure accuracy and reliability
• Create user-friendly templates and guidance for end users
• Provide knowledge transfer and user training before completion

Essential Experience

• Advanced Microsoft Excel skills
• Proven experience building database-style Excel solutions
• Strong understanding of data structures and data management
• Experience creating automated templates from a single master data source
• Strong knowledge of:
  • XLOOKUP / INDEX-MATCH
  • Dynamic Arrays
  • Pivot Tables
  • Power Query
  • Data Validation
  • Conditional Formatting
• Experience developing project or commercial documentation
• Strong analytical and problem-solving skills
• Ability to work independently and deliver solutions with minimal supervision
• Strong communication and stakeholder management skills

Desirable

• VBA / Macro development experience
• Experience with SharePoint, Power BI or Microsoft 365
• Previous experience within engineering, manufacturing, logistics or project-based environments
• Experience developing BOM, Packing List, Invoice, PDR or VDR systems
• Understanding of document control and project delivery processes