SQL Developer, Bromcom

• You’ll combine hands-on AI-assisted development skills with substantial SQL Server experience. You’ll be curious and adaptable, communicate clearly, and use good judgement to assess AI-generated output rather than accepting it uncritically
• Demonstrable experience using AI coding tools and writing effective prompts, with practical examples of workflows or agents you have built
• Substantial SQL programming experience and strong knowledge of the techniques and capabilities of Microsoft SQL Server 2017 or later
• A strong grounding in data modelling, data management and data manipulation, alongside Git, version control and attention to detail
• The ability to investigate problems independently, collaborate with colleagues and communicate clearly in writing and in person
• Practical experience with AI coding assistants and strong prompting skills, supported by examples
• Strong SQL Server T-SQL development and performance tuning, including experience supporting SQL Server in a large-scale environment
• Experience with Git and version control
• Excellent teamwork, communication and documentation skills

Desirable

• This is a dual role, split between approximately 60% AI-assisted development and agent orchestration, and 40% SQL Server development supporting large-scale data migration. You’ll work within the development team and report to the Software Manager, combining practical AI skills with strong SQL expertise to deliver reliable, efficient solutions
• 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 effective 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 appropriate 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 share best practice by supporting and coaching colleagues
• 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 expose data safely 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