ETL Developer, Data Warehouse

Recruiter
ARC IT Recruitment
Location
Redhill
Salary
55000.00 - 60000.00 GBP Annual + Benefits + Bonus
Posted
14 Jan 2021
Closes
18 Jan 2021
Contract Type
Permanent
Hours
Full Time

ETL Developer, Data Warehouse

Redhill, Surrey

GBP55K-GBP60K Plus Bonus and Benefits

ETL, SQL, SSIS, Azure

ETL Developer is required by an ever expanding and market-leading tech business. This is a fantastic opportunity for an experienced ETL Developer with extensive experience in ETL/DWH to join a close-knit team working across a variety of exciting new and existing projects. You will be responsible for developing the robust and efficient ETL processing of large volumes of data to SQL Server Data warehouse from a variety of source data. You will also review and support ETL development completed by the outsourced vendor team and liaise with upstream data suppliers to ensure a supply of high-quality data and provide advice on data management and contribute to discussions on data architecture.

Key Responsibilities:

  • Coordinate with ETL team to implement all ETL process for all new projects
  • Work with stakeholders and team members to define and develop robust ETL framework, whilst capturing user requirements
  • Prepare low level ETL Design & Ownership
  • Document all technical, system specifications and data flow diagrams for all ETL processes
  • Analyse and interpret all complex data on all target systems
  • Design and implement all publication activities such as dashboards and maintain required system documentation
  • Perform root cause analysis on all processes, resolve all production issues, validate all data, perform routine tests on databases, and provide support to all ETL applications
  • Develop and perform tests on all ETL codes for system data and analyse all data and design all data mapping techniques for all data models in systems

Key Requirements:

  • Experience on Azure Data Factory and Sparks
  • Significant ETL development experience
  • Strong Data Warehouse, ETL, Cubes, SQL, SSIS experience
  • Strong MS SQL/Azure experience creating cubes, stored procedures, queries, indexes and performance tuning
  • Experience of working in a Business Intelligence role creating dashboards and reports
  • Master Data Management and Data Governance experience
  • Experience of consuming API's (REST/XML/SOAP/JSON)
  • Excellent written and verbal communication skills

For a full consultation on this pivotal role, send your CV to Arc IT.