Database Programmer - NCCT CTMC

Department:

85056 Wake Forest University Health Sciences - Academic Clinical and Translational Science Institute (CTSI)

Status:

Full time

Benefits Eligible:

Yes

Hours Per Week:

40

Schedule Details/Additional Information:

Varies

Pay Range

$37.50 - $56.25

Database Programmer – NCCT CTMC Informatics

Winston-Salem NC United States - May be eligible for remote employment

JOB DESCRIPTION

JOB SUMMARY

The National Center for Clinical Trials (NCCT) is designed to serve as an innovative platform to revolutionize and catalyze the conduct of clinical trials−greatly accelerating the translation of scientific findings into improvements in the prevention, diagnosis, and treatment of disease for our communities and patients. The NCCT will offer core services for patient recruitment and enrollment, trial administration and follow-up, and to gather real world data and evidence.

The Clinical Trial Methods Center (CTMC) has been established within the Wake Forest University School of Medicine to provide the necessary tools and expertise that the NCCT will access and apply to deliver many of its core services.

This position will be part of a team that provides informatics expertise including data discovery, extraction, analysis, and management; and will report to the Informatics Lead Database Developer in the CTMC and will query and extract data, as well as integrate data into common data models in support of the tasks, goals, and prioritiesset by the NCCT Leadership Team and Informatics team and project leaders. This role leverages data to help the NCCT execute clinical trial startup, from site and study feasibility, through patient recruitment and data collection, to follow-up metrics and process assessment.

EDUCATION/EXPERIENCE

Bachelor's Degree in an applicable field with3 years of experience writing complex SQL data queries; or an equivalent combination of education and experience. 

ESSENTIAL FUNCTIONS

Design and implement database Extract-Transform-Load (ETL) procedures and jobs with minimal supervision.

Implements complicated queries to databases and create automated reporting schemes. Analyzes and develops quality control needs of large projects.

Document processes, data dictionaries, data lineagesand collect metrics.

Exhibit ability to use a wide variety of research computer software tools and operating system environments.

Attends project and/or departmental meetings and contributes to the project design concerning data management needs. Consults with users on project design needs. Maintains a professional relationship with project and departmental personnel.

Mentor and guide junior database programmers.

Achieve and maintain EPIC Clarity certifications within 2-5 months of hire date (may require up to two trips to EPIC Training facility in Wisconsin)

Performs other related duties incidental to work described herein.

SKILLS/QUALIFICATIONS

Experience with SQL queries and multi-tier SQL system development on multiple platforms (Oracle, SQL Server, Postgres)

Experience with healthcare and/or biomedical research operations and systems

Experience with database systems administration, performance profiling, index creation and evaluation

Experience with agile software development and the software lifecycle

Experience with code versioning systems such as Git

Experience working in cloud environments, particularly Azure and the Snowflake data stack

Strong initiative and proven ability to work independently

Ability to communicate on a professional level with customers and staff

Superior problem-solving skills

Existing EPIC Certifications a huge plus

 

WFUSOM-1

About Us

Wake Forest University School of Medicine (WFUSM) is a U.S. News and World Report top 50 ranked medical school, integrated with a world-class health system, Atrium Health. WFUSM, the academic core of Atrium Health Enterprise, is a recognized leader in experiential medical education and groundbreaking research that includes Wake Forest Innovations, a commercialization enterprise focused on advancing health care through new medical technologies and biomedical discovery. WFUSM has over $300M in annual, extramural funding that drives a cutting-edge Academic Learning Health System by integrating innovative researc