Head of Database Develpoment/BI - London, United Kingdom - Sentinel

    Default job background
    Description

    Job Description

    Head of BI - SSIS, SSRS, SQL Server, CRM

    Do you want to work for a business that is truly making a difference to peoples lives?

    A healthcare charity are looking for a new head of database development and BI, to lead their BI function whilst developing, delivering and leveraging their 2 CRM systems. Acting as a Project manager for system upgrades, data warehouse deliveries etc.

    Key Responsibilities

    Create annual database and BI operating plans, taking responsibility for the annual budget and plan for the database and BI function.

    Develop, implement and review data platform strategy, including potential migration to cloud-based solutions like Microsoft Azure, etc.

    Line-manage Database developer & BI analyst roles and CRM training specialist

    Be a key member of the digital transformation group.

    Oversee Database administration.

    Ensure continued availability of the data systems

    Oversee, challenge and sign off new business requirements relating to changes in the CRM systems and data warehouses.

    Revising the suitability of the data warehouse and its associated data model, refining the design of the data models where required.

    Liaise with CRM/SQL vendors.

    Ensure all datasets have appropriate levels of data governance and maintain up-to date knowledge of GDPR and legislation.

    Oversee the management of CRM/BI/Data warehouse issues.

    Be the key contact for database queries.

    Optimise use of SQL, SSIS,SSRS, Microsoft Visual Studio, etc

    Essential Skills

    Degree educated (or equivalent experience) in a relevant field

    Advanced knowledge of SQL, including building complex queries and administrative scripts

    Data validation and manipulation techniques using SQL, Visual Basic (including Excel macros, linked workbooks and pivot tables)

    Experience in programming languages commonly used for data analysis, such as Python, R or Scala.

    Advanced knowledge of ETL tools such as SSIS, SSRS MS Visual Studio, SQL Server 2008R2 and 2017, stored procedures, and the associated implementation of automations.

    Strong requirements specification and documentations skills and project management experience.

    Knowledge of current and evolving tends in data and information management.

    Excellent communication and interpersonal skills with the ability to provide and receive complex and often sensitive information.

    Professional, confident approach able to engage with colleagues at all levels.

    Head of data/Data warehouse/Database Administrator/Database Administration/DBA/CRM/Salesforce