Back

ETL Developer, Data Warehouse

Redhill, £55K-£60K Plus Bonus and Benefits
Permanent
Reference: RC7588

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

 

Apply Now