ETL/ ELT & Data Lake Database Developer

Dreams Ltd
14 Aug 2019
11 Sep 2019
Contract Type
Full Time

With over 30 years experience and a genuine passion for giving our customers a Great Nights Sleep, were Britains leading bed specialist.

We are looking for an experienced ETL/ELT Data Lake developer to join our Finance and IT teams based at our Bedquarters in Loudwater.

Job Purpose:
A high calibre, dynamic and technically broad role which supports technical elements of Data strategy development and supports automation of internal and external data sources into central Data Lake to be utilised by analytics team. Job role requires technical knowledge of databases and ability to design effective, safe and sustainable data flows between varied range of databases. Working alongside the analytics team and incorporating IT strategy elements into the Data1st strategy.

Key Responsibilities:
-Design efficient, effective, safe and sustainable ETL/ELT schedules to support timely delivery of data in BI tools
-Create functions, scripts, stored procedures and triggers to automate external data flows into Data Lake
-Assist Analytics part of the team to automate external scrapes or set up API connections to provide zero touchpoint Data Lake.
-Work along our existing IT function, to ensure all Insights protocol is in line with company standards, but question, challenge and recommend best practice approach.
-Technical Supporting of Data Insight & analytics function in creation of reporting & analytical suite
-Data optimisation - optimise performance of the datasets/databases and related servers and recommend most effective architecture set up
-Understand database capacity triggers and recommend relevant changes to drive continuous flow of data at maximum viable velocity
-Good knowledge of data quality and cleansing techniques to ensure and maintain data integrity
-Able to assist in the ongoing design of technical best practice for the development of data movement, data cleansing, data quality and other ETL-related activities.
-On-going evaluation of database storage/capacity and estimation of future needs
-Experience in troubleshooting, performance tuning and optimisation of ETL packages
-Experienced ETL developer with extensive knowledge of using disparate data sources
Skills, Experience and Attributes Required:
-Strong SQL skills; distributed queries, stored procedures, functions, concurrency.
-Strong capability with experience working in Big data design environments; BI & Reporting projects
-Strong communication and documentation skills, and ability to liaise with non-technical stakeholders up to CxO level.
-Accuracy and attention to detail, effective organisational abilities and time management skills, both self and 3rd parties
-Ability to work under pressure and follow a tight timetable.
-Experience in running a data centralisation project is essential
-Must be able to work independently or as part of a larger team
-Understanding of and experience in NoSQL (Document, Graph, Key-Value, Wide column)
-Understanding of REST, JSON, GraphAPI
-Experience in Python or R will be an advantage
-Good interpersonal skills and capable of communicating at all levels within the organisation.

What we can offer you:
- Competitive salary
- Onsite Gym
- Onsite Parking
- Generous company discount
- Company bonus

More searches like this