Connecting...

W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy9syxdyzw5jzs1oyxj2zxkvanbnl2pvyl9kzwzhdwx0x2jhbm5lci5qcgcixv0

ETL Developer (Cloud Based)

ETL Developer (Cloud Based)

Job Title: ETL Developer (Cloud Based)
Contract Type: Permanent
Location: City of London, London
Industry:
Salary: £50000 - £60000 per annum + bonus, pension, benefits
Start Date: ASAP
Reference: BN/HQ00114590_1575563783
Contact Name: Brad Newton
Contact Email: b.newton@lawrenceharvey.com
Job Published: December 05, 2019 16:36

Job Description

ETL Developer (Cloud Based)

Our client is an exciting, well established Fintech based in London - offering niche specialty lines SME bank targeting under-served segments!

Role

The Bank's Data Warehouse architecture is built in Snowflake and uses Snaplogic and Matillion for ETL processing. This role will primarily use Matillion and Snowflake.

Developing new ETL procedures for HTB's data warehouse and maintaining and monitoring existing procedures. The ETL Developer will coordinate with project teams to design ETL specifications based on the downstream Data Warehouse requirements.

Document all technical and system specification documents for all ETL processes, perform unit tests on all processes and prepare required scripts and evidence.

Provide support to all ETL schedule and maintain compliance to the schedule and develop and maintain various standards to perform ETL codes and maintain an effective project life cycle on all ETL processes.

The ETL Developer will provide document all test procedures for systems and processes and coordinate with project teams and users to resolve all requirement issues and maintain the quality of the solution.

Collaborate with the Data Architect to support the maintenance of Data Governance processes within the Bank and continually improve the quality of data within the Bank's Data Warehouse.

Experience

  • Data Warehousing and related methodologies (Kimball, 3NF)
  • ETL Development tools (e.g. MS SSIS, Matillion, Informatica, Talend)
  • Analytical mind, critical thinker and problem solver
  • Extensive knowledge of SQL (DDL and DML)
  • Clear communication and stakeholder management
  • Matillion
  • Cloud Database experience (Snowflake, Redshift, Azure)
  • Data Modelling Experience
  • Python

Salary - Competitive

Keywords: ETL, Data Warehouse, Data Warehousing, SQL, Cloud, Snowflake

Lawrence Harvey is acting as an employment agency in regards to this position. Visit our website www.lawrenceharvey.com and follow us on Twitter for all live vacancies @lawharveyjobs