Database Programmer – NCCT CTMC Informatics

Advocate Health And Hospitals Corporation

Job Location:

Winston Salem, NC - USA

Monthly Salary: $ 37 - 56

Posted on: 23 hours ago

Vacancies: 1 Vacancy

Job Summary

Department:

85296 Wake Forest University Health Sciences - Clinical Trial Methods Center of Excellence

Status:

Full time

Benefits Eligible:

Yes

Hours Per Week:

Schedule Details/Additional Information:

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 priorities set 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.

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 lineages and 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

Pay Range

$37.50 - $56.25

EDUCATION/EXPERIENCE: Bachelors 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: N/A 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 PHYSICAL REQUIREMENTS: 0% 35% 65% to to to 35% 65% 100% N/A Activity X Standing X Walking X Sitting X Bending X Reaching with arms X Finger and hand dexterity X Talking X Hearing X Seeing Lifting carrying pushing and or pulling: X 20 lbs. maximum X 50 lbs. maximum X 100 lbs. maximum

Our CommitmenttoYou:

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:

Compensation

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 teammates 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 andShort- 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

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 155000 teammates across 69 hospitals and over 1000 care locations and offers one of the nations largest graduate medical education programs with over 2000 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.

Required Experience:

Department:85296 Wake Forest University Health Sciences - Clinical Trial Methods Center of ExcellenceStatus: Full timeBenefits Eligible:YesHours Per Week:40Schedule Details/Additional Information:This position will be part of a team that provides informatics expertise including data discovery extrac...