Database Programmer - NCCT CTMC Informatics

Department: Wake Forest University Health Sciences - Academic Office of InformaticsStatus: Full timeBenefits Eligible: YesHours Per Week: 40This position is part of a team that provides informatics expertise, data discovery, extraction, analysis, and management. The role reports to the Informatics Lead Database Developer in the CTMC and involves querying and extracting data and integrating data into common data models to support clinical trial startup and ongoing study activities.ESSENTIAL FUNCTIONSDesign 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 for large projects.Document processes, data dictionaries, data lineages and collect metrics.Use a wide variety of research computer software tools and operating-system environments.Attend project and departmental meetings; contribute to project design concerning data management needs; consult with users; maintain professional relationships with colleagues.Mentor and guide junior database programmers.Achieve and maintain EPIC Clarity certifications within 2–5 months of hire date.Provide computer-systems maintenance support for an assigned department or section.Oversee all phases of database design, development, management, and reporting for large or complicated projects.Research, recommend, and install new computer-system hardware and software to improve departmental projects or operations.Lead data-flow analysis and design of multi-programmer projects; supervise quality of work of lower-level programmers on such projects.Maintain software and troubleshoot complex software products; troubleshoot PC and mini-computer hardware problems.Perform complex data transfers and conversions.Create and maintain user manuals and documentation of software products.Design and implement comprehensive software testing plans for developed software products.Create and maintain project or departmental webpages and related information.Perform other related duties incidental to described work.SKILLS & QUALIFICATIONSExperience with SQL queries and multi-tier SQL system development on multiple platforms (Oracle, SQL Server, PostgreSQL).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 professionally with customers and staff.Superior problem-solving skills.Existing EPIC certifications are a huge plus.Pay Range$38.20 – $57.30 per hourEducation / ExperienceBachelor's degree with computer science coursework and four years of experience in computer programming or operations research, or an equivalent combination of education and experience.OUR COMMITMENT TO YOUCompensationBase compensation within the listed pay range based on qualifications, skills, relevant experience, and/or training.Premium pay such as shift and on-call pay as applicable.Incentive pay for select positions.Opportunity for annual increases based on performance.Benefits & MorePaid Time Off programs.Health, dental, vision, life, short- and long-term disability benefits.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.J-18808-Ljbffr