Brown University Health is seeking a Research Data Analyst to strengthen its research data ecosystem. In this onsite role in Providence, RI, you will help transform ingested clinical and research data into governed, research-ready formats. The work includes ontology, vocabulary, and metadata development, plus mapping data into a i2b2 (or similar common data model) structure that supports cohort identification and standardized access.
You will collaborate with the Data Architecture & Analytics team to deliver reliable data foundations for researchers, with a clear focus on data quality, documentation, and research governance. This position offers a salary range of USD 82,284 - 135,782 per year and a schedule of M-F 8:30am-5:00pm (day shift, 8 hours per day).
Responsibilities
- Design, build, and maintain 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 such as SNOMED CT, ICD-10-CM, LOINC, RxNorm, and CPT.
- Develop and maintain research environment metadata 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 data into i2b2 fact and dimension tables (or a similar common data model) within ingest pipelines operated by Data Architecture & Analytics.
- Validate data completeness, accuracy, and longitudinal consistency using data profiling and quality checks, and investigate and resolve data-quality issues with source system owners.
- Apply data governance requirements during daily work, including confirming IRB approvals and data use agreements, minimum-necessary data delivery, de-identified and limited data set standards, and documentation supporting accounting of disclosures.
- Identify recurring needs and common definitions that can become reusable data products, standard concept sets, or self-service capabilities, and recommend prioritization to the Manager, Research Data.
- Perform other duties as assigned.
Requirements
- Advanced SQL skills, including complex multi-table queries, transformations, views, and performance tuning on large clinical data sets in Snowflake, SQL Server, PostgreSQL, or Oracle.
- Strong knowledge of clinical terminologies including SNOMED CT, ICD-10-CM, LOINC, RxNorm, CPT, and UMLS, including hierarchies, mappings, and versioning.
- Experience working with electronic health record data and its complexities for research or analytics.
- Ability to own analytic work from requirements through delivery with limited day-to-day supervision.
- Strong attention to detail and consistent documentation, including the ability to explain data definitions and limitations to researchers and non-technical audiences.
Preferred Qualifications
- Hands-on experience with i2b2 or OMOP, including loading data into the model, ontology or vocabulary build-out, and cohort discovery tools such as the i2b2 web client or ATLAS (highly preferred).
- Prior experience as a researcher, research analyst, or research coordinator on funded studies, including familiarity with the research lifecycle from protocol through publication.
- Working knowledge of research data frameworks, including common data models, cohort discovery, FAIR data principles, and observational and retrospective research.
- Understanding of research data governance, including IRB processes, data use agreements, HIPAA de-identification, limited data sets, and access controls.
- Experience with Epic Clarity or Caboodle.
- Proficiency in Python or R for data parsing, profiling, and validation.
- Experience with modern cloud data platforms.
Minimum Qualifications
- 4+ years of hands-on data analysis experience in an academic medical center, healthcare organization, biomedical research, or life sciences environment, including direct work with clinical or electronic health record data.
- Bachelorโs degree in Biomedical or Clinical Informatics, Health Information Management, Computer Science, Data Science,
Technologies: SQL, Snowflake, SQL Server, PostgreSQL, Oracle, SNOMED CT, ICD-10-CM, LOINC, RxNorm, CPT, UMLS, i2b2, OMOP, ATLAS, Python, R, Epic Clarity, Caboodle
Location: Corporate Headquarters - 15 LaSalle Square Providence, Rhode Island 02903
Driving required: No