Information Systems Developer

Job description

Job responsibilities

• 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

Person Specification

Qualifications

Essential

• Educated to degree level in a related subject or equivalent experience within a development team or department.

Desirable

• ITIL foundation certificate or higher

Experience

Essential

• Good understanding of database architecture and querying best practice using SQL.
• Strong programming experience using languages such as Python, JavaScript, C# or Rust
• Experience of working with teams developing high availability web-services and web-based apps
• Experience with API integrations including REST, JSON and other data integration toolsets
• Experience in developing and deploying to Cloud environments such as Azure

Desirable

• Fullstack web development experience
• Familiarity with frontend web frameworks such as Astro or React
• Familiarity with backend web frameworks such as Express, FastApi and Axum

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Employer details

Employer name

Provide CIC

Address

900 The Crescent

Colchester

CO4 9YQ

Employer's website

https://www.provide.org.uk/ (Opens in a new tab)