Atrium Health
Database Programmer - NCCT CTMC
Atrium Health, Winston Salem, North Carolina, United States, 27104
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 trialsgreatly 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 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. EDUCATION/EXPERIENCE
Bachelor's Degree in an applicable field with 3 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 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.
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 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. About the Team Mission, Vision and Culture Commitments Mission To improve health, elevate hope and advance healing for all. Vision To be the first and best choice for care. Culture Commitments We create a space where all Belong We Work as One to make great things happen We earn Trust in all we do We Innovate to better the now and create the future We drive for Excellence always 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: 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 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
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 nations 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. Database Programmer - NCCT CTMC #J-18808-Ljbffr
The
National Center for Clinical Trials (NCCT)
is designed to serve as an innovative platform to revolutionize and catalyze the conduct of clinical trialsgreatly 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 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. EDUCATION/EXPERIENCE
Bachelor's Degree in an applicable field with 3 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 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.
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 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. About the Team Mission, Vision and Culture Commitments Mission To improve health, elevate hope and advance healing for all. Vision To be the first and best choice for care. Culture Commitments We create a space where all Belong We Work as One to make great things happen We earn Trust in all we do We Innovate to better the now and create the future We drive for Excellence always 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: 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 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
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 nations 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. Database Programmer - NCCT CTMC #J-18808-Ljbffr