Position: Analyst Programmer (Interim (Day Rate))
Location: Floor First, Staffordshire Place 1, ST16 2DH
Start Date: ASAP
Contract Duration: 7+ Months (Temporary contract)
Working Hours: 37 hours per week
Pay Rate: PAYE: £281.12 per day
Job Responsibilities
- 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
Person Specification
Qualifications
- 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
Job Reference: 5302357
Job Types: Full-time, Temporary, Fixed term contract
Contract length: 7 months
Pay: £281.12 per day
Application question(s):
- 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)
Work authorisation:
- United Kingdom (required)
Work Location: In person
