Data Engineer - Tennessee Population Health Consortium

University of Tennessee Heal Science Center

Memphis, TN

ID: 7118835
Posted: December 22, 2022
Application Deadline: Open Until Filled

Job Description

JOB SUMMARY/ESSENTIAL JOB FUNCTIONS: Under the direction of the assigned supervisor, this position will support the work of the TN-PHC initiatives and Tennessee Population Health Data Network (TN-POPnet). This position will be responsible for co-managing the EHR & claims data extraction, integration, and standardization and provide direct support to UTHSC in the development of research projects.

DUTIES AND RESPONSIBILITIES:

Assists in general management of the TN-POPnet database.
Assists in migrating electronic health records data from various clinics/hospitals and healthcare vendors across secure servers into our database.
Creates scripts and tooling to clean raw data from data providers.
Utilizes common data models like OMOP to simplify data linkages, creating data extracts and reports.
Creates data architecture for data network to enhance reporting and analysis capabilities.
Assists in onboarding new registry data providers and working closely with data providers regarding data requirements, feedback, and deliverables.
Collaborates with UT information technology and the Center for Biomedical Informatics at UTHSC to troubleshoot data-related issues.
Provides project status reports to TN-PHC management and collaborators.
Performs administrative duties related to research projects including paperwork preparation for IRB approvals.
Creates data extracts and analytical files for individual projects.
Assists in building and maintaining analytical dashboards for statistical & performance metrics using Power BI.
Develops research designs and analysis plans in collaboration with the study investigators.
Creates appropriate data visualization (tables, figures, etc.) and other research-related materials for scientific papers and grant applications.
Manages development, programming and improvement of the Heart Health Message Program and other text messaging services.
Performs other related duties as assigned.


MINIMUM REQUIREMENTS:



EDUCATION: Master’s Degree in statistics, mathematics, data analytics, management information systems, life sciences or engineering. (TRANSCRIPT REQUIRED)



EXPERIENCE: Four (4) years of experience in data analytics. Must be proficient in statistical methods (ANOVA, Regression analysis, Trees, Clustering, SVM, NLP, Ensemble methods) as well as statistical software (R, SAS, JMP). High proficiency in SQL, use of subqueries, aggregates, cursors and test scripts, use of Linux command line, REDCap and Twilio.



KNOWLEDGE, SKILLS, AND ABILITIES:

Proficient in Oracle SQL Developer, R scripting, Tableau, Shell Scripting, server administration/operation/navigation, general software interfacing, statistical analysis & data cleaning.
Ability to optimize different analyses by using multiple machine threads/cores/processors by utilizing parallel computing/high-performance computing technologies such as Spark, Hadoop, and web services from Microsoft Azure and/or Amazon Web Services.
Proficient in statistical methods (ANOVA, Regression analysis, Trees, Clustering, SVM, NLP, Ensemble methods) as well as statistical software (R, SAS, JMP).
Ability to implement OMOP Common Data Model.
Excellent communication skills, personal, written, and presentation skills are essential.
Ability to work with diverse faculty and staff of various experience levels.
Analytical and problem-solving skills.