Information Systems Developer

Posting date:	20 June 2025
Salary:	£46,148.00 to £52,809.00 per year
Additional salary information:	£46148.00 - £52809.00 a year
Hours:	Full time
Closing date:	04 July 2025
Location:	Colchester, CO4 9YQ
Company:	NHS Jobs
Job type:	Permanent
Job reference:	B9828-25-0151

Summary

Design and Maintain Data Workflows Develop, document, and maintain robust ETL processes that: Ingest raw data from multiple sources (databases, APIs, file feeds) Cleanse and transform datasetshandling missing values, normalization, and formattingso downstream systems receive accurate, standardized inputs Load processed data into live systems, data warehouses, and analytical workflows Build and optimize SQL queries and stored procedures to support data transformation and retrieval tasks Monitor daily ETL jobs, addressing failures or performance bottlenecks; perform regular housekeeping such as index defragmentation and statistic updates. Project Leadership and Coordination Lead larger technical initiativesdefining project scope, deliverables, and timelines Coordinate task assignments among team members, ensuring each contributor understands responsibilities and deadlines Facilitate regular progress check-ins, adjusting plans based on feedback, risk assessments, and evolving requirements Liaise with external vendors or third-party service providers when projects involve external systems or integrations Ensure Code Quality and Best Practices Adhere to coding standards across SQL scripts, ETL pipelines, and application codeensuring readability, maintainability, and consistency Use Git to manage changes; enforce branching strategies, pull requests, and peer reviews before merging Document all processes, data models, and code modules thoroughly; maintain up-to-date technical specifications Conduct periodic code reviews, providing constructive feedback to colleagues and championing improvements in style, performance, and security Investigate and Improve Data Quality Proactively identify data anomalies, inconsistencies, and integrity issues by: Conducting root-cause analysis on recurring data errors or mismatches Reviewing source data feeds and transformation logic to pinpoint upstream issues Recommend and implement fixes and improvements to existing systems Create automated validation scripts or monitoring alerts to detect/prevent future data quality issues Develop and Maintain Integrations and Applications Build back-end REST APIs (using frameworks such as Python FastAPI or Rust Axum) to: Automate data ingestion from external services (e.g., partner systems, third-party data providers) Expose data to internal applications and analytical tools Design and develop front-end solutions for business users: Use modern web frameworks (Astro, React) or low-code platforms to create interactive dashboards, forms, and data-entry interfaces Ensure interfaces follow best-practice UX/UI guidelines, are responsive, and perform well under load Collaborate with the BI team to integrate new reports or update existing dashboardsaligning on data definitions, visualization standards, and access controls Manage Cloud and On-Premise Infrastructure Maintain SQL Server instances (on-premise or in the cloud): Monitor server health, resource usage, and database performance Configure backups, failover clustering, and disaster-recovery plans to ensure high availability and redundancy Oversee cloud resources in Azure and AWS: Deploy, configure, and scale virtual machines, containers, serverless functions, and storage accounts Implement security best practicesnetwork security groups, role-based access control, encryption at rest/in transit, and regular patching Perform routine system housekeeping: Monitor logs and alerts for irregularities or performance degradation Update security certificates, firewall rules, and intrusion-detection configurations as needed Test and validate new environment configurations before production rollout Collaborate with Cross-Functional Teams Partner with Business Intelligence (BI), clinical, and non-clinical stakeholders to: Gather detailed requirements for new reports, data models, or analytics use cases Translate business questions into technical specificationsadvising on data availability, constraints, and potential solutions Deliver walkthroughs of new tools, dashboards, or processes; gather feedback to iterate and refine Work closely with IT operations, network, and security teams on: Infrastructure upgrades, patch deployments, and security assessments that impact data systems Any escalations where complex technical expertise is required to resolve critical issues Serve as a Technical Escalation Point Act as tier 3 support when the service desk or level-2 teams cannot resolve incidents due to complexity: Triage incoming support tickets, identify root causes, and propose corrective actions Provide on-call availability for critical outages affecting data pipelines, integrations, or production environments Document incident resolutions to streamline future troubleshooting efforts Plan, Specify, and Deploy Technical Solutions Analyze complex business requirementsconsider multiple architectural options (on-premise vs. cloud, relational vs. NoSQL, monolith vs. microservices) Produce detailed specifications for new software modules, data models, or system integrationsensuring alignment with organizational standards and regulatory requirements Liaise with multiple technical teams, hardware vendors, and third-party suppliers to: Procure necessary hardware or licenses, coordinate deliveries, and schedule installations Verify that deliverables meet specifications, performing acceptance testing and sign-off Oversee deployments of new applications or process changes: Schedule releases, communicate maintenance windows to stakeholders, and validate rollback plans Ensure all changes go through formal change-control processes, with proper approvals and documentation Foster Continuous Learning and Provide Mentorship Keep individual technical skills up to datemonitor national guidance, industry trends, and emerging technologies relevant to data, cloud, and application development Propose updates to departmental policies, best-practice guidelines, and technical standards based on new knowledge or shifting regulatory requirements Guide and support junior developers and analysts by: Assisting with onboarding and inductionproviding overviews of architectural diagrams, codebases, and development workflows Delivering training sessions on topics such as SQL optimization, API design, or cloud service provisioning Reviewing their work, offering constructive feedback, and helping them develop troubleshooting skills Identify recurring service-desk calls caused by user knowledge gaps; collaborate with Learning & Development to create training materials, documentation, or FAQs that reduce ticket volume Manage Finance/Resource Responsibilities Ensure the efficient and safe use of IT equipmentcoordinate repair and preventive maintenance for servers, workstations, and network appliances Collaborate with procurement when new hardware, software licenses, or cloud resources are requiredevaluating cost implications and recommending budget-friendly options Use Information Resources and Reporting Oversee planning, development, and rollout of IT infrastructure and server-related projects, such as setting up new database clusters or migrating services to the cloud Maintain high-quality, up-to-date databasesperform audits, data cleanups, and schema migrations as needed Regularly collate and analyze performance metrics for systems, applications, and supplierspresent findings in written reports that highlight trends, risks, and opportunities for improvement Ensure all work (from code changes to infrastructure updates) is thoroughly recorded in line with organizational procedurescomplying with audit requirements and change-control policies General Autonomy and Decision-Making Plan and prioritize your own workloadbalance project deliverables, support tasks, and continuous-improvement efforts without constant supervision Interpret broad policies and national guidance to define departmental processesmaking judgment calls on how best to implement or adapt them in complex, technical scenarios Act as the lead specialist in your areapropose, develop, and implement process improvements that enhance team efficiency and system reliability Patient-Care Interaction (Incidental) Recognize that while there is no direct patient-care responsibility, some data-driven projects will indirectly support clinical teams; maintain sensitivity to privacy regulations (e.g., GDPR, HIPAA) when handling patient-related data