Analyst Programmer

• Design, develop, support, and maintain ICT business systems, applications, integrations, data solutions, and management reporting within an Agile environment
• Work as part of the Data Engineering team to support the delivery of critical projects and increase internal delivery capacity
• Take development tasks from the DevOps board, understand the customer requirements, and clarify requirements with customers and the wider team where necessary
• Design and build reliable and efficient ETL processes and data flows using appropriate development tools and standards
• Develop, test, troubleshoot, and maintain ETL solutions, resolving issues identified during internal or customer testing
• Use advanced Microsoft SQL Server and T-SQL skills to develop effective database solutions
• Develop and maintain stored procedures, optimise queries, and analyse and understand SQL Server query execution plans to improve performance
• Develop and maintain ETL solutions using SQL Server Integration Services (SSIS)
• Apply data warehousing best practices and appropriate data models and database designs
• Support the development and maintenance of business and customer-facing applications, solutions, integrations, and reporting systems
• Take responsibility across the application development lifecycle, including investigation, analysis, requirements gathering, design, development, testing, implementation, support, and maintenance
• Evaluate technical options, carry out impact analysis, and recommend suitable technical solutions in line with ICT architecture and strategy
• Deliver well-engineered, standards-based solutions that are fit for purpose, reliable, efficient, secure, maintainable, and cost-effective
• Ensure development work follows agreed methodologies, standards, tools, and documentation requirements
• Keep technical documentation and ICT management systems accurate and up to date
• Work closely with Product Owners, business users, ICT teams, customers, and other key stakeholders to understand business processes and deliver suitable solutions
• Arrange, prepare, and participate in meetings, workshops, and presentations with both technical and non-technical audiences
• Support business users during the analysis stage of the software lifecycle and provide post-training and user support where required
• Contribute to project and quality plans, cost-benefit analysis, risk analysis, and other project documentation
• Take ownership of the organisation, documentation, and delivery of small-scale projects, including monitoring progress and providing accurate updates to management and customers
• Work within Agile/Scrum frameworks and contribute effectively to team planning, development, testing, and delivery activities
• Support change management by analysing business processes, identifying improvements, and helping implement appropriate changes
• Build and maintain strong working relationships across ICT, business teams, customers, and stakeholders
• Deliver work efficiently, within agreed timescales and budgets, while maintaining high standards of quality and customer service
• Support the Council’s requirements around equality, health and safety, safeguarding, and climate change responsibilities
• Be flexible and willing to work additional hours when required to meet service demands

• Degree-level qualification, or equivalent experience, in an ICT-related discipline

Knowledge and Experience

• Significant proven experience working in a development environment in a similar role
• Strong experience using development tools, application development methods, techniques, and standards
• Advanced and proven experience with:
• Microsoft SQL Server
• T-SQL
• Stored Procedures
• SQL Query Optimisation
• SQL Server Query Execution Plans
• SQL Server Integration Services (SSIS)
• Good understanding of data warehousing practices, data warehouse design, and data modelling
• Proven experience in software development, data warehousing, reporting, integration, and systems implementation
• Experience with relevant Microsoft technologies, including:
• Microsoft .NET
• Visual Studio
• SQL Server
• SSRS
• SSIS
• SSAS
• Microsoft Office 365
• Microsoft Power Suite
• Practical experience working within an Agile/Scrum environment
• Demonstrable knowledge and experience of Change Management, including analysing business processes, recommending improvements, and implementing changes
• Basic project management experience, with involvement in the successful delivery of small to medium-sized projects
• Experience facilitating or leading workshops and similar meetings
• Experience working with business users, Product Owners, technical teams, customers, and other stakeholders

Skills and Abilities

• Strong written, verbal, communication, and presentation skills, with the ability to communicate effectively with both technical and non-technical audiences
• Able to work independently and use own initiative
• Motivated to learn new skills, develop professionally, and share knowledge with colleagues
• Professional, highly motivated, and self-starting, with a positive “can-do” attitude
• Flexible and able to manage multiple tasks, competing priorities, and tight deadlines while working under pressure
• Highly developed interpersonal skills, including negotiation, influencing, and diplomacy
• Strong ability to build and maintain effective working relationships
• Self-motivated, results-focused, and able to deliver agreed objectives and actions
• Strong team player who works collaboratively with others
• Committed to delivering high-quality systems and solutions for the Council and its users
• Strong customer-focused approach to service delivery
• Willing and available to work flexibly or additional hours when required to meet business demands, * Have you worked on projects where you took requirements from a DevOps board, developed ETL/data solutions, tested them, and troubleshot issues?
• Do you hold a degree or equivalent experience in an ICT-related discipline?
• Which of the following Microsoft technologies have you used professionally?

SQL Server SSIS SSRS SSAS .NET Visual Studio Microsoft Office 365 Power Suite

Experience:

• working with Microsoft SQL Server: 2 years (required)
• T-SQL, including complex queries and stored procedures: 2 years (required)
• SQL query optimisation and analysing SQL Server execution: 2 years (required)
• SQL Server Integration Services (SSIS): 2 years (required)
• ETL development and data warehousing: 2 years (required)
• data modelling and data warehouse design: 2 years (required)
• working in an Agile/Scrum: 2 years (required)