United States onlyThe Wake Forest Clinical and Translational Science Institute (CTSI) is a unified research organization designed to provide innovative, efficient, and sustainable infrastructure that accelerates the translation of discoveries to improve health. The CTSI supports faculty and staff conducting research at Wake Forest School of Medicine through the provision of creative tools and services while maintaining the highest standards for conducting safe and ethical research. This position is primarily focused on supporting the work and research of our Comprehensive Cancer Institute.
CTSI is seeking a database professional to build and support data transaction procedures and research-focused application systems. Candidate will collaborate and communicate with faculty, product managers, and other software developers, to design, test, deploy, and support multiple solutions across various database platforms.
Under general supervision, design and implement database Extract-Transform-Load (ETL) procedures and jobs. Document and collect metrics.
Exhibit ability to use a wide variety of research computer software tools and operating system environments.
Achieve and maintain EPIC Clarity certifications within 12 months of hire date (may require up to two trips to EPIC Training facility in Wisconsin)
Additional desirable qualifications include:
1. Experience with SQL queries and multi-tier SQL system development on multiple platforms (Oracle, SQLServer, Postgres)
2. Experience with healthcare and/or biomedical research operations and systems
3. Experience with database systems administration, performance profiling, index creation and evaluation
4. Experience with agile software development and the software lifecycle
5. Experience with code versioning systems such as Git
GENERAL JOB SUMMARY:
Under limited supervision, designs and implements large and complicated research information systems. Exhibits ability to learn to use a variety of research computer software tools and operating system environments. Provides computer systems maintenance support for an assigned department/section.
EDUCATION/EXPERIENCE:
- Bachelor's degree with computer course and four years' experience in computer programming or operations research required; or, an equivalent combination of education and experience in computer programming.
- Experience with the installation and maintenance of personal computers.
LICENSURE, CERTIFICATION, and/or REGISTRATION:
- Expected to complete EPIC certification process within first year of employment, may involve two trips to training center in Wisconsin.
ESSENTIAL FUNCTIONS:
1. Oversees all phases of database design, development, management and reporting for large and/or complicated projects for an assigned department/section.
2. Provides computer systems support for a department/section. Researches, recommends, and installs new computer system hardware and software for the improvement and/or expansion of departmental projects or operations. Makes modifications when necessary to improve system performance and user satisfaction.
3. Takes lead role in data flow analysis and design of multi-programmer projects. May supervise quality of work of lower level programmers on multi-programmer projects.
4. 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.
5. Maintains software and troubleshoot complicated software products. Troubleshoots PC and mini-computer hardware problems.
6. Implements complicated queries to databases and create automated reporting schemes. Analyzes and develops quality control needs of large projects.
7. Performs complicated data transfers and conversions.
8. Creates and maintains user manuals and documentation of software products.
9. Designs and implements a comprehensive software testing plan for software products developed.
10. Creates and maintains project and/or departmental webpages and related information.
11. Performs other related duties incidental to work described herein.
SKILLS/QUALIFICATIONS:
- Strong initiative and proven ability to work independently
- Ability to communicate on a professional level with customers and staff
- Superior problem solving skills
WORK ENVIRONMENT:
- Comfortable, well-lit office setting
- Occasionally subject to long and/or irregular hours
- Subject to interruptions
- Mostly to fully remote
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 research with excellent patient care across our enterprise.
Atrium Health is based in Winston-Salem, North Carolina and is part of Advocate Health, which is headquartered in Charlotte, North Carolina, and is the fifth-largest nonprofit health system in the United States, created from the combination of Atrium Health and Advocate Aurora Health. AHWFB is an 885-bed tertiary-care hospital in Winston-Salem – that includes Brenner Children’s Hospital, five community hospitals, more than 300 primary and specialty care locations and more than 2,700 physicians.
Our highly integrated academic and clinical environment is deeply committed to improving health, elevating hope, and advancing healing – for all.
It should be noted that while you are applying on the Wake Forest University School of Medicine Career Site, you will receive communications from the Atrium Health Recruitment Team. Please know that this is an expected process. Thanks in advance for your flexibility.
