Data Warehouse Developer

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

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., * Strong expertise in SQL Server (2016-2022), 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.

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.