BI Developer – Business Intelligence

reports to - Global BI Director

location: flexible (remote)

About IWG

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

About the role

We are searching for an experienced BI Developer to join our team and play a key role in supporting the business with insights that shape commercial & operational decisions. The ideal candidate should be highly skilled in all aspects of data analytics, including mining, generation, interpretation and visualisation. Additionally, you should be committed to transforming data into readable and goal-driven reports that can help drive the growth & efficiency of the business. In this role you will work closely together with both the Global BI Director and other Data Analysts across a variety of business functions.

Key responsibilities

• The BI Developer will be responsible for the development, documentation, and distribution of reports. The role requires a solid grasp of both relational and dimensional data sources.  The ideal candidate will have designed and built enterprise-wide QlikView and Power BI reporting solutions. 
• Tasks will also involve the day-to-day monitoring and maintenance of components that make up the data warehouse and reporting infrastructure.
• The candidate will also be required to prepare ad hoc data requests, analyse report results to ensure their accuracy and draw out business insights.
• The role requires business analysis experience, strict data governance and working to best practices to improve overall quality and speed-of-delivery
• Day to day, the role will entail:
  • Ongoing maintenance and development of reporting platform
  • Acquiring data from primary and secondary data sources through running, maintaining and developing SQL queries
  • Ensuring quality, accuracy and consistency of data in our reporting platform
  • Interpreting data and analysing results using statistical techniques
  • Developing and implementing improvements that drive excellence in the functionality and data structure of our reporting platform
  • Processing, designing and presenting data in the form of management reports and dashboards to help the business make better business decisions
  • Defining, measuring, and tracking business performance against a set of KPIs
  • Responding to ad hoc data requests, analysing report results to ensure their accuracy and drawing out business insights
  • Supporting business users

Qualities

• Intelligent and analytical
• Persistent and goal-oriented
• Strong attention to detail
• Unfazed working in a fast-moving environment & manages ambiguity while maintaining focus on priorities
• Team builder. Recognises the importance of the team
• Willingness to go beyond the job description to meet business goals
• Tenacious and investigates problems to establish root cause
• Solves complex problems with creative solutions
• The candidate must have excellent problem solving skills with a track record of delivering on time
• A quick learner who is able to work quickly while maintaining focus on priorities
• Highly motivated individual who has the ability to take ownership of projects, from initial inception to drive through to final completion, and can work with direction but little supervision
• Excellent communication, influencing and stakeholder management skills

Qualifications 

• Strong knowledge of QlikView server architecture and building QVDs and QVWs applying business rules and data validations
• Expert knowledge of SQL Server, T-SQL, with the ability to write complex yet efficient SQL queries and stored procedures
• Proficient in QMC to monitor QlikView server process to ensure that they continue to run in the most efficient manner and perform QlikView system administration tasks as required
• Experience of building Power BI reports and working with Microsoft Azure Power Platform using PowerApps and PowerAutomate
• Proficient in the use of Excel, e.g. use of Pivot tables, VLOOKUP, etc.
• Ability to drive process excellence and change
• Solid organisational skills, ability to prioritise and multi-task in a demanding environment
• Able to optimise and improve automation of data processes
• Fluent in English

Experience

• At least 3 years’ experience in a similar role using SQL, QlikView, and Azure Power Platform
• A bachelor’s degree in Data Analytics, Computer Science, Mathematics, Finance or a related field of study
• Previous exposure to Microsoft Dynamics CRM and an understanding of the Microsoft DataVerse
• Comfortable with business analysis and requirement gathering
• Able to demonstrate reports to internal business users; promote benefits of BI, and encourage usage across departments
• Previous experience in a large global corporate is a plus

Contract

• Full-time
• Location can be anywhere globally, but work hours would need to have significant overlap with European/UK working hours