Data Warehouse Developer

London, United Kingdom
2 months ago
Applications closed

Related Jobs

View all jobs

Oracle Data Warehouse Developer (SC Cleared)

Syntax Consultancy Andover, United Kingdom

Data Analyst (Power BI SQL Azure | Data Transformation)

Avanti Recruitment East Barnet, London, EN4 8TB, United Kingdom
£65,000 pa Hybrid

Senior Data Engineer

Pontoon Warwick, United Kingdom

Senior Data Analyst (Power BI |Data Transformation) | Hertfordshire

Avanti Recruitment Watford, Hertfordshire, United Kingdom
£50,000 – £75,000 pa Hybrid

AI Engineer

Hays Technology Manchester, United Kingdom
On-site Clearance Required

Data Architect

DCV Technologies London, United Kingdom
£400 – £500 pd Contract
Posted
17 Mar 2026 (2 months ago)

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/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.

Develop and enhance ETL/ELT pipelines supporting Oracle GL and PRISM data integration.

Skills & Experience:

* Strong expertise in SQL Server (Apply online only)), including advanced T SQL.

* Hands on experience with ETL frameworks, ideally SSIS, including package development, debugging, and optimisation.

* Solid understanding of data modelling, schema design, indexing, and performance optimisation.

* Ability to work with complex data structures in Finance or Risk domains.

* Familiarity with PRISM, GL accounting data flows, or financial system integrations (highly desirable).

* Proven ability to design and build scalable, automated data pipelines.

* Experience creating data quality rules, validation checks, and reconciliation logic.

* Strong understanding of lineage, metadata, and control frameworks.

* Ability to investigate data discrepancies, trace lineage across multiple layers, and resolve root causes.

* Familiarity with troubleshooting ETL job failures, performance issues, and scheduling dependencies.

* Strong communication skills, able to translate complex technical issues to non technical stakeholders.

* High attention to detail, structured approach to problem solving.

Strong Data Warehouse / ETL developer background in banking or financial services.

Candidates will need to show evidence of the above in their CV in order to be considered.

If you feel you have the skills and experience and want to hear more about this role 'apply now' to declare your interest in this opportunity with our client. Your application will be observed by our dedicated team.

We will respond to all successful applicants ASAP however, please be advised that we will always look to contact you further from this time should we need further applicants or if other opportunities arise relevant to your skillset.

Pontoon is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone's chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive.

As part of our standard hiring process to manage risk, please note background screening checks will be conducted on all hires before commencing employment.

We use generative AI tools to support our candidate screening process. This helps us ensure a fair, consistent, and efficient experience for all applicants. Rest assured, all final decisions are made by our hiring team, and your application will be reviewed with care and attention

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Where to Advertise Data Science Jobs in the UK (2026 Guide)

Where to advertise data science jobs UK in 2026: the specialist boards, communities and channels that actually reach senior and lead data science talent. Data science spans a broad and often misunderstood spectrum — from statistical modelling and experimental design through to machine learning engineering, product analytics and AI research. The strongest candidates identify firmly with specific subdisciplines and are frustrated by adverts that conflate data scientist with data analyst, business intelligence developer or machine learning engineer. General job boards produce high application volumes for data roles but consistently fail to match specialist data science profiles with the right opportunities. This guide, published by DataScienceJobs.co.uk, covers where to advertise data science roles in the UK in 2026, how the main platforms compare, what employers should expect to pay, and what the data says about hiring across different role types.

Data Science Jobs UK 2026: What to Expect Over the Next 3 Years

Data Science Jobs UK 2026: roles, salaries and the trends shaping UK data science hiring over the next three years — from MLE crossover to GenAI workflows. Data science has spent the past decade being described as the sexiest job of the twenty-first century. By 2026, the reality is both more nuanced and more interesting than that label ever suggested. The discipline has matured, fragmented, deepened, and in some respects reinvented itself — and the jobs market has changed with it in ways that create genuine opportunity for those who understand what employers actually want, and genuine difficulty for those still operating on assumptions formed five years ago. The data science jobs market of 2026 is not simply a larger version of what it was three years ago. The generalist data scientist — equally comfortable wrangling data, building models, and presenting insights to the board — is giving way to a more specialised landscape where employers know exactly what problem they are trying to solve and are looking for candidates with the specific depth to solve it. Machine learning engineering, causal inference, experimentation, AI product development, and domain-specific applied science have all emerged as distinct career tracks within what was previously a single, loosely defined profession. At the same time, the arrival of large language models and the broader AI capability wave has both threatened and created data science roles in equal measure. Some of the work that junior data scientists spent their early careers doing — data cleaning, exploratory analysis, basic model building — is being partially automated by AI tooling. But the demand for practitioners who can evaluate AI systems rigorously, apply statistical thinking to complex business problems, and build the data foundations on which AI depends has grown considerably. The candidates who will thrive over the next three years are those who understand where the discipline is heading — which specialisms are attracting the most investment, which technologies are reshaping what data scientists are expected to build and know, and how to position a data science career that will remain valuable as the field continues to evolve around them. This article breaks down what the UK data science jobs market is likely to look like through to 2028 — covering the titles emerging right now, the technologies driving employer demand, the skills that will matter most, and how to position your career ahead of the curve.