SQL Developer London Hybrid - EPR Resourcing Ltd

    EPR Resourcing Ltd
    EPR Resourcing Ltd London, United Kingdom

    2 weeks ago

    Default job background
    Full time
    Description

    Salary 55, ,000 GBP per year

    Requirements:

    Any migration to Cloud development
    Strong SQL Knowledge - Azure SQL and ADF
    Designing ETL and DW solutions
    Maintain and support existing solutions (SSIS, MDS, AZURE SQL)
    Exposure to Python and/or R

    Responsibilities:


    •
    Explore the logic used in clinical system reports and translate them into SQL queries.

    •
    Collection and analysis of requirements

    •
    Creation of advanced DW-models from the raw clinical dataset

    •
    Crafting and executing queries upon request for data (EMIS and S1)

    •
    Assisting Datawarehouse team for hosting and cleansing the data

    •
    Working closely with the Quality Assurance team to validate results and logics

    •
    Strong SQL knowledge and experience

    •
    Knowledge and experience of working with clinical system datasets (EMIS, S1 and/or Vision) useful

    •
    Experience in designing ETL and DW solutions

    •
    Any knowledge of Python, R, Power BI are hugely desired

    Technologies:

    SQL
    - Azure
    - Cloud
    - Python

    More:

    The purpose of the role is to support the firm's Innovative Business Intelligence platform and the company data landscape by querying clinical system databases and ad-hoc reporting. This is an excellent opportunity to join their rapidly expanding team in London's premier care provider company at an inspiring time. They have a track record of a mutually supportive team working culture for individuals with the ambition and ability to learn quickly and willing to explore real business challenges.
    The role is preliminary responsible for replicating queries from clinical system front-end to SQL queries and then validating the results