Applications Systems Programmer/Analyst II

Perform application systems analysis, programming and maintenance using client/server and/or web-based technologies, database administration, and system administration. Manage extract, transform, and load (ETL) processes for clinical research from source healthcare systems into research databases for the Research, Education, Administration, and Development of Biomedical Informatics (READi) Core. Due to the responsibilities of this position, an Epic Clinical Data Model Certification is required., + No

1. • If you are familiar with medical terminologies such as ICD-10, RxNorm, LOINC, and SNOMED CT, please elaborate (If No, indicate NA). (Open Ended Question)
2. • Do you have an Epic Clinical Data Model Certification? + Yes + No
3. • Are you proficient in Microsoft Excel, Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook? + Yes + No
4. • Are you proficient with EPIC, SQL Server, TSQL, HTML, C#, Python, IIS, Windows Development Platform, Windows Operation Systems, .NET and SAS? + Yes + No
5. • If you are proficient with EPIC, SQL Server, TSQL, HTML, C#, Python, IIS, Windows Development Platform, Windows Operation Systems, .NET and SAS, please elaborate (If No, indicate NA) (Open Ended Question)
6. • How did you hear about this position? + Careerlink + Employee Referral + HERC + Indeed + Job Fair + Lincoln Journal Star + Linkedin + Omaha World Herald + UNMC Job Site + Facebook + NEWorks + Handshake + Other
7. • If Other, please specify the source. Otherwise, indicate NA. (Open Ended Question)
8. • Within the past 6 months, have you been affected by a reduction in force or grant funding expiration with the University of Nebraska Medical Center? + Yes + No

Applicant Documents

Required Documents

1. Cover Letter
2. Resume

Optional Documents

Required Education: Bachelor’s degree If any degree major/training is required, please specify the type. (NOTE: Concentration and minors are not equivalent to a major) Biomedical Informatics, Computer Science, Mathematics, or related field

(Will consider seven years related education/experience) Required Experience 3 years If any experience is required, please specify what kind of experience:

• Programming experience of which includes SQL, C+ and/or Python with at least 2 years directly working with biomedical data or structured electronic health record (EHR) data including extracting data from EPIC Clarity database.

• Familiarity with medical terminologies such as ICD-10, RxNorm, LOINC, and SNOMED CT., Required Computer Applications: Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Outlook Required Other Computer Applications: EPIC, SQL Server, TSQL, HTML, C#, Python, IIS, Windows Development Platform, Windows Operation Systems, .NET and SAS Required Additional Knowledge, Skills and Abilities:

• Skilled in highly complex application systems analysis and programming.
• Mathematical analysis skills to develop algorithms to implement system design requirements.
• Excellent communication and interpersonal skills.
• Experience in database project management.
• Knowledge of working in an academic and/or healthcare setting.

Preferred Education: Master’s degree If any degree/training is preferred, please specify the type: Biomedical Informatics, Computer Science, Mathematics, or related field

(Will consider seven years related education/experience) Preferred Experience:

• 5 years or more experience in bioinformatics and/or programming to include the development of databases and/or web applications, information modeling, and identification appropriate database resources for implementation.
• Experience in extracting data from EPIC Clarity database and transforming them into PCORnet and OMOP common data models. Advanced SQL Server Database programming skills including intricate query optimization and superior performance tuning.
• Experience in medical terminologies such as ICD-10, RxNorm, LOINC, and SNOMED CT.
• Some experience in database project management.

Preferred License: No If yes, what is the preferred licensure/certification?: Preferred Computer Applications: Preferred Other Computer Applications: Beaker, Unix-based systems, Windows based systems and bioinformatics databases Preferred Additional Knowledge, Skills and Abilities:

• Demonstrated ability to participate in research activities including manuscript production.
• Ability to work in a team environment.
• Ability to maintain Epic Clinical Data Model Certification or partake in continuing education., 1. * Do you have a Bachelor’s degree in Biomedical Informatics, Computer Science, Mathematics, or related field?
• Yes
• No 2. * Do you have programming experience of which includes SQL, C+ and/or Python with at least 2 years directly working with biomedical data or structured electronic health record (EHR) data including extracting data from EPIC Clarity database?
• Yes
• No 3. * If you do have programming experience of which includes SQL, C+ and/or Python with at least 2 years directly working with biomedical data or structured electronic health record (EHR) data including extracting data from EPIC Clarity database, please elaborate (If No, indicate NA) (Open Ended Question)

1. • Are you familiar with medical terminologies such as ICD-10, RxNorm, LOINC, and SNOMED CT?