ETL Developer - London

£55000 - £70000 per annum - Information Technology
Ref: 350 Date Posted: Monday 22 Nov 2021
LinkedIn ShareShare

The ETL Developer will create and support new and current insight products, you will report to the Head of Service and have the responsibility for the development life-cycle process including creation of cloud-based infrastructure, product definition, development, testing and implementation into production.

The role can be based in with London or Nottingham (remote working available 2/3 days a week)

Responsibilities:

  • Supporting sales initiatives and developing innovative technical solutions that meet client and market requirements
  • Creating and maintaining new performance, secure and value based public cloud infrastructure that meets design principles to support the development, testing and operation of new products and services.
  • Translating requirements into technical solutions for new data services including data acquisition, transformation, matching, enrichment, anonymization, secure access and presentation.
  • Building, testing and automating new data services that integrate multiple data sources.
  • Ensuring the timely delivery of existing products and services to clients.
  • Working with team colleagues, the test team and external partners to ensure performance and accuracy of outputs to meet client needs.
  • Developing custom and self-service BI reporting capabilities using COTS tools such as Tableau.
  • Maintaining a broad knowledge of the technical solutions and standards available in the energy and smart metering market.

Key skills:

  • Experience in data acquisition, enrichment and matching using COTS ETL tools such as Pentaho or Informatica
  • Experience of operating and managing AWS cloud environments (infrastructure as code) with a focus on performance, value for money and security.
  • Knowledge of logical and physical data modelling techniques
  • Knowledge of approaches to data masking and anonymization to support data security and privacy requirements
  • Experience in developing custom and self-service BI reporting capabilities using COTS tools such as Tableau, QlikView and SQL.

Highly desirable skills:

  • Experience in “big data” platforms (e.g. Hadoop) and traditional RDBMS technologies
  • Experience in working in an agile / scrum “fail-fast” environment
  • Experience of using AWS CodeCommit
  • Able to deal with structured, unstructured and semi-structured data
  • Development and articulation of solution design both verbally and in writing e.g. option papers.