Information Systems Specialist Automation and AI

This specialist technical lead post at Sheffield City Council sits within its digital transformation programme, focused on automation and artificial intelligence. The postholder designs, builds and supports Power Platform solutions, automated workflows and AI-enabled services, and troubleshoots the problems that arise in them. The work centres on Microsoft Copilot, Power Automate and Power Apps, and includes mentoring colleagues and advising on governance and security.

Fit depends on hands-on Copilot Studio and Power Platform build experience, plus knowledge of Dataverse, integration and data protection controls.

• Design, build, support and improve Power Platform solutions, automated workflows, digital services and AI-enabled services
• Support the development and governance of Microsoft Copilot, Power Automate and Power Apps against approved standards and policies
• Act as specialist technical lead, giving expert advice on automation, systems integration, governance and service improvement
• Lead complex technical investigations, support project delivery and mentor colleagues
• Ensure solutions are reliable, scalable and accessible, and meet security, information governance and technical design requirements
• Troubleshoot defects, performance and technical problems across websites and applications
• Contribute to testing and quality assurance across the team
• Improve accessibility, usability, performance and security
• Work with technical colleagues, suppliers, officers, business change managers, team managers and stakeholders to understand user needs
• Contribute technical expertise across the solution lifecycle, from proof of concept to deployment and ongoing support
• Evaluate emerging technologies and contribute to proof-of-concepts and pilot projects
• Take part in technical discussions and continuous development activities

• Integrating systems using APIs, connectors, Microsoft 365, SharePoint and external applications
• Monitoring, troubleshooting and supporting apps, flows, agents and integrations to operational service levels

• Specialist development skills in Power Apps, Power Automate, Dataverse and Copilot Studio, building scalable solutions
• Designing and configuring Copilot agents, including knowledge sources, actions, orchestration, prompt design and conversation flows
• Business process analysis and automation using low-code and AI
• Knowledge of SQL and data modelling
• Information governance, GDPR, security, DLP and role-based access controls in Power Platform and AI solutions
• Application lifecycle management, environment management and Dev/Test/Production deployment

• Technical leadership, mentoring and expert advice
• Awareness of emerging technologies, responsible AI and governance frameworks

• Generous holiday entitlement
• Flexible working, including reduced hours, part-time working or job share
• Guaranteed Interview scheme for disabled applicants, care leavers and armed forces veterans who meet the essential criteria
• Starting salary at the bottom of the grade, or at the point of minimum advantage with payslip evidence of higher basic pay