SQL Server Developer Lead

Job Description: • Senior SQL Server developer with experience in programming, design and integration of data warehouse and data distribution platforms. • Designs, builds and optimizes T‑SQL code (stored procedures, functions, views) and data models to produce trusted security/risk reporting and records-management-aligned datasets. • Engineers resilient batch and near‑real‑time data processing, with strong data profiling, root-cause analysis and incident/problem management. • Owns performance tuning and capacity considerations for SQL Server workloads (query plans, indexing strategy, partitioning, statistics, IO/CPU optimization) to meet SLAs. • Works with engineers, analysts and control owners to translate security, risk and records-management requirements into robust schema, data quality rules, lineage and reconciliations; ensures solutions are testable, supportable and compliant. • Leads by example through peer reviews, coding standards, release discipline and mentoring; proactively manages delivery risks and dependencies across data platform, security, risk and governance stakeholders. Key Accountability: • Owns end-to-end delivery of SQL Server components for security, risk, control and records-management use cases: requirements capture, technical design, build, code review, deployment and documentation, aligned to agreed engineering standards. • Implements robust testing and quality controls (e.g., tSQLt/unit tests, data quality checks, reconciliations) and supports SIT/UAT/release cycles. • Ensures database solutions meet security and records-management requirements (classification, retention, access controls, segregation of duties, logging/audit trails), partnering with risk and platform governance as required. • Designs and evolves data models and physical schema that support security metrics, control monitoring and MI, with clear lineage and interfaces to upstream/downstream data products. • Provides operational support for production services (monitoring, incident triage, problem management, remediation and performance optimization) and drives continuous improvement through automation and standardization. Person Specification: • The role holder must be a strong computer scientist with a good appreciation of the fundamental principles of relational database technology. • The role holder must have strong time management skills and be able to juggle and complex and demanding workload. • The candidate will be educated to degree level or above, preferably in computer science or a closely related discipline. • The role holder will have an excellent command of English language with strong written and verbal communications to deliver against our commitment to providing a world class service and drive our dedication to the client experience. Essential Skills/Basic Qualifications: • Expert T‑SQL development (complex query design, stored procedures/functions, set-based approaches) with strong code quality and review discipline. • Strong SQL Server performance engineering (execution plans, indexing, partitioning, tempdb, concurrency) and ability to diagnose production issues under pressure. • Testing mindset and automation: tSQLt (or equivalent), data quality assertions, and ability to produce repeatable evidence for security/risk/control reporting. • Good understanding of secure database development and data controls (access management, auditing, sensitive data handling) and confidence engaging with security and risk stakeholders. Desirable skills/Preferred Qualifications: • Source control and branching strategies (Git/GitLab), pull requests, and code review standards. • CI/CD tooling (e.g., GitLab) and release automation for database deployments. • Artefact/repository management (e.g., Nexus) and dependency/version control. • Scripting/automation (e.g., PowerShell and Linux shell scripting, plus Python where needed) and familiarity with server scheduling/orchestration patterns. • Data governance/records management awareness (retention and evidencing) and how these apply to data products and reporting. • Working knowledge of Java and/or Scala particularly where used alongside Spark-based data processing. Stakeholder Management and Leadership: • Key stakeholders within the team are the Lead Product Owner, Data Analysts, PM/scrum masters and Technical Leads. • Key stakeholders external to the team are the Wealth Enterprise Architects and BAs and architects on other platform or project teams that interface to PBTV.