ETL Developer, Data Warehouse

ETL Developer, Data Warehouse

Redhill, Surrey

??55K-??60K 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.