Business Intelligence Developer

  • Location
    South Croydon, Greater London
  • Salary
    £450.00/Daily
  • Category
    IT - Business Intelligence
  • Job type
    Contractor
  • Industry
    IT and Telecoms
  • External Reference
    JN-062021-188336

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: £450 per day (Umbrella)
START DATE: ASAP
DURATION: 4 month contract
IR35 STATUS: Inside



Background


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.


Role


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 2008 - 2016

  • Relational Database

  • Advanced TSQL - (Dynamic Views, Stored Procedures, Functions etc.)

  • PowerShell scripting

  • Dimensional modelling experience

  • Query Performance Tuning


Nice 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 https://www.adecco.co.uk/candidate-privacy












To speak to a recruitment expert please contact Emily Day