Business Intelligence Developer
The team is responsible for delivering high-quality comprehensive clinical and longitudinal data for Genomics England, to ensure:
*Efficient and timely delivery of genome sequencing interpretation results;
*Routine delivery of comprehensive coherent clinical and secondary data resources to facilitate research.
*Supporting the delivery of the Genomic Medicine Service
The Database Developer, with Advanced SQL skills, is accountable for the design, development and deployment of key enterprise wide database applications.
Key Accountabilities Include:
*Understanding and articulating business database requirements
*Designing and developing of enterprise wide databases and data visualisations
*Managing on-going development requests and designing and implementing changes to database structure to meet business requirements
*Ensuring all code is optimised so data is readily accessible by all business users
*Designing, writing and deploying effective business intelligence solutions
*Writing packages for ETL purposes
*Monitoring overall database performance
*Creating Data Visualisations
*Working with relevant internal teams (e.g. platform engineering) and external suppliers and data customers
Key Requirements Include:
*Excellent communication and team working skills with strong problem solving acumen
*Solid applied knowledge of the principles of relational databases, database management and administration, and software particularly Pentaho, PostgreSQL, R, Shiny, Python, Java, Tableau
*Experience working with complex data sets, ideally health-related, in a research, clinical or government setting
*Experience of data modelling and developing data sets and the necessary components for data transfers into those models, for example: developing XML schema definitions, JSON, HL7 FHIR
*Experience developing data extract, transform and load programmes to create a coherent high-quality comprehensive curated data resource.
*Experience with developing scheduled data flows using an integration engine, including message management and trouble-shooting, complex data integration programme sequences of multiple updates to a single data resource
*Experience of developing a single system with a team of developers, with delivery of development through application and system testing to production.
*Experience with developing and delivering data visualisations and analysis tools, experience of clinical data development would be a distinct advantage.
*Familiarity with a programmatic environment for data manipulation to perform common data manipulation tasks including merging, appending, reshaping, identifying duplicates and recoding value
*Ability to programmatically identify missing, inconsistent or out of range values
*Ability to produce summary tabulations and graphs for data visualisation purposes
*Strong and proven orientation towards team and matrix working
*Strong attention to detail
*Excellent organisational skills with a commitment to reproducible work, documentation and record-keeping
*Ability to balance competing demands and work under pressure
*Commitment to responsible and respectful handling of personal identifiable data
*Experience delivering routine clinical data delivery to clinical research programmes.
*Familiarity of NHS clinical data dictionary and datasets and using these data for research.
*Experience of combining clinical data from multiple sources into a single coherent model for use by clinicians or research teams.
*Understanding of the NHS information governance standards, the Information Governance Toolkit and Caldicott Standards in particular.
*Familiarity with phenotype ontologies and disease classifications
*Experience API integration
*Experience using clinical data integration platform and clinical applications
*Familiar with use of AVRO or Protocol Buffers for data modelling
*Ability to write complex SQL syntax. Including any or all of the following: stored procedures, SQL cursor, temporary tables or functions to support an enterprise wide approach to database management and development.
There are some great benefits on offer with this role including a competitive salary, pension, generous holidays and more.
Please do not hesitate to contact Harvey Uppal at firstname.lastname@example.org or call (+44) 121 616 3407 to discuss this opportunity further.
Keywords: Business, Intelligence, Developer, London, Genomics, Clinical, Data, ETL, Database, Visualisation, PostgreSQL, Python, Java, Tableau, Modelling, Pentaho.
Job Reference: BIDGEL_1580488707
Broadcast As: 18372
Salary To: Negotiable
Job Type: Full Time
Job Term: Permanent
Recruitment Consultant: Harvey Uppal