Database Programmer – NCCT CTMC Informatics

Advocate Health and Hospitals Corporation • Winston Salem, NC

46d • $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