Pricing Trans Developer

About the company 

IWG has been at the forefront of the flexible workspace revolution for more than 30 years. We have made it possible for organisations and individuals everywhere to take a new approach to the traditional working day. We have over 3,400 locations across over 110 countries allowing millions of people every day to have a great day at work.  

Our customers are start-ups, small and medium-sized enterprises, and large multinationals. With unique business goals, people and aspirations. They want workspaces and communities to match their needs. We provide them with choice through our portfolio of brands, covering serviced offices (Regus, Spaces, HQ, Signature and No18), commercial real estate brokerage and managed office solutions.  

Join us at www.iwgplc.com 

Job Purpose

The goal of the role is to transform the Network Growth data and analytics function to highly optimise the processes and reporting of a global sales team.

This role’s integral part in that team is to build, and continually improve, the data analysis, processes and report automation that create actionable insights into a highly dynamic and fast paced function.

We are looking for a skilled VBA developer and excel application designer who wants to transform the pace of delivery and overall team efficiency in a high growth business, with their work being visible to business CEO and SLT.

This is a great opportunity to join a market leader and make a personal contribution to our success.

Key Responsibilities

Application Development (VBA required, SQL / Python optional)

• Develop advanced Excel-based applications and tools.
• Train end-users on the efficient use of Excel tools
• Ensure all Excel-based tools are user-friendly and meet business requirements.

Report and Process Automation

• Through application development, develop and maintain automated report generation
• Creating procedures & jobs needed for report automation
• Creating workflow automations within Microsoft to automate tasks and data flows
• Working with team and other colleagues to maintain data and report integrity

Data visualisation

• Utilising standard data sets to generate PowerBI dashboards and visualisations

Required Skills, Experience & Qualifications

• Education: Bachelor’s or Master’s degree (Business, Finance, IT or related fields).
• Certification: Proof of business level proficiency in VBA (SQL & Python optional).
• Advanced user of the full Microsoft Office 365 suite, especially the Power Platform.
• Familiarity with Excel integration with databases and other systems.
• Ability to troubleshoot and debug Excel issues efficiently.
• Solid understanding of data analysis and visualization principles.
• Strong attention to detail with a focus on data accuracy.
• Proven ability to undertake projects from initial inception through to completion.
• Excellent communication skills to collaborate with cross-functional teams.
• Prioritises well, and consistently delivers against tight deadlines.
• Team player with high level of professional integrity.
• Comfortable with ambiguity and prepared to work in an agile and flexible way