Data Warehouse Developer - London

- Build, extend, and optimise data flows relating to Oracle GL and PRISM positions across staging, core, and reporting layers. - Design and implement new ETL/ELT transformations to support enriched data requirements. - Ensure robust, scalable pipelines that align with existing DW patterns and architectural standards. - Design or modify data models to accommodate new PRISM position attributes. - Ensure data consistency, referential integrity, and alignment with business rules. - Tune SQL queries, optimise ETL performance, and resolve bottlenecks. - Add or update validation rules, data quality checkpoints, reconciliations, and monitoring scripts. - Support defect analysis and resolution across SIT/UAT cycles. - Partner with Finance, Reporting, Risk, and Infrastructure teams to ensure functional and technical alignment. - Support production deployments, release planning, and post go-live troubleshooting. - Produce technical design documents, data mapping artefacts, lineage diagrams, and runbooks. - Ensure all development is version controlled and follows bank governance, standards, and SDLC processes. - Provide audit ready artefacts including testing evidence, controls documentation, and technical impact assessments. - Modify existing data flows to incorporate new PRISM positions without breaking existing processes. - Build new transformations, enrichment logic, staging tables, and curated domain layers as required. - Produce unit tests, regression tests, and data validation queries. - Support SIT and UAT cycles with test data creation, reruns, and defect fixes. - Perform reconciliation with Finance and Regulatory outputs to confirm data correctness. - Work with DBAs and Operations teams to promote code through environments. - Support release weekends or controlled deployment events where needed. - Provide root cause analysis for data or pipeline issues. - Maintain accurate documentation for mappings, logic, flows, technical designs, and controls.