BI Lead Developer


Hammersmith and Fulham, London

Work type:


Business sector:

Business Intelligence


£45000.00 - £55000.00 per annum + Bonus & Other great Benefits

Job reference:


Start date:


Contact email:


Matt Trought

Business Intelligence Lead

BI // Business Intelligence // Data // SQL // SSRS // SSAS / SSIS // OLAP // OLTP // T-SQL // Power BI

Location: Hammersmith (West London)

Salary and package: Competitive + Bonus, 23 days holiday per year PLUS 3 days over the Christmas period, Flexible working practices, Private medical insurance, Medical cash back plan, Income protection insurance, Life insurance, Season Ticket Loans, Child Care Vouchers, Cycle to work Scheme, Loyalty Discount Cards, Weekly Fruit Drops, Last Friday of each month Social

BI // Business Intelligence // Data // SQL // SSRS // SSAS / SSIS // OLAP // OLTP // T-SQL // Power BI


Would you like to work for an award-winning company, that really stands out from the crowd by their unique and innovative way of working, that also creates the best working environment for their employees? If so, please carry on reading.

Due to continued expansion, and new Greenfield projects my client based in West London, are Seeking a motivated, Business Intelligence Lead to join their fantastic Data team.

My client prides themselves as being recognised as an organisation that puts Innovation first, when working with technology, and they great way the treat their employees, so If you're someone who likes to get involved or have the opportunity to work with various other Data teams and projects involving IT, Business Intelligence then this role is for you!

BI // Business Intelligence // Data // SQL // SSRS // SSAS / SSIS // OLAP // OLTP // T-SQL // Power BI

Purpose of this Data Warehouse Developer Role:

  • Responsible for the management and delivery of the Business Intelligence (BI) services.
  • Be a subject matter expert in business intelligence and data analysis
  • Management of data extraction into the data warehouse, ensuring that all data is complete, appropriately cleansed and delivered to agreed timelines and accuracy.
  • Deliver insight efficiently, striving to continually improve the automated generation of reports.
  • Strong T-SQL skills to create standards based reports and stored procedures in SQL Server.
  • Ability to build data cubes or queries that can be reused across multiple reports or used by the business to self-generate reports within a safe environment that does not impact on production environments.

In addition to the specifics above, you may be required to undertake such other duties as may reasonably be required of you in the post and department above.

Experience required:

  • 5+ Years experience of SQL Server 2005-2016 (including SSMS, SSAS, SSIS, SSRS).
  • 2+ Years experience of OLTP and OLAP systems.
  • Experience of manipulating data formats such as XML, JSON, CSV and text files.
  • Experience with Excel especially with Power Pivots connecting to OLAP cubes.
  • A sound understanding of T-SQL and performance tuning.
  • A sound understanding of Kimball methodology.
  • A sound understanding of product life cycles and release processes
  • A general understanding of Amazon Web Services


  • Any visualisation/analytics tools: Tableau, Alteryx, PowerBI, Periscope Data
  • Experience with PostgreSQL, MySQL, Oracle.
  • AWS: Redshift, RDS, Glue, Data Pipeline, Quick Sight
  • Any experience with financial systems especially SAP B1 is a major bonus.
  • Any DBA experience backup/restore and DB failover procedures.
  • Any knowledge of GitHub, Terraform, Consul, Docker, Kubernetes
  • Any experience with Python

If you feel you have the relevant skills to be considered for this Business Intelligence Lead Developer opportunity and would like to know further information, please forward an up to date version of your CV and I will contact you back within 48 hours to discuss this role in more detail.

BI // Business Intelligence // Data // SQL // SSRS // SSAS / SSIS // OLAP // OLTP // T-SQL // Power BI

BI // Business Intelligence // Data // SQL // SSRS // SSAS / SSIS // OLAP // OLTP // T-SQL // Power BI

Share this job:

help your friends find their dream job: