ICT BI Assistant (housing experience a plus) Gillingham £37,123 Code Red are currently working with a public sector client of ours who are currently looking to appoint a ICT BI Assistant to their team. About the role: You’ll be working with the ICT & DBA Administrator to provide the datasets and build integrations between databases to help inform decision-making and solve business problems by converting data into information. Responsible for selecting relevant data from data warehouses, manipulating large datasets and building decision models you’ll work closely with the Business Improvement team to facilitate delivery of performance and operational data. You’ll have an interest in data and have a keen eye for accuracy.Responsibilities: Ensuring that the design and operation of the BI solutions are appropriate to meet the information and decision support requirements of the business. Liaising with Business Improvement team to develop BI solutions Ad hoc data analysis for internal users Developing the appropriate solution, Reports or Cubes using the Microsoft BI Suite as per the technical specifications Supporting and maintaining existing database and BI systems Implementing changes to existing BI systems Writing and reviewing SQL Code and SSIS packages to ensure compliance with the defined standards and best practices and ensure optimal performance when released to the production environment Logging report requests and support details in the helpdesk management software and updating progress to resolution. Maintaining full documentation for BI solutions and related services together with associated communications documents Embracing and driving a continuous improvement culture, using data to identify where changes could benefit the business and the customer Knowledge of SQL with ability to write and edit views, stored procedures and ad-hoc queries A desire to learn new skills and technologies Experience of Microsoft SQL Server Reporting Services (SSRS) (2012 and above)Desirable: ETL Tools, techniques and methodologies Microsoft SQL Server Integration Services (SSIS) Microsoft SQL Server Analysis Services (SSAS) Experience / Knowledge of Multi-Dimensional Data modelling Experience / Knowledge of Data Mining Experience / Knowledge of Pivot Tables and/or Power Pivot Experience / Knowledge of SQL Operations Studio A background in programming, coding or scripting such as Python An analytical mindset and understanding of how data can support business processesQualifications: GCSE Grade C or above in Mathematics or equivalent full Level 2 Mathematics qualification We act as an Employment Agency/Business with regards to this vacancy. As an Equal Opportunities employer we welcome applications regardless of race, gender, nationality, ethnic origin, sexual orientation, religion, marital status, disability or age. All applicants are considered on the basis of their merits and abilities for the job. By applying to a job advertised by us, or providing your contact information to show interest in a job advertised by us, you consent to the disclosure of your information to us in order to assist our legitimate business needs. This includes agreeing for us storing your information and allowing us to contact you in regard to suitable job opportunities. You are within your rights to ask us to remove your information at any time