Database Programmer – NCCT CTMC Informatics

American Addiction Centers•Winston-Salem, NC

22h•Onsite

About The Position

This position is part of a team providing informatics expertise, including data discovery, extraction, analysis, and management. The role reports to the Informatics Lead Database Developer in the CTMC and involves querying, extracting, and integrating data into common data models to support the NCCT Leadership Team and Informatics team's goals. This role leverages data to assist the NCCT in clinical trial startup, from site and study feasibility and patient recruitment to data collection, follow-up metrics, and process assessment.

Requirements

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.
Bachelor's degree with computer course and four years' experience in computer programming or operations research; or, an equivalent combination of education and experience in computer programming.
Experience with the installation and maintenance of personal computers.

Nice To Haves

Existing EPIC Certifications

Responsibilities

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.
Exhibit ability to 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.
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).
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, including researching, recommending, and installing new computer system hardware and software.
Take a lead role in data flow analysis and design of multi-programmer projects, and may supervise quality of work of lower level programmers.
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.
Perform other related duties incidental to work described herein.

Benefits

Comprehensive suite of Total Rewards: benefits and well-being programs
Competitive compensation
Generous retirement offerings
Programs that invest in your career development
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
Opportunity for annual increases based on performance