Atrium Health
Database Programmer – NCCT CTMC Informatics
Atrium Health, Winston Salem, North Carolina, United States, 27104
Position Summary
Department:
Wake Forest University Health Sciences - WF Clinical Trial Methods Center of Excellence
Status:
Full time
Hours Per Week:
40
Benefits Eligible:
Yes
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.
Implement complicated queries to databases and create automated reporting schemes; analyze and develop quality control needs of large projects.
Document processes, data dictionaries, data lineages, and collect metrics.
Use a wide variety of research computer software tools and operating system environments.
Attend project and/or departmental meetings and contribute to the project design concerning data management needs. Consult with users on project design needs and maintain 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).
Perform other related duties incidental to work described herein.
Oversee all phases of database design, development, management and reporting for large and/or complicated projects for an assigned department/section.
Provide computer systems support for a department/section. Research, recommend, and install new computer system hardware and software for the improvement and/or expansion of departmental projects or operations and modify when necessary to improve system performance and user satisfaction.
Take lead role in data flow analysis and design of multi‑programmer projects and may supervise quality of work of lower level programmers on multi‑programmer projects.
Maintain software and troubleshoot complicated software products, including PC and mini‑computer hardware problems.
Perform complicated data transfers and conversions.
Create and maintain user manuals and documentation of software products.
Design and implement a comprehensive software testing plan for software products developed.
Create and maintain project and/or departmental webpages and related information.
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.
Education & Experience Bachelor's degree with computer coursework and four years of 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.
Pay Range $37.50 – $56.25
Benefits
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.
Paid Time Off programs.
Health and welfare benefits such as medical, dental, vision, life, 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.
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.
#J-18808-Ljbffr
Wake Forest University Health Sciences - WF Clinical Trial Methods Center of Excellence
Status:
Full time
Hours Per Week:
40
Benefits Eligible:
Yes
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.
Implement complicated queries to databases and create automated reporting schemes; analyze and develop quality control needs of large projects.
Document processes, data dictionaries, data lineages, and collect metrics.
Use a wide variety of research computer software tools and operating system environments.
Attend project and/or departmental meetings and contribute to the project design concerning data management needs. Consult with users on project design needs and maintain 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).
Perform other related duties incidental to work described herein.
Oversee all phases of database design, development, management and reporting for large and/or complicated projects for an assigned department/section.
Provide computer systems support for a department/section. Research, recommend, and install new computer system hardware and software for the improvement and/or expansion of departmental projects or operations and modify when necessary to improve system performance and user satisfaction.
Take lead role in data flow analysis and design of multi‑programmer projects and may supervise quality of work of lower level programmers on multi‑programmer projects.
Maintain software and troubleshoot complicated software products, including PC and mini‑computer hardware problems.
Perform complicated data transfers and conversions.
Create and maintain user manuals and documentation of software products.
Design and implement a comprehensive software testing plan for software products developed.
Create and maintain project and/or departmental webpages and related information.
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.
Education & Experience Bachelor's degree with computer coursework and four years of 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.
Pay Range $37.50 – $56.25
Benefits
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.
Paid Time Off programs.
Health and welfare benefits such as medical, dental, vision, life, 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.
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.
#J-18808-Ljbffr