SQL Data Engineer's - London, United Kingdom - Belmont Lavan

    Belmont Lavan
    Belmont Lavan London, United Kingdom

    2 weeks ago

    Default job background
    Description
    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