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.
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.
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