Description
Lead ETL Developer, Outside IR35
London/Remote
To £550
ETL, SQL, SSIS, Azure Data Factory
Lead Developer is required by an ever expanding and market-leading tech business. 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.
Key Responsibilities:
- Lead ETL Dev team to implement ETL process for all new projects
- Work with stakeholders and team members to define and develop robust ETL framework, whilst capturing user requirements
- 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 Lead 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)
For a full consultation on this pivotal role, send your CV to Arc IT.