SUMMARY:
Reporting to the Manager, Research Data, the Research Data Analyst is the primary analyst for the build out of Brown University Health's research data ecosystem: a secure cloud environment that integrates, curates, and validates clinical and research data, supports cohort identification, and provides governed, standardized access for investigators and external partners.
The Analyst owns the build-out of the ontologies, vocabularies, and metadata that make research data understandable and usable. The primary focus is transforming ingested data into i2b2 or a similar common data model, mapping local source data to standard clinical terminologies, and documenting what each data element means, where it came from, and how it was derived. Over time, the Analyst may support extending the environment to additional data models such as OMOP.
This is a hands-on role with a high degree of ownership. The Analyst is expected to drive much of their own analytic work, working within the processes, roadmap, and vision set by the Manager, Research Data, the Director, Data Architecture, and the Chief Data and Analytics Officer. The Analyst works closely with investigators, the research facilitation group, and the technical staff building out the research data ecosystem.
PRINCIPAL DUTIES AND RESPONSIBILITIES:
The Research Data Analyst will be responsible for the ontology, vocabulary, metadata, and analytic work that turns ingested source data into curated, research-ready data. Responsibilities include:
- Own the design, build-out, and maintenance of i2b2 (or similar common data model) ontologies, including hierarchies, local concepts, synonyms, code crosswalks, and terminology version updates.
- Map local, non-standard source codes (for example, hospital-specific billing codes, custom lab panels, and flowsheet rows) to standard clinical terminologies, including SNOMED CT, ICD-10-CM, LOINC, RxNorm, and CPT.
- Develop and maintain the metadata needed to understand data ingested into the research data environment, including data dictionaries, source-to-target mappings, mapping provenance, data lineage, and plain-language definitions for researchers.
- Write, test, and optimize SQL transformations that move ingested source data into i2b2 fact and dimension tables (or a similar common data model), working within the ingest pipelines operated by Data Architecture & Analytics.
-
(
function() {
try {
if(window.location && window.location.search && window.location.search.indexOf('capture-sitebehaviour-heatmap') !== -1) {
sessionStorage.setItem('capture-sitebehaviour-heatmap', '_');
}
var sbSiteSecret = '251f277f-b561-4b0a-b647-b48d1ec96ce7';
window.sitebehaviourTrackingSecret = sbSiteSecret;
var scriptElement = document.createElement('script');
scriptElement.defer = true;
scriptElement.id = 'site-behaviour-script-v2';
scriptElement.src = 'https://sitebehaviour-cdn.fra1.cdn.digitaloceanspaces.com/index.min.js?sitebehaviour-secret=' + sbSiteSecret;
document.head.appendChild(scriptElement);
}
catch (e) {console.error(e)}
}
)()