Data Warehouse Technical Lead (Outside IR35)
Certain Advantage are hiring for a Data Warehouse Technical Lead for a 12-month assignment, based in Leatherhead, Surrey
The role is on a hybrid basis. 3 days in the office, 2 days remote.
Your responsibilities:
- Experience developing, deploying and supporting multi-data source SQL data warehouses in an on-premises environment
- Experience of the full Microsoft Stack – SSIS, SSRS and SSAS
- Experience creating, documenting and developing data models to deliver management information outcomes
- Experience developing ETL procedures from multiple data sources to one data source
- Adept at building collaborative technical and business working relationships to deliver outputs and outcomes
- Experienced in a second-line technical resolver support environment, able to identify technical issues and manage from root cause to rectification
- Experience of using Paginated Reports for Power BI to deploy paginated reports into Azure to management information consumers
- Experience of creating on-prem data warehouse that provides data to a Cloud Azure instance/Power BI/SharePoint
The individual:
- Experience of creating ETL routines from client data sources where data quality/integrity may be an issue
- Experience of VBA and .BAT programming
- Experience of scrum teams & sprint ceremonies
- Experience of leading/contributing to technical and data governance
- Experience of collaborating in a MS Teams environment
- Knowledge of the Facilities Management industry
- Experience of delivering projects to or for public sector clients
#J-18808-Ljbffr