Senior Data Analyst
Currento Using Structured Query Language (SQL), provide clinical investigators with customized data sets by extracting and reporting data from clinical databases. o Utilize Python with Pandas and other Python analytical tools and libraries to clean, transform, combine and analyze data from disparate sources and formats including CSV and XML.o Proficient in use of Jupyter Notebooks, Microsoft SQL Server Management Studio, Oracle SQL Developer, MS Visual Code and other data extraction and code editing platforms.o Independently manage large, complex research data requests requiring deep understanding of Epic Clarity, Epic Caboodle and OMOP database structures.o Use knowledge of medical standardized vocabularies (such as ICD10, CPT, LOINC, SNOMED) to define and standardize clinical concepts used by clinical investigators. Utilize UMLS’s Metathesaurus and other online medical terminology resources to identify specific medical ontologies useful to clinical investigatorso Regularly meet with Pl and clinical teams leading research projects to advise, consult and provide updates on data pull requests. Identify relationships and trends in data, as well as any factors that could affect the results of research.o Develop data models for applications, metadata tables, views or related database structures. Design and develop data marts for researchers to simplify the reporting process. Design and implement warehouse database structures in collaboration with software architects.o Develop data management standards, procedures and documentation, using knowledge of the healthcare regulatory environment to ensure conformance to internal and external policies, protocols, and regulations such as HIPAA. Maintain security and confidentiality of patient information.