Lead BI Developer

ICS.AI Limited; Basingstoke; Remote; GBP 45,000 - 55,000; Full time

Job summary

A leading AI solutions provider is seeking a Lead BI Developer to design and implement business intelligence solutions. This role involves developing analytics frameworks using Power BI and Azure, and transforming data into actionable insights. The ideal candidate has over 5 years of experience in data analytics and a solid understanding of ETL processes. The company offers flexible remote working, private healthcare, and an enhanced pension scheme.

Benefits

Flexible and remote working options

Enhanced pension scheme (5% employer contribution)

25 days of holiday plus bank holidays

£1,200 annual work-from-home allowance

Private healthcare package (Vitality)

Qualifications

• 5+ years’ experience in data analytics or business intelligence development.
• Strong experience with Power BI, Azure Synapse, and SQL-based solutions.
• Proficiency in ETL development tools.

Responsibilities

• Develop and implement business intelligence solutions using Power BI.
• Build and maintain ETL pipelines and data models.
• Create dashboards and reports that deliver actionable insights.

Skills

Power BI

Azure Synapse

SQL

ETL development

Python

R

Data manipulation

Data governance

Communication skills

Tools

Azure Data Factory

SSIS

Logic Apps

Job description

Job Title: Lead BI Developer

Location: Remote

Salary: £45,000 - £55,000 per annum

Contract Type: Full-time, Permanent

About Us

ICS.AI is the UK's market leader in Artificial Intelligence (AI) solutions for local government, partnering with over 20 councils to revolutionise public service delivery. As a Microsoft-sell partner, we combine cutting‑edge AI technology with deep sector expertise to deliver exceptional value through our core solutions: AI Contact Centres, AI Staff Copilots, and Social Care AI Copilots. With our head office in Basingstoke, delivery office in Leamington Spa, and satellite offices throughout the UK, we're transforming how the public sector delivers services.

About the Role

We’re seeking a talented Lead BI (Business Intelligence) Developer to join our growing Analytics and AI Engineering team.

In this role, you’ll design, build, and optimise BI and data solutions that power our next generation of AI‑driven platforms and client analytics. You’ll work across both product development and client delivery—transforming complex datasets into clear, actionable insights that support smarter decision‑making and measurable public service outcomes.

You’ll have the opportunity to work with modern Azure data tools, Power BI, and emerging AI‑driven analytics techniques such as Retrieval‑Augmented Generation (RAG) and vector‑based data modelling to support explainable, intelligent reporting.

This is a fantastic opportunity for an experienced BI Developer to shape how AI and analytics come together to drive real impact across the UK public sector.

Key Responsibilities

• Develop and implement end‑to‑end business intelligence solutions using Power BI and Azure data services
• Build and maintain ETL pipelines, data models, and analytics frameworks
• Collaborate with engineering, delivery, and client teams to design scalable BI architectures
• Ensure data quality, accuracy, and governance compliance across internal and client datasets
• Create dashboards, reports, and data visualisations that deliver actionable insights
• Support AI transformation projects with data analysis, telemetry, and performance tracking
• Contribute to pre‑sales demonstrations, analytics proposals, and technical estimates
• Research and evaluate emerging BI and AI tools to enhance data capability and innovation

Required Skills and Experience

• 5+ years’ experience in data analytics or business intelligence development
• Strong experience with Power BI, Azure Synapse, and SQL‑based solutions
• Proficiency in ETL development (Azure Data Factory, SSIS, or Logic Apps)
• Solid understanding of data modelling, visualisation, and governance principles
• Hands‑on experience with Python or R for data manipulation and analytics
• Exposure to AI‑integrated BI environments (e.g., Azure Fabric, Cognitive Services, or OpenAI)
• Excellent communication skills, with the ability to translate data insights for non‑technical audiences
• Experience working in public sector, higher education, or consulting environments (desirable)

What We Offer

• Flexible and remote working options.
• Enhanced pension scheme (5% employer contribution).
• 25 days of holiday plus bank holidays.
• £1,200 annual work‑from‑home allowance.
• Private healthcare package (Vitality).

Eligibility Requirements

Applicants must have the legal right to work in the UK. Unfortunately, we cannot offer visa sponsorship for this role.

A full Role Profile is available upon request