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