Job Description
1. Core Purpose
To lead the technical transition of onshore SQL Database resources into certified Epic ODBA and Cogito professionals. You will manage the dual-track of Technical Environment Build (Infrastructure) and Workforce Transformation (Training), ensuring the "Human Capital" is as ready for Azure as the "Platform" is.
2. Key ResponsibilitiesA. Workforce Transformation & Training Roadmap
* Skills Gap Mapping: Assess existing onshore SQL DB skills against the rigorous requirements of Epic's Chronicles (ODB) and Clarity/Caboodle (Cogito) architectures.
* Certification Management: Design and enforce a strict training timeline to ensure all team members achieve Epic ODBA and Cogito Fundamentals certifications by the May-26 deadline.
* Knowledge Retention: Strategy development to ensure "Onshore" remains the primary support model, reducing dependency on external consultants and keeping intellectual property within the Trust/Organization.
B. Technical Sprint Planning (Azure & Epic)
* Backlog Grooming: Translate complex Epic infrastructure requirements (e.g., setting up the Cogito Data Warehouse on Azure) into digestible Agile user stories.
* Sprint Execution: Lead the "Tech-Build Squad" in the deployment of ODBA environments, ensuring high-availability and disaster recovery protocols align with Barclays/NHS standards.
* Dependency Mapping: Coordinate with the Azure Platform Engineers to ensure the underlying storage and compute are optimized for the heavy I/O demands of an Epic database.
C. Onshore Resource Coordination
* Squad Leadership: Act as the Scrum Master/Delivery Lead for the onshore SQL-to-Epic transition team.
* Stakeholder Liaison: Work closely with Magda (Data Mgmt) and Vibhor (Purview) to ensure the Cogito reporting layer integrates seamlessly with the Purview data governance framework.
* Performance Tracking: Monitor "Velocity" not just in terms of code, but in terms of learning milestones and certification pass rates.
3. Required Technical Background
* Legacy SQL Mastery: Deep understanding of SQL Server, T-SQL, and traditional ETL processes.
* Epic Ecosystem Knowledge: Familiarity with the Epic 3nd-tier architecture (Caché/IRIS, Clarity, Caboodle).
* Azure Infrastructure: Understanding of Azure SQL Managed Instances, Azure Data Lake Storage (ADLS), and Synapse Analytics.
* Agile Proficiency: Expert level in Jira/Azure DevOps (ADO) for tracking technical delivery.
4. Critical Success Factors (The "Definition of Done" for Jun-26)
* Certification: 100% of identified onshore SQL staff are ODBA/Cogito certified.
* Environment Readiness: The Cogito Data Warehouse is fully provisioned on Azure and passing performance stress tests.
* Governance: All new Epic data structures are registered and classified within Microsoft Purview.