Sentinel
03/05/2024
Full time
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