Data Engineer(SSIS,SSRS&SQL)

SQL Data Engineer

Key responsibilities include:

Managing the investigation of cities data requirements, documenting them according to the required standards utilising the prescribed methods and tools
Implementing data flows to connect operational systems, data for analytics and BI systems. Re-engineer manual data flows to enable scaling and repeatable use
Working 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 sets
Ensuring that those using the data structures and associated components have a good understanding and that any queries are dealt with promptly and efficiently
In liaison with the information management or IT management functions, contributing to the development and maintenance of corporate data standards
ability to create efficient DW or DL structures to minimise cost of orchestration / processing and ingestion of data

Required skills and experience:

Strong technical process understanding regardless of technology
Wide 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 Procedures
ADF Pipelines to build and populate SQL databases
Very high attention to detail
Strong communication skills
Efficient in building ETL and ELT processes for enterprise solutions
Strong software delivery methods and knowledge
Strong performance-tuning skills

Desired Skills And Experience

Experience in .Net scripting
Experience with migrations from on-prem to cloud
Experience in performance tuning SQL databases
Exposure to Climate Change data legislation, practices and stakeholders
Experience in Environmental related industries i.e Water, Energy, Forestry related
Presentation skills
Understanding of architecting solutions taking into account wider considerations
Structured problem solving techniques

This 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 London office from time to time when it reopens.

Interested applicants must be eligible to work legally in the United Kingdom.