ICT BI Assistant

Gillingham
9 months ago
Applications closed

Related Jobs

View all jobs

Data Engineer (18 Months FTC)

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.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

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

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.

What Hiring Managers Look for First in Data Engineering Job Applications (UK Guide)

If you’re applying for data engineering jobs in the UK, the first thing to understand is this: Hiring managers don’t read every word of your CV. They scan it. They look for signals of relevance, credibility, delivery and collaboration — and if they don’t see the right signals quickly, your application may never get a second look. In data engineering, hiring managers are especially focused on whether you can build and operate reliable, scalable data systems, handle real-world data challenges and work effectively with analytics, BI, data science and engineering teams. This guide breaks down exactly what they look at first in your application — and how to shape your CV, portfolio and cover letter so you stand out.

The Skills Gap in Data Engineering Jobs: What Universities Aren’t Teaching

Data engineering has quietly become one of the most critical roles in the modern technology stack. While data science and AI often receive the spotlight, data engineers are the professionals who design, build and maintain the systems that make data usable at scale. Across the UK, demand for data engineers continues to rise. Organisations in finance, retail, healthcare, government, media and technology all report difficulty hiring candidates with the right skills. Salaries remain strong, and experienced professionals are in short supply. Yet despite this demand, many graduates with degrees in computer science, data science or related disciplines struggle to secure data engineering roles. The reason is not academic ability. It is a persistent skills gap between university education and real-world data engineering work. This article explores that gap in depth: what universities teach well, what they consistently miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data engineering.