Database Programmer

• 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

• 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

Existing EPIC Certifications a huge plus

• 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