Job Specifications
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
About the Company
If you’re looking for a partner who is passionate about Artificial Intelligence then you’ve come to the right place The AI Transformation revolution has begun. Significant value is waiting to be unlocked through the positive and progressive use of Artificial Intelligence – by re-engineering the old and re-imagining the new. AI Transformation builds on and supersedes Digital Transformation. Artificial Intelligence overcomes the challenges of user engagement with conversational interfaces, evolves as your challenges do with ma...
Know more