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