Senior Python Programmer - Warehouse Design Automation

About the role

BWB Consulting is looking for a Senior Python Developer to lead the development of the optimisation and automation engine behind its warehouse design workflow. Reporting to the Digital Innovation Lead, you will work with structural engineers and tender teams to turn engineering requirements, design rules and existing Excel processes into practical software. The role is hybrid, based at BWB Nottingham, and is advertised as a 12-month fixed-term contract.

Key responsibilities

• Design, develop and maintain Python software supporting warehouse design optimisation and tender production.
• Translate calculations, design rules and project constraints into clear, reusable and configurable code.
• Develop routines that generate and compare design options against engineering and commercial criteria.
• Build data processing tools and integrate them with existing Excel workbooks, calculation templates and tender processes.
• Automate schedules, summaries and reports while keeping traceability between source data, assumptions and results.
• Work with engineers and tender teams to prioritise improvements, test solutions and support adoption.
• Measure current production times and track how automation improves efficiency and consistency.
• Apply testing, version control and documentation, and explain assumptions and limitations clearly.

Required profile

• Experienced Python developer who enjoys turning complex technical problems into maintainable solutions.
• Track record of automating complex spreadsheet-based or technical workflows.
• Experience of optimisation methods, numerical problem-solving or rules-based option appraisal.
• Ability to understand engineering requirements and explain software solutions clearly.

Required skills

• Advanced Python programming, in a business environment.
• Data processing with libraries such as pandas and NumPy.
• Integrating Python with Excel using openpyxl, xlwings or equivalent.
• Software testing, debugging, Git version control and technical documentation.

What we offer

• Salary, 5% pension match, life assurance and long-service recognition.
• 25 days' holiday rising to 28, with the option to buy more, and hybrid working (3 days in the office).
• Westfield Health, healthcare cash plan, Cycle to Work scheme and wellbeing initiatives.
• Fully funded training, Chartership support and paid professional subscriptions.
• Volunteering days, social events, discounts and savings.