CTSI Research Database Programmer

The 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 Advocate Health and Wake Forest School of Medicine through the provision of creative tools and services while maintaining the highest standards for conducting safe and ethical research., 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. Experience with SQL queries and multi-tier SQL system development on multiple platforms (Oracle, SQLServer, Postgres), 1. Oversees all phases of database design, development, management and reporting for large and/or complicated projects for an assigned department/section.

1. 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.

1. 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.

2. 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.

3. Maintains software and troubleshoot complicated software products. Troubleshoots PC and mini-computer hardware problems.

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

5. Performs complicated data transfers and conversions.

6. Creates and maintains user manuals and documentation of software products.

7. Designs and implements a comprehensive software testing plan for software products developed.

8. Creates and maintains project and/or departmental webpages and related information.

9. Performs other related duties incidental to work described herein.

Bachelor’s degree with computer courses and four years’ experience in computer programming or operations research required; or an equivalent combination of education and experience in computer programming., * Strong initiative and proven ability to work independently

• Ability to communicate on a professional level with customers and staff
• Superior problem solving skills
• Additional desirable qualifications include:
• 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, Agile Programming Methodologies, Analysis Skills, Biomedical Research, Cardiology, Clinical Research, Clinical Trial, Communication Skills, Computer Hardware, Computer Programming, Computer Skills, Computer Software, Computer Systems, Customer Experience, Customer Satisfaction, Data Analysis, Data Management, Database Administration, Database Design, Database Extract Transform and Load (ETL), Database Programming, Desktop Administration, Epic Certification, Git, Health Science, Healthcare, Hospital, Identify Issues, Informatics, Management Consulting, Medicine, Microsoft SQL Server, Multiplatform/Cross-Platform, Neuroscience, Nonprofit, Oncology, Operating Systems, Operations Research, Oracle Database, Organ Transplant, Organizational Development/Management, Pediatrics, Performance Management, PostgreSQL, Problem Solving Skills, Product Documentation, Product Planning, Project Control, Project Design, Quality Control, Quality Management, Reporting Skills, Research Skills, Retirement Plan, SQL (Structured Query Language), Software Administration, Software Design, Software Development, Software Development Lifecycle (SDLC), Software Testing, System Integration (SI), Systems Administration/Management, Systems Hardware, Test Design, Test Plan/Schedule, Translational Research, User Documentation

• Comfortable, well-lit office setting
• Occasionally subject to long and/or irregular hours
• Subject to interruptions
• Mostly to fully remote

Our Commitment to You:

Advocate Health offers a comprehensive suite of Total Rewards: benefits and well-being programs, competitive compensation, generous retirement offerings, programs that invest in your career development and so much more - so you can live fully at and away from work, including, * Base compensation listed within the listed pay range based on factors such as qualifications, skills, relevant experience, and/or training

• Premium pay such as shift, on call, and more based on a teammate’s job
• Incentive pay for select positions
• Opportunity for annual increases based on performance

Benefits and more

• Paid Time Off programs
• Health and welfare benefits such as medical, dental, vision, life, and Short- and Long-Term Disability
• Flexible Spending Accounts for eligible health care and dependent care expenses
• Family benefits such as adoption assistance and paid parental leave
• Defined contribution retirement plans with employer match and other financial wellness programs
• Educational Assistance Program

Note: Eligibility for programs listed above may depend on your FTE or status (e.g., full-time, part-time, per diem, temporary, etc.); please ask a Recruiter for more information during an interview.

About Advocate Health

Advocate Health is the third-largest nonprofit, integrated health system in the United States, created from the combination of Advocate Aurora Health and Atrium Health. Providing care under the names Advocate Health Care in Illinois; Atrium Health in the Carolinas, Georgia and Alabama; and Aurora Health Care in Wisconsin, Advocate Health is a national leader in clinical innovation, health outcomes, consumer experience and value-based care. Headquartered in Charlotte, North Carolina, Advocate Health services nearly 6 million patients and is engaged in hundreds of clinical trials and research studies, with Wake Forest University School of Medicine serving as the academic core of the enterprise. It is nationally recognized for its expertise in cardiology, neurosciences, oncology, pediatrics and rehabilitation, as well as organ transplants, burn treatments and specialized musculoskeletal programs. Advocate Health employs 155,000 teammates across 69 hospitals and over 1,000 care locations, and offers one of the nation’s largest graduate medical education programs with over 2,000 residents and fellows across more than 200 programs. Committed to providing equitable care for all, Advocate Health provides more than $6 billion in annual community benefits.