- 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
