At a Glance
- Tasks: Create advanced Excel databases and automate documentation processes for engineering projects.
- Company: Leading engineering organisation based in Nottingham with a hybrid working model.
- Benefits: Competitive hourly rate, flexible work environment, and valuable project experience.
- Other info: Opportunity for knowledge transfer and user training before project completion.
- Why this job: Join a dynamic team and enhance your Excel skills while making a real impact.
- Qualifications: Proficiency in Excel, strong analytical skills, and ability to work independently.
The predicted salary is between 23.4 - 28.6 £ per hour.
Nottingham based (Hybrid working 2 days per week in the office) £25.65 an hour Umbrella Inside IR35 3 Month Contract initially. This is a great opportunity to work within a leading engineering organisation based in Nottingham. This role is hybrid working, 2 days in the office per week, and involves an early shift from 6am - 4:15pm.
We are seeking a Document Controller 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
- Other 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 various 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.
Proficiency with:
- Complex formulas
- XLOOKUP
- INDEX/MATCH
- Dynamic Arrays
- Pivot Tables
- Power Query
- Data Validation
- Conditional Formatting
Strong analytical and problem-solving skills. Ability to work independently and deliver solutions with minimal supervision. Excellent communication and stakeholder engagement skills.
Preferred:
- Experience supporting engineering, manufacturing, logistics, or project-based businesses.
- Experience developing BOM, Packing List, Invoice, PDR and VDR systems.
- VBA and macro development experience.
- Familiarity with document control and project delivery processes.
- Experience integrating Excel with SharePoint, Power BI, or other Microsoft 365 tools.
For more information please contact Lauren Morley at JAM Recruitment or click apply.
Document Controller employer: JAM Recruitment Ltd
Join a forward-thinking organisation in Warrington that prioritises employee growth and development, offering a dynamic work culture where innovation thrives. As the Head of Asset Management - Strategy & Standards, you will lead a high-performing team while benefiting from a supportive environment that values strategic input and collaboration. With a commitment to continuous improvement and alignment with industry best practices, this role provides a unique opportunity to make a significant impact within the asset management sector.
