Accessibility Links

Data Integration Consultant

  • Job reference: 51127
  • Location: London
  • Job type: Contract
  • Start date: Not specified
  • Contact: Not specified
  • Sector: BI, Data & Analytics
  • Salary: £400 - £500 per day

Sorry, this vacancy has now expired.

Please see our job results page to find our current open vacancies or take a look at our Specialisms below and go straight to your area.

BI, Data & Analytics, Change Management, Digital and Development, ERP and CRM Systems, Executive Leadership, Information and Cyber Security, Infrastructure & Cloud Services, Interim Management, Strategy & Architecture, or Work For La Fosse.




 Return to homepage.

Data Integration Consultant

3 months



We are looking for this Data Integration Consultant to work on Corporate Services Area within the Data Integration team. We are looking for someone experienced in Data Warehouse development,experience of Informatica 9 or 10, Oracle PL/SQL and understanding on Kimball methodology.

The Data Integration group manage data from a variety of sources including departments as diverse as Human Resources and Treasury Accounting, and systems as diverse as SAP and Summit.

The Data Warehouse is delivered using Cognos and Tableau on Oracle, with Informatica as the data integration layer and metadata delivery.


The primary objective of the assignment is the support of the Corporate Services Area and DI processes for the Data Warehouse.

Scope of Work

This role requires development of DI solutions as directed by the Head of Business Intelligence and DI Manager. In order to achieve the assignment's objective the Consultant will address the following key responsibilities:

  • Design and develop new DI processes
  • Adhere to defined standards for all developed components
  • Test and implement new DI processes
  • Work with the Corporate Services systems owners to resolve source data issues and refine transformation rule
  • Undertake other tasks, within skill set, as directed by management
  • The role will work with the work stream leads, project managers and programme manager as well as specialist IT resources and support teams.
  • Support the transition of this Scope of Services to a Third Party Provider once appointed


  • Participate in design and development review
  • Produce support documentation
  • Maintain existing DI processes
  • Share ownership of DI Best Practice
  • Monitor and improve performance of DI processes
  • Share ownership of metadata management systems
  • Improve change management in DI systems

Expected Experience

The ideal candidate will have knowledge in the following areas:

  • Experienced in Data Warehouse development, implementation and support
  • Extensive hands on experience of Informatica 9 or 10.
  • Direct experience in implementing DI solutions
  • Direct experience in resolving DI issues
  • Direct experience of Oracle PL/SQL
  • Good understanding of Kimball methodology / star schema design
  • Experience of Informatica's EDC an advantage
  • Understanding of XML, SOAP, use of services and Real Time functionality within Informatica suite.
  • Experience in BMC Control-M helpful.
  • Experience in HR and IT data solutions helpful.

Additional skills:

  • Previous experience of working in a Banking environment an advantage
  • Excellent communicator in English - both written and verbal
  • Possesses strong investigative and analytical qualities
  • Has ability to coach more junior team members in an open and involving manner
  • Able to contribute to an environment of continuous improvement
Related jobs
Digital Insights Manager- 9 month contract
  • Contract
  • London
  • £300 - £350 per day
  • Reference 51984
  • Some good news, I'm looking for a Digital Insights Manager for a leading Charity in London, 9 month contract (starting remote). You must have experience in:- Digital Analytics reporting across paid, owned & earned media - Propose Test & Learn strategies that can help improve performance - Google Analytics...
Read more
BI Engineer - Azure
  • Contract
  • Peterborough
  • £400 - £475 per day
  • Reference 43039
  • BI Engineer - Azure Must have experience with Azure BI Services (Azure SQL, Azure Data Warehouse, Azure Data Factory and Azure Analysis Services). Key requirements: Experience building data integration services using Data Factory pipeline, Azure Logic App & Azure Functions that orchestrate and automate the...
Read more
Data Engineer
  • Permanent
  • London
  • £60000 - £80000 per annum
  • Reference FM51272
  • La Fosse Associates are working exclusively with an Asset Management business in the recruitment of a Data Engineer. The successful candidate will take the lead responsibility of engineering and maintenance of an RDF triple store Data platform to help drive the businesses data led strategy...
Read more