SQL Data Engineers
Location: London
Type: Permanent role , Hybrid (2 days onsite)
We are looking to expand our team and looking for several SQL Data Engineers .
Immediate Interviews slots are available.
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.
This is a permanent full-time role
Interested applicants must be eligible to work legally in the United Kingdom.
Requirements
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.
- Presentation skills
- Understanding of architecting solutions taking into account wider considerations
- Structured problem solving techniques