Azure Business Inteligence Developer

Azure BI Developer

Based in Hatfield

  • Salary: Competitive + Benefits

  • Hours Per Week: 35

  • Flexible Hybrid Working

We are looking for someone who:

  • Has proven working knowledge of the Azure BI Platform, including Azure Data Lake, Azure Data Factory, Azure SQL and Microsoft Power BI

  • Has experience as a database or ETL developer, preferable on SQL server platform

  • Has extensive working experience of Microsoft BI solutions (SSIS, SSAS, SSRS)

As a Sunday Times Best Big Company, you will enjoy great benefits such as free club memberships, 25 days holiday, a competitive bonus scheme, discount on our products and the ability to develop your skills in a great role.

Key Responsibilities

  • Data solution architecture

  • Provide expert technical advice and guidance to help scope out and design reporting solutions

  • Translate business requirements into technical data solutions

  • Develop innovative ETL approaches to bring a diverse set of on-prem and cloud-based data sources into the Data Lake

  • Identify and implement suitable data quality management and meta data management solutions

Azure platform development and management

Develop and operate the Azure BI platform. Design, develop, test, and roll-out effective Azure data repositories, such as databases, data marts, blob storage, and analytics models to deliver automated reporting, Power BI dashboards, and deploy data science capability.

Education and Experience

  • Degree in computer science, information systems, or another related technical field

  • Possesses a background in software and/or database development and engineering, data architecture, and managing BI Solutions

  • Experience as a database or ETL developer preferable on SQL server platform

  • Experience of designing conceptual and logical data models

  • Hands-on experience with developing in BI cloud technologies in Azure including Data Factory, Power BI (DAX)

  • Extensive working experience of Microsoft BI solutions (SSIS, SSAS, SSRS)

  • Experience in troubleshooting and resolving database issues such as integrity, performance, replication, connectivity, recovery, and security.

  • Experience in agile methodologies

  • Experience in preparing data for data science and Machine Learning


  • Ability to identify a business problem and recommend

  • Design and development of best practice ETL flows, data stores, dimensional models, cubes

  • Data warehousing and best practice BI Architecture

  • Data aggregation and dimensional modelling, OLAP

  • Data preparation (sourcing, acquisition, integration)

  • Proven ability to solve problems of varied technical backgrounds

  • Fluency with appropriate tools including Azure DevOps, Visual Studio other SQL Server Management tools

  • Awareness of best practice, trends, and evolutions in the IT industry and most particularly MS Azure technology stack.