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!
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.
- Data Warehousing and related methodologies (Kimball, 3NF)
- ETL Development tools (eg MS SSIS, Matillion, Informatica, Talend)
- Analytical mind, critical thinker and problem solver
- Extensive knowledge of SQL (DDL and DML)
- Clear communication and stakeholder management
- Cloud Database experience (Snowflake, Redshift, Azure)
- Datamodelling Experience
Salary - Competitive
Keywords: ETL, Data Warehouse, Data Warehousing, SQL, Cloud, Snowflake
Lawrence Harvey is acting as an employment agency in regards to this position.
Role: ETL Developer (Cloud Based)
Job Type: Permanent
Apply for this job now.