Pertemps Managed Solutions
Excel Database Specialist
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Excel Database Specialist
Location: Nottingham - Hybrid (2 days in the office)
Pay/Duration: £200 per day Umbrella, 3-Month Contract
We're seeking an experienced Excel Database Specialist to support a short-term project focused on streamlining project and commercial documentation through automation and standardisation.
You'll design and develop advanced Excel-based databases, templates, and automated workflows that enable information to be maintained in a single master file and automatically populate multiple project documents, reducing manual administration and improving data accuracy.
Key Responsibilities
- Develop advanced Excel databases and automated management tools.
- Create master data files that populate multiple linked documents.
- Build automated templates for: Bills of Materials (BOMs), Packing Lists, Commercial Invoices, Product & Vendor Data Registers (PDRs/VDRs), Document Registers, and Project Tracking Logs.
- Utilise Power Query, Power Pivot, Dynamic Arrays, advanced formulas, and VBA where appropriate.
- Collaborate with Project, Engineering, Procurement, Logistics, and Commercial teams to gather requirements and deliver efficient solutions.
- Test, validate, and document all tools, providing user training and handover at project completion.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
About You
- Advanced Microsoft Excel expertise with experience building database-style solutions.
- Strong knowledge of XLOOKUP, INDEX/MATCH, Pivot Tables, Power Query, Dynamic Arrays, Data Validation, and Conditional Formatting.
- Proven experience creating automated templates and workflows from a single data source.
- Strong analytical and stakeholder engagement skills.
- Able to work independently and deliver solutions with minimal supervision.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Desirable
- Experience within engineering, manufacturing, logistics, or project-based environments.
- VBA/macros experience.
- Knowledge of BOMs, document control processes, PDRs/VDRs, and commercial documentation.
- Exposure to SharePoint, Power BI, or wider Microsoft 365 tools.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills