Data Warehousing Specialist

3 weeks ago

London, UK, United Kingdom Pontoon Solutions Full time

**Data Warehousing Specialist** (Contract)


Duration: Up until 31 March 2025 (Possibility for extension)

Location: London/Hybrid (2 days per week on site)

Rate: A highly competitive PAYE Day Rate is available for suitable candidates




Role Profile


Our client, a leading investment banking organisation, is seeking a Data Warehousing Specialist to join their team. As a Data Warehousing Specialist, you will be responsible for translating requirements and data mapping documents into technical ETL designs, creating and reviewing high-level solution designs, and developing, enhancing, and maintaining ETL code following best practises and standards.


Purpose of Job:


  • Translate requirements and data mapping documents to a technical ETL design.
  • Create and review high-level design of solution.
  • Perform technical walkthroughs of amended DataStage ETL solutions for peer reviews.
  • Develop, enhance, and maintain ETL code following best practises and standards.
  • Create and execute unit testing plans. Support Regression and System test efforts.
  • Debug and problem solve issues found during testing and/or production.
  • Promote DataStage ETL code using Perforce and Urban Code deployment tools.
  • Evaluate data for completeness and correctness, validate that ETL code is working as expected.
  • Communicate status, issues, blockers to project manager and ETL team lead.
  • Support continuous improvement of ETL interfaces by identifying and solving opportunities.
  • Update and publish documentation, system diagrams, presentations, workflows, project plans, log issues, and unit testing logs.
  • Attend project and ETL meetings.
  • Perform knowledge transfer sessions to ETL Production support and Development team.
  • Assist Production support team on the resolution of production incidents related to ETL processes when required.


Accountabilities:


  • Ensure all deliverables meet internal standards, industry best practise within the agreed timeframe.
  • Ensure clear and transparent communication to all key stakeholders.
  • Be responsible for the project deliverables related to assigned initiatives.
  • Be responsible for IT-related risks, issues, and ensure appropriate escalation to appropriate management.
  • Support strategic discussions and propose appropriate recommendations to IT management.
  • Be responsible for troubleshooting, root cause analysis, data analysis related to BAU support requests.
  • Ensure appropriate tracking and escalation of IT-related risks and issues observed.





Skills and Experience:


- IBM DataStage: Understanding of DataStage architecture and components. Familiarity with DataStage Designer, Director, and Administrator. Knowledge of DataStage jobs, stages, and data connections. Experience with parallel job design and development.

- Database Systems: Relational databases (e.g., IBM Db2, Oracle, SQL Server). SQL and PL/SQL programming.

- ETL development: Designing, developing, and deploying DataStage jobs. Creating complex ETL processes using DataStage and connectors. Performance tuning of DataStage jobs.

- Data Transformation and Cleansing: Applying data transformation rules. Implementing data quality and data cleansing routines.

- Data Integration: Integrating data from various sources (e.g., databases, flat files, XML). Handling structured and unstructured data.

- Problem Solving and Debugging: Identifying and resolving ETL job failures. Troubleshooting performance issues.

- Hands-on Experience with IBM DataStage: Several years of experience developing ETL solutions using IBM DataStage. Experience with different DataStage versions.

- Project Experience: Involvement in full project life cycles, from requirements gathering to deployment and maintenance. Working in Agile or Waterfall project environments.

- Database and SQL Experience: Writing complex SQL queries and stored procedures. Working with large datasets and optimising queries for performance.



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.

  • Azure Data Architect

    1 month ago

    London,, UK, United Kingdom Cognitive Group | Part of the Focus Cloud Group Full time

    Azure Data Architect 6 Month Contract Outside IR35 Financial Services – Banking I’m working with a financial services client in London who are embarking on a digital transformation journey to migrate from their current on-premises platforms to Azure in the cloud. They need an Azure Data Architect to join the team who will be responsible for driving the...

  • Senior Data Engineer

    6 days ago

    London,, UK, United Kingdom Bits Full time

    Company DescriptionBits is a London based credit card company that helps people build credit. We are backed by Y Combinator, and have a team of 35 people.Role DescriptionThis is a full-time on-site role in London Area, United Kingdom for a Senior Data Engineer. The Senior Data Engineer will be responsible for data engineering, data modeling, ETL processes,...

  • Data Engineer

    2 weeks ago

    London,, UK, United Kingdom Haystack Full time

    Position: Data EngineerLocation:Remote work with occasional (twice per month) office presence in London or Leicester.Role Overview:You will join a dynamic and expanding Data Engineering team with a primary focus on designing, building, enhancing, and optimising a cloud-based data warehouse.Candidate Profile:We are looking for someone who is honest,...

  • Senior Data Engineer

    2 weeks ago

    London,, UK, United Kingdom Oliver Bernard Full time

    Senior Data Engineer - JVM - Java, Kotlin, ETL, Data Warehouse A long-term client of OB's in the consulting space have recently won a long-term project with a Tier 1 Investment Bank and are looking for highly skilled Senior Data Engineers to come and work on an incredibly exciting new greenfield project. This is a large scale Data Warehousing project,...

  • Lead/Principal Data Engineer

    2 weeks ago

    London,, UK, United Kingdom Oliver Bernard Full time

    Lead/Principal Data Engineer - JVM - Java, Kotlin, ETL, Data WarehouseA long-term client of OB's in the consulting space have recently won a long-term project with a Tier 1 Investment Bank and are looking for highly skilled Senior Data Engineers to come and work on an incredibly exciting new greenfield project.This is a large scale Data Warehousing...

  • Head Of Data

    3 weeks ago

    London,, UK, United Kingdom InterQuest Group Full time

    Head of DataLocation: Central LondonPermanent opportunityOffering up to £130K PAWe are seeking a seasoned data management professional to lead a newly established team within our Investment Services and Solutions division. The successful candidate will be responsible for developing and implementing a robust data management framework, ensuring data quality,...

  • Alternative Data Specialist

    3 weeks ago

    London,, UK, United Kingdom Vertex Search Full time

    Alternative Data Acquisition Specialist - Buy Side Systematic Trading FirmOur leading trading firm client with offices in London are seeking an Alternative Data Sourcing Specialist to take their quant research and trading strategies to the next level. This role will suit a junior to mid level candidate.They require a dynamic Alternative Data Procurement...

  • Data Warehouse Developer

    3 weeks ago

    London,, UK, United Kingdom Mentmore Full time

    Data Warehouse Developer // Up to £80k plus package // Global advertising business // Hybrid Working Model (London) // Microsoft Stack Client Summary My client is a global marketing and communications agency that focuses on integrating creative, media, and technology to deliver innovative solutions for its clients. Known for its collaborative approach, the...

  • Senior Data Engineer

    3 weeks ago

    London,, UK, United Kingdom Arcus Search Full time

    Senior Data EngineerAWS - Databricks - SQL - Python - VisualizationDo you want to be part of a dynamic and fast-growing organization, who deeply committed to advancing towards a global circular economy by addressing sustainability from the perspectives of people, the planet, and finance.We're looking for a talented Senior Data Engineer to join a new data...

  • Senior Data Engineer

    3 weeks ago

    London,, UK, United Kingdom Arcus Search Full time

    Senior Data Engineer AWS - databricks - SQL - Python - TableauDo you want to be part of a dynamic and fast-growing organization, who deeply committed to advancing towards a global circular economy by addressing sustainability from the perspectives of people, the planet, and finance. We're looking for a talented Senior Data Engineer to join a new data...

  • Senior Data Engineer

    2 weeks ago

    London, UK, United Kingdom Arcus Search Full time

    Senior Data Engineer AWS - databricks - SQL - Python Do you want to be part of a dynamic and fast-growing organization, who deeply committed to advancing towards a global circular economy by addressing sustainability from the perspectives of people, the planet, and finance. We're looking for a talented Senior Data Engineer to join a new data team....

  • Senior Data Engineer

    1 week ago

    London,, UK, United Kingdom Arcus Search Full time

    Senior Data EngineerAWS - Databricks - SQL - Python - VisualizationDo you want to be part of a dynamic and fast-growing organization, who are deeply committed to advancing towards a global circular economy by addressing sustainability from the perspectives of people, the planet, and finance.We're looking for a talented Senior Data Engineer to join a new...

  • Data Architect

    1 month ago

    London, UK, United Kingdom Cititec Talent Ltd Full time

    Join a leading commodities trading company. They leverage innovative technologies and deep market expertise to deliver exceptional value to their clients. About the Role: They are seeking a highly skilled and experienced Senior Data Integration Architect to join their growing team. In this critical role, you will be responsible for designing, developing, and...

  • Data Engineer

    3 weeks ago

    London,, UK, United Kingdom Cognify Search Full time

    Analytics Engineer Join a traditional retailor with lots of greenfield projects! We are looking for Analytics engineers who’re wanting to join a B-Corp! Salary: up to £70,000 Benefits: Annual performance bonus Industry/Type of business: E-commerce Work place: Hybrid: 1 day a week minimum Interview process: 3 stagesAs an Analytics Engineer, you will be an...

  • Data Specialist

    3 months ago

    London,, UK, United Kingdom The Ardonagh Group Full time

    An exciting remote based Data & MI Specialist opportunity has arisen to join our MI & Data team.This role will be responsible for ensuring data accuracy, generating meaningful insights, and providing valuable information to support decision-making across the organisation.You will support the Data & MI Manager with delivery of Divisional Data & MI strategy,...

  • Senior Data Engineer

    1 month ago

    London,, UK, United Kingdom Peaple Talent Full time

    Senior Data Engineer | Fully Remote | up to £60,000Peaple Talent have partnered with a leading provider of land and property search information, who provide a range of services across digital mapping, environmental risk reports and sophisticated property management tools. Due to exciting growth plans in the Data team we are now seeking a selection of Senior...

  • Senior Data Engineer

    4 weeks ago

    London,, UK, United Kingdom Peaple Talent Full time

    Senior Data Engineer | Fully Remote | up to £60,000Peaple Talent have partnered with a leading provider of land and property search information, who provide a range of services across digital mapping, environmental risk reports and sophisticated property management tools.Due to exciting growth plans in the Data team we are now seeking a selection of Senior...

  • Data Project Manager

    3 weeks ago

    London,, UK, United Kingdom JSS ASSOCIATES Full time

    Data Project Manager - Data WarehouseWe are seeking a meticulous and experienced individual for the role of Data Project Manager. This role is integral to our data warehouse projects, requiring a balance of technical knowledge and project management skills.Unfortunately sponsorship cannot be provided for this position.A hands on PM with skills such as...

  • Senior Data Engineer

    3 months ago

    London,, UK, United Kingdom Ventula Consulting Full time

    Senior Data Engineer contract - Snowflake / Python - Greenfield - £650 per day insideLeading eCommerce client are now searching for a Senior Data Engineer to play a pivotal role in delivering their new greenfield data platform.This role will shape our client’s data function, delivering end to end data requirements and designing data pipelines/warehouses...

  • Python Developer

    3 weeks ago

    London,, UK, United Kingdom Discovered MENA Full time

    Position: Senior. Software Engineer ‍Team: DataLocation: LondonSalary: 76-110K GBPWe are partnered with an cutting-edge AI company, with Global officed across Middle East, USA and UK. They empower organisations with Decision Intelligence by delivering tailored AI solutions and Enterprise AI products, enabling actionable insights and a competitive edge in...