Business Intelligence Developer

20 Jul 2021
17 Aug 2021
Contract Type
Full Time
JOB TITLE: Business Intelligence Developer
LOCATION: Working from home. Client based in Croydon - some travel to the office required as lockdown restrictions ease.
PAY RATE: GBP450 per day (Umbrella)
DURATION: 4 month contract
IR35 STATUS: Inside


The Local Authority client has a Microsoft Azure hosted Business Intelligence Platform using the following services: Azure Data Factory, Azure Data Lake and Azure SQL database with Power BI for visualisation, insight and analytics.

The BI team are focused on increasing the number of corporate datasets to provide self-service BI to our analytical and report users therefore embedding the use of BI throughout the organisation.

Due to increased demand, we are looking to supplement the BI Team with 2 additional BI Developers to work alongside the existing BI Developers, BI Data Engineer and BI Strategic Lead.

The BI Developer(s) will bring end to end BI experience to support the Council with the continued development and growth of the existing BI platform and the use of Microsoft Power BI. Particularly focused on Health, Wellbeing and Adults (HWA) data sets and systems.


You will have proficient technical skills including excellent knowledge of Power BI and Azure BI as well as dimensional modelling, SQL and Python.

Determine, design and implement the most effective reporting and data analytical solutions to deliver projects and outputs to support key Council systems.

Design and implement Azure data factory pipelines to collect and cleanse large volumes of data from source data systems.

Store data in the Azure Data Lake and transform data via Azure SQL database.

Consider how best to model data from disparate systems in line with agreed standards.

Understanding the structure of data in both source/line of business systems and the Business Intelligence Platform.

Design, document and implement logical and physical data models.

Apply appropriate data management techniques.

Understand and translate business needs into data models supporting long-term solutions, working closely with Subject Matter Experts (SME).

Develop innovative reports, data visualisations and dashboards, which meet the business needs, using Microsoft Power BI

Champion the use of Business Intelligence across the Council.

Skills and experience

At least 5 years' experience as a Business Intelligence Developer. Bringing expertise and knowledge that includes, but not limited to the following:

Excellent knowledge of delivering projects within a Microsoft Business Intelligence technical environment
Excellent knowledge of how to build new data sets and structures within the Azure BI environment
Experience working with large, disparate data sets
Strong data modelling experience
Strong knowledge of Data Warehousing methodologies
Knowledge of project management methodologies, Agile/Scrum experience desirable
Business analysis experience, including gathering requirements/user stories and conversion into technical specification for development
Previous experience of working within Local or Central Government is highly desirable, but not essential

Technical Skills:

Essential experience of the following specific technologies:

Azure Cloud technologies
Microsoft Power BI
Azure Analysis Services (Tabular Model) - Design, Develop, Deploy and Maintain
Azure SQL Server/Microsoft SQL (Apply online only)
Relational Database
Advanced TSQL - (Dynamic Views, Stored Procedures, Functions etc.)
PowerShell scripting
Dimensional modelling experience
Query Performance TuningNice to have:

Master Data Management, Delta Lake, Azure Data Flows, Azure Functions, Azure Logic Apps

Non-Technical Skills

A proven ability to develop clear understandings of clients' needs and the ability to incorporate these into a solution
Knowledge of programme, project and performance management techniques and methodologies.
Ability to contribute to project delivery, providing input into planning, issue escalation and resolution
Effective management of conflicting priorities
Good stakeholder management
Good organisational skills
Strong communication skills
Problem solving
Ability to present technical concepts to non-technical audiences

Adecco acts as an employment agency for permanent recruitment and an employment business for the supply of temporary workers. The Adecco Group UK & Ireland is an Equal Opportunities Employer.

By applying for this role your details will be submitted to Adecco. Our Candidate Privacy Information Statement explains how we will use your information - please copy and paste the following link in to your browser