Database Programmer - NCCT CTMC Informatics

Advocate Aurora Health • Winston Salem, NC

56d • $38 - $56

About The Position

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.

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 required; 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 a huge plus

Responsibilities

• 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.
• Oversees all phases of database design, development, management and reporting for large and/or complicated projects for an assigned department/section.
• 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.
• 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.
• Maintains software and troubleshoot complicated software products. Troubleshoots PC and mini-computer hardware problems.
• Performs complicated data transfers and conversions.
• Creates and maintains user manuals and documentation of software products.
• Designs and implements a comprehensive software testing plan for software products developed.
• Creates and maintains project and/or departmental webpages and related information.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Hospitals
• Number of Employees: 5,001-10,000 employees