Senior Dara Architect; OutSystems, SQL server, Azure, Tsql, Governent, Healthcare, public sector

OutSystems (Primary), MS SQL Server/Azure SQL, REST/OData, Fast Healthcare Interoperability Resources (FHIR). Salary - Open MUST HAVE security Clearance Permanent Location: Leeds Key Responsibilities Production Data Modelling: Evolve Alpha prototypes into a highly normalized, performant schema within OutSystems, ensuring relational integrity and scalability for thousands of users. Sensitive Data Security: Design and implement "Secure-by-Design" patterns, including Row-Level Security (RLS), Data Masking, and At-Rest Encryption to protect sensitive demographics. Data Interoperability: Architect data exchange patterns using HL7 FHIR (R4/R5) via REST and OData to ensure seamless integration with the wider ecosystem. GDS Assessment Leadership: Act as the lead for GDS Point 10 (Define the data architecture), defending data minimisation, retention, and ethical usage during service assessments. Integration Governance: Define "Data Contracts" for third-party integrations, managing complex OData/REST syncs and data provenance. 1. Database Technology Specialty MS SQL Server/Azure SQL Mastery: Advanced T-SQL, performance tuning (execution plans, indexing), and concurrency management. Database Hardening: Experience with Transparent Data Encryption (TDE) and building immutable audit logs for sensitive data access. 2. Government Standards Interoperability: Deep understanding of Data Model and Dictionary. Compliance: Familiarity with DCB0129/0160 (Clinical Safety) and the Data (Use and Access) Act 2025. GDS Experience: Proven track record of taking a project through a successful GDS Beta Assessment. Candidate Capabilities (Soft Skills) Strategic Bridge: Ability to explain complex data trade-offs to non-technical stakeholders and GDS assessors. Problem Solver: Capable of deg "Fail-Safe" logic for integrations with external Legacy healthcare databases. Ethical Mindset: A "-First" approach to data, ensuring patient confidentiality is baked into every architectural decision. Experience Required 7+ years in Data Architecture, with at least 3 years in a UK Government environment. Proven experience delivering enterprise-grade applications on the OutSystems platform. Experience with OData and RESTful API design for secure healthcare data transit.