Banner Default Image
Back to job search

Business Intelligence Analyst / Data Analyst

  • Location:

    Redhill

  • Sector:

    Data Management, Data and Analytics

  • Job type:

    Permanent

  • Job functions:

    Data Analyst

  • Salary:

    £42000 - £42500 per annum

  • Contact:

    Laura Fox

  • Contact email:

    laura.fox@lafosse.com

  • Job ref:

    lfrhbi_1628178443

  • Published:

    about 1 month ago

  • Expiry date:

    2021-09-16

  • Startdate:

    ASAP

Permanent - £42,500 - Business Intelligence Analyst / Data Analyst - 50% remote, 50% Surrey

My client, a Housing Association recognises that data has an important role in the future success of the business.

They are embarking on a Digital Transformation programme and they need to have the right BI structure in place to provide the business with insights from various data sources.

Key Accountabilities:

Overall responsibility for delivery of SQL based BI tools, specifically:

  • The creation and maintenance of a SQL based Data Warehouse

  • The integration of commercially available BI insight tools in particular PowerBI

  • To help identify areas of poor data quality and provide support in data cleansing

  • To provide sub-sets of data to support processes across the business including Subject Access Requests or similar business requirements

  • To support the migration and cleansing of data between systems working with internal and external resources.

  • To support all aspects of data security complying with controls, policies and procedures as set out by the IT security manager.

Knowledge:

  • MS SQL Server T-SQL, SSRS and SSIS are essential

  • An understanding of Data Warehouse development and the concepts of ETL are essential

  • A previous history of working with APIs is desirable

  • An understanding of MS SQL Server DBA principles is desirable

  • An understanding of Data Governance principles is desirable

  • Exposure to commercially available BI tools such as PowerBI

  • Problem solving/ analytical skills will be core to the post holder's success

  • Detail and success orientated

  • Able to build relationships with key stakeholders

  • Good experience of manipulating data with SQL or similar ETL

  • Experience working in the Microsoft Power Platform and Azure technology stack, including Dev Ops

  • Experience in developing PowerBI dashboards and reports

  • Experience of working in a project change environment

  • Experience of working on their own or in a team environment