Advocate Aurora Health · 3 months ago
Database Programmer – NCCT CTMC Informatics
Winston Salem, NC - 486 N Patterson Ave
Full-time
Onsite
Mid, Senior Level
$37.50/hr - $56.25/hr
4+ years expAdvocate Aurora Health is the third-largest nonprofit, integrated health system in the United States, and they are seeking a Database Programmer to join their Clinical Trial Methods Center of Excellence. This role involves designing and implementing database ETL procedures, analyzing data needs, and mentoring junior programmers to support clinical trial operations.
Health Care
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
Implements complicated queries to databases and create automated reporting schemes. Analyzes and develops quality control needs of large projects
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
Performs other related duties incidental to work described herein
Qualification
Required
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 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
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)
Preferred
Existing EPIC Certifications a huge plus
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
Company
Advocate Aurora Health
Advocate Aurora Health is a Healthcare
10001+ employees
H1B Sponsorship
Advocate Aurora Health has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
Funding
Current Stage
Late StageTotal Funding
$10.17MKey Investors
National Cancer Institute
2022-12-02Acquired
2019-08-20Grant· $10.17M
Leadership Team
Don Fosen - CISM, HCISPP
Chief Technology Officer
Jon Kluge
Chief Operating Officer, Senior Vice President, Advocate Aurora Medical Group
Recent News
GlobeNewswire News Room
2025-02-17
Home Health Care News
2024-03-30
Charlotte Business Journal
2023-11-21
Company data provided by crunchbase