About this role
Salary: £33,000 - 47,000 per year
Requirements
- Demonstrable experience using AI coding assistants and writing effective prompts, supported by practical examples of workflows or agents built.
- Substantial SQL programming experience and strong knowledge of Microsoft SQL Server 2017 or later.
- Strong SQL Server T-SQL development and performance-tuning skills, including experience supporting SQL Server in a large-scale environment.
- A strong grounding in data modelling, data management and data manipulation.
- Experience with Git and version control, and attention to detail.
- Ability to investigate problems independently, collaborate with colleagues, and communicate clearly in writing and in person.
- Excellent teamwork, communication and documentation skills.
- Curiosity, adaptability and good judgement when assessing AI-generated output.
- Desirable: Experience building agents or multi-agent workflows using Claude Code, MCP or similar frameworks.
- Desirable: Familiarity with LLM APIs, evaluation approaches and prompt testing.
- Desirable: Scripting or programming experience in Python or a similar language.
- Desirable: Awareness of AI data protection and security considerations.
- Desirable: A reasonable understanding of operating systems, infrastructure and networking.
Responsibilities
- Use AI coding assistants such as Claude Code or GitHub Copilot across the development lifecycle, including code generation, refactoring, testing, documentation and review.
- Build and maintain prompts, system instructions, reusable skills and context to produce consistent, reliable AI outputs.
- Design and orchestrate agents and multi-agent workflows, including task decomposition, tool use, agent hand-offs and human-in-the-loop checkpoints.
- Connect agents to internal systems, databases and APIs, for example through MCP or function calling.
- Evaluate AI output for accuracy, regression, cost and latency, and refine workflows based on results.
- Apply safeguards for data privacy, security and hallucination risk, particularly when customer or school data is involved.
- Identify and prototype opportunities to apply AI to development and data migration, and support and coach colleagues by sharing best practice.
- Design, develop and maintain scalable SQL Server T-SQL solutions and related tools for data cleansing, migration and reconciliation.
- Provide database performance-tuning expertise for internal and third-party systems, using AI tooling where appropriate.
- Define technical requirements with non-technical colleagues in the Data Migration Team, and work with third parties to understand their software and support migration projects.
- Manage SQL Server database environments used for data migration, including backup and recovery in test environments.
- Prepare and safely expose data for agents and AI workflows, using AI to support SQL query generation, code review and optimisation.
- Plan and prioritise work independently, managing tasks against project timelines and requirements.
Technologies
- AI
- Claude Code
- Copilot
- Git
- GitHub
- Support
- LLM
- MCP
- Python
- SQL
- Security
More
We are Bromcom, an equal opportunities employer. This is a dual role, split approximately 60% between AI-assisted development and agent orchestration and 40% between SQL Server development supporting large-scale data migration. You will work within our development team and report to the Software Manager, combining practical AI skills with strong SQL expertise to deliver reliable, efficient solutions.
last updated 46 week of 2026