Database Programmer – NCCT CTMC Informatics

Department

85126 Wake Forest University Health Sciences - Academic Office of Informatics

Full time

Yes

40

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. The role involves querying and extracting data, as well as integrating 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.

The 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.

• Design and implement database Extract‑Transform‑Load (ETL) procedures and jobs with minimal supervision.
• Implement complex 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.
• Show proficiency with 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).
• Perform other related duties incidental to work described herein.

• 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.

$38.20 – $57.30

Bachelor's degree with computer coursework and four years of experience in computer programming or operations research required, or an equivalent combination of education and experience. Experience with installation and maintenance of personal computers.

N/A

0% 35% 65% to 35% 65% 100% N/A Activity X Standing X Walking X Sitting X Bending X Reaching with arms X Finger and hand dexterity X Talking X Hearing X Seeing Lifting, carrying, pushing and or pulling: X 20 lbs. maximum X 50 lbs. maximum X 100 lbs. maximum

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:

• Base compensation listed within the pay range based on 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.

• 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.

Advocate Health is the third‑largest nonprofit,…