Key Responsibilities IncludeManaging the investigation of cities data requirements, documenting them according to the required standards utilising the prescribed methods and toolsImplementing data flows to connect operational systems, data for analytics and BI systems. Re-engineer manual data flows to enable scaling and repeatable useWorking closely with data architects (to determine what data management systems are appropriate) and data scientists (to determine what data is needed for analysis)Tackling problems associated with database integration and unstructured data setsEnsuring that those using the data structures and associated components have a good understanding and that any queries are dealt with promptly and efficientlyIn liaison with the information management or IT management functions, contributing to the development and maintenance of corporate data standardsability to create efficient DW or DL structures to minimise cost of orchestration / processing and ingestion of dataThis is a permanent full time role, reporting to the Head of Data Engineering, which will be delivered remotely to start with. The post holder will be required to travel to our London office from time to time when it reopens.Interested applicants must be eligible to work legally in the United Kingdom.RequirementsRequired Skills And ExperienceStrong technical process understanding regardless of technologyWide range of strong technical skills (i.e. Azure Devops, Azure Data Factory, Azure Data Bricks, Azure SQL, python)Very strong core SQL Competencies - SSMS, SSIS, T-SQL, Stored ProceduresADF Pipelines to build and populate SQL databasesVery high attention to detailStrong communication skillsEfficient in building ETL and ELT processes for enterprise solutionsStrong software delivery methods and knowledgeStrong performance-tuning skillsDesired Skills And ExperienceExperience in .Net scriptingExperience with migrations from on-prem to cloudExperience in performance tuning SQL databasesExposure to Climate Change data legislation, practices and stakeholdersExperience in Environmental related industriesPresentation skillsUnderstanding of architecting solutions taking into account wider considerationsStructured problem solving techniques