ICT BI Assistant

Gillingham

11 months ago

Applications closed

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

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Apr 9, 2026

Products

Where to Advertise Data Engineering Jobs in the UK (2026 Guide)

Advertising data engineering jobs in the UK requires a different approach to most technical hiring. Data engineers occupy a distinct discipline that sits between software engineering, data science and cloud infrastructure — and the strongest candidates identify firmly with the data engineering community rather than with adjacent roles. General job boards consistently conflate data engineering with data analysis, data science and BI development, producing high application volumes but low candidate quality for specialist pipeline and platform roles. This guide, published by DataEngineeringJobs.co.uk, covers where to advertise data engineering roles in the UK in 2026, how the main platforms compare, what employers should expect to pay, and what the data says about hiring across different role types.

Mar 24, 2026

Jobs

New Data Engineering Employers to Watch in 2026: UK and Global Companies Driving the Data Revolution

Data engineering is at the heart of the digital economy, transforming raw data into actionable insights, powering analytics, AI systems, and cloud infrastructure. As the UK and global markets continue to invest heavily in data platforms, pipelines, and real-time analytics, demand for skilled data engineers is growing rapidly. For professionals exploring opportunities on www.DataEngineeringJobs.co.uk , the critical question is: which companies are expanding, hiring, and shaping the future of data-driven business? This article highlights new data engineering employers to watch in 2026, including UK startups, scale-ups, and international firms expanding in the UK.

Feb 10, 2026

Careers

How Many Data Engineering Tools Do You Need to Know to Get a Data Engineering Job?

If you’re aiming for a career in data engineering, it can feel like you’re staring at a never-ending list of tools and technologies — SQL, Python, Spark, Kafka, Airflow, dbt, Snowflake, Redshift, Terraform, Kubernetes, and the list goes on. Scroll job boards and LinkedIn, and it’s easy to conclude that unless you have experience with every modern tool in the data stack, you won’t even get a callback. Here’s the honest truth most data engineering hiring managers will quietly agree with: 👉 They don’t hire you because you know every tool — they hire you because you can solve real data problems with the tools you know. Tools matter. But only in service of outcomes. Jobs are won by candidates who know why a technology is used, when to use it, and how to explain their decisions. So how many data engineering tools do you actually need to know to get a job? For most job seekers, the answer is far fewer than you think — but you do need them in the right combination and order. This article breaks down what employers really expect, which tools are core, which are role-specific, and how to focus your learning so you look capable and employable rather than overwhelmed.