Data Warehouse Developer** (Contract) Duration: 10 Months (Possibility for extension) Location: London/Hybrid (3 days per week on site) Rate: A highly competitive Umbrella Day Rate is available for suitable candidates Role Summary We are seeking an experienced Data Warehouse Developer to support enhancements to the Oracle General Ledger (GL) dataflow, including the onboarding and integration of additional PRISM position data. The role requires strong hands on SQL Server development skills, deep experience with data modelling, transformation logic, and ETL frameworks (SSIS or equivalent), and the ability to work closely with analysts and stakeholders to deliver high quality, audit ready solutions. Key Accountabilities: * 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/...