Excel Automation Document Controller (Contract)

JAM Recruitment Ltd; East Midlands; Hybride; GBP 55 000 - 77 000; Temps partiel

Résumé du poste

JAM Recruitment Ltd seeks a Document Controller / Excel & Automation Specialist for a short-term contract (2-3 months) with hybrid working. You will design advanced Excel databases, automate templates, and create master data files that auto-populate linked documents to streamline project administration.

Work closely with Project Management, Engineering, Procurement, Logistics and Commercial teams to reduce duplicate data entry, improve accuracy and standardise processes using Power Query, VBA

Qualifications

• Advanced Microsoft Excel skills required.
• 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.

Responsabilités

• Design and develop advanced Excel databases and management tools.
• Create master data files that automatically populate linked project documents.
• Develop automated templates for BOMs, Packing Lists, Invoices, PDRs, 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.

Description du poste

JAM Recruitment Ltd seeks a Document Controller / Excel & Automation Specialist for a short-term contract (2-3 months) with hybrid working. You will design advanced Excel databases, automate templates, and create master data files that auto-populate linked documents to streamline project administration.

Work closely with Project Management, Engineering, Procurement, Logistics and Commercial teams to reduce duplicate data entry, improve accuracy and standardise processes using Power Query, VBA