ETL Technical/Lead Developer

Posted 6 April by IF Recruitment Ltd Easy Apply

Our client, a multinational insurance company, are looking to secure the services of an ETL Technical Lead/Developer to join a growing IT team in their York offices.

Role: ETL Technical Lead / Developer

Location: York

Salary: £40,000 - £50,000


  • Generous defined contribution pension scheme.
  • Annual performance related bonus and pay review.
  • Holiday allowance of 29 days plus bank holidays and the option to buy/sell up to 5 additional days.
  • Up to 30% discount for some insurance products plus discounts for Friends and Family.
  • Excellent range of flexible benefits to include a matching share save scheme.

The company are reknowned for the flexible ways they like to work. This may include working from home some of the time, or flexible work schedules to accommodate parent and carer responsibilities, further studies and hobbies.

The team:

  • Within this team we facilitate over £50b of payment and collections each year which flow through financial reporting. We provision customer, policy and transaction data supporting valuation, accounting and business MI.

The team lead on:

  • Bringing together and driving solutions for Finance Systems and Data Warehousing across the UK Businesses.
  • Driving platform stability, integrity and security for their customers through robust operational discipline.
  • Ensuring that platform change and engagement is simple, fast and cost effective by building world class engineering capability, enabling us to Defy Uncertainty for customers at pace.
  • Ensuring that the platforms remain highly competitive and cost optimised by driving simplification in all aspects, strong partnerships and a culture of innovation and agile working.
  • Support Business Units with the implementation of Data Strategy, supporting consolidation of data whilst enabling self-service.
  • Key systems owned and managed by this area include Oracle eBusiness suite, Banking & Payment systems, Life and GI Data Warehouses as well as modelling systems like Prophet and ALGO.

The Informatica Technical Lead/Senior Developer is an ETL and data warehouse (DW) specialist (primarily in Informatica Power Centre, Web Analyst, Developer, DVO) that designs, develops, maintains ETL and data warehouse solutions in collaboration with key business customers and stakeholder (Actuarial) on the Life Data & MI Platform. The Technical Lead/Senior Developer is a commercially aware technical expert, who is business facing and who can influence and interpret a high level requirement into a low level technical solution and then develop an ETL solution to meet that requirement efficiently. This role is very customer focussed, and requires a self starter who is can proactively engage and work alongside actuarial teams in a collaborative manner in mature but complex ETL and DW estate.

Role Purpose:

  • Responsible for ETL design and development ensuring ETL processes are coherent, efficient and support the strategy for data architecture within the business.
  • Able to develop and embedded a strategy around leverage of Informatica Web Analyst and Developer to support incremental business change and self service.
  • Act as the ETL technical design expert for new projects (of varying size) and developments, working with actuarial customers to refine requirements and build value adding changes as efficiently as possible (likely from a product backlog).
  • Proactively identify improvements required within existing Warehouse solutions and plan redesign work.
  • Work with business data experts around complex problems and design and develop efficient solutions.
  • Formulate and communicate proposals to leverage advances in ETL technologies, including development of Proof of Concept solutions where appropriate, Work with the Development Manager to plan and implement.
  • Tasks manage a small team of developers.


  • Skilled in the use of Informatica PowerCenter or a relevant ETL tool (e.g. SSIS, Data stage, Ab Initio, Oracle Warehouse Builder).
  • Good verbal and written communication skills enabling effective interaction with both IT and Business stakeholders.
  • Organised (work management of self and others) and self-motivated.
  • Ability to assimilate technical and business information and to help translate these into practical solutions.
  • Ability to positively challenge existing and proposed solutions and present designs and ideas in a clear, concise way.
  • Excellent understanding of Data Warehouse methodologies.
  • Familiarity with software solution development lifecycles.
  • Some commercial awareness of financial services industry and processes - Actuarial being a strong advantage.

Required skills

  • Data Warehousing
  • ETL
  • Financial Services
  • Informatica
  • Technical Leadership

Reference: 34850111

Bank or payment details should not be provided when applying for a job. is not responsible for any external website content. All applications should be made via the 'Apply now' button.

Report this job