Job Description

Performs a critical role in supporting clinical and translational research by leading customer engagement, translating research needs into technical solutions, and delivering high-quality data resources. This position works closely with faculty, study teams, and technical staff to ensure timely, accurate, and mission-aligned data delivery. As a core member of a high-performance team, they will ensure data pipelines are consistently and reliably maintained and analytics capabilities are delivered at an optimum level, helping the organization identify research insights from a large number of diverse datasets.

Qualifications

Responsibilities

The following statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all job responsibilities performed.

• Customer Engagement & Requirements Gathering
  Lead scoping and documentation of clinical research data requests, ensuring clarity and alignment with organizational objectives.

• Technical Translation of Research Needs
  Translate clinical and research requirements into actionable technical specifications, including SQL queries and data model designs.

• Data Solution Development
  Design, build, and maintain data resources such as relational databases, data marts, data lakes, and flat files (.csv) for research use.

• SQL Query Development & Validation
  Write, test, and optimize SQL queries to extract and transform data, contributing to code reviews and ensuring data quality.

• Project Coordination & Timely Delivery
  Execute data requests within defined scope and timelines, maintaining responsiveness to a one-business-day service level agreement (SLA).

• Data Quality Assurance
  Identify and resolve data anomalies, validate new data sources, and troubleshoot data quality issues to ensure reliability.

• Ad Hoc Data Analysis
  Provide flexible, on-demand data analysis to support business decisions and research inquiries.

• Documentation & Standards Development
  Contribute to the standardization of documentation and adoption of best practices, including writing specifications and job aids.

• Technology & Product Research
  Investigate new tools, technologies, and data sources to improve research capabilities and inform future development.

• Perform all other duties as assigned.

Education and Experience

• Bachelor’s degree in health science related field (e.g. biostatistics, epidemiology, etc.) or technology (e.g. computer science, engineering, etc.), or a related field from an accredited institution
• At least two (2) years of experience writing reports against enterprise data warehouses.
• At least two (2) years of experience writing reports using healthcare data against Epic data warehouses (Clarity or Caboodle) preferred.
• At least two (2) years of experience using standardized clinical code systems (e.g. ICD10, SNOMED CT, LOINC, RxNorm, UMLS) and common data models (OMOP)
• At least two (2) years of experience in a healthcare reporting or biomedical research environment working with enterprise data warehouses, including data profiling, data quality assessments, data analysis/reporting, data set curation
• At least two (2) years of SQL programming expertise

Skills

• Experience working within HIPAA-compliant or other highly confidential data environments
• Experience working in an academic core service or research support service
• Excellent customer service skills
• Excellent written and oral communication skills
• BI developer skills (e.g. Tableau reports, Power BI)
• Strong analytical skills, critical thinking, attention to detail and accuracy, and strong inter-personal skills
• Ability to communicate with cross functional teams, ability to support development of BI dashboards and reports, and data analytic initiatives
• Advanced communication skills and proficiency with MS Office

Additional Information

All your information will be kept confidential according to EEO guidelines.

Like many employers, UMMS is being targeted by cybercriminals impersonating our recruiters and offering fake job opportunities. We will never ask for banking details, personal identification, or payment via email or text. If you suspect fraud, please contact us at careers@umms.edu.