Database Architect– Enterprise Data Warehouse
Education Required
A Bachelor’s degree in computer science or MIS or an equivalent combination of education and experience
Required Qualifications
- Typically, 7-10 years of experience working directly with relational database systems using SQL and SQL procedural languages. Required skills include a thorough understanding of relational database design fundamentals and the ability to write and interpret highly complex SQL DML and DDL statements.
- Ability to interpret, modify and create complex custom database stored procedures and functions.
- Experience with interpreting query execution plans in order to identify opportunities for improved performance in a very high-volume database environment.
- Extensive experience with Microsoft SQL Server.
- Ability to work directly with data consumers and subject matter experts and effectively translate their analytic requirements into technical database design specifications.
- Advanced problem-solving abilities.
- Excellent communication skills, both written and oral, and strong interpersonal skills.
Desirable Qualifications:
- IT work experience in the healthcare industry.
- Understanding of basic business principles (e.g. General Ledger, A/R, etc.)
- Basics of Microsoft’s SQL Server Integration Service ETL tool.
Working knowledge of OLAP data structures using Microsoft SQL Server Analysis Services. - Experience implementing source/version control in SSIS.
- Practical experience working with the Epic EHR and their Clarity and Caboodle analytic platforms.
In order to be considered, applicants must upload a resume (under submission relevant materials) that clearly addresses how they meet the listed required and desired qualifications of this position. A cover letter is desired as part of the application process. Job openings are posted for a minimum of 14 calendar days. This job may be removed from posting and filled any time after the minimum posting period has ended.
Successful candidates will be subject to a criminal background and credential check. This position is not eligible for University sponsorship for employment authorization.
Equal opportunity/affirmative action employer
The University of Iowa is an equal opportunity/affirmative action employer. All qualified applicants are encouraged to apply and will receive consideration for employment free from discrimination on the basis of race, creed, color, religion, national origin, age, sex, pregnancy (including childbirth and related conditions), disability, genetic information, status as a U.S. veteran, service in the U.S. military, sexual orientation, gender identity, or associational preferences.
Persons with disabilities who need assistance or accommodations with the application or interview process may contact University Human Resources/Faculty and Staff Disability Services, (319) 335-2660 or fsds@uiowa.edu. For jobs in UI Health care, please contact UI Health care Leave & Disability Administration at 319-356-7543.
