Lead Database Administrator - Enterprise Data & Analytics
Education Required
Bachelor’s in Computer Science, Engineering or MIS or an equivalent combination of education and experience.
Required Qualifications
- Typically, 5 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.
- Experience using statistical computer languages (R, Python, SQL, etc.) to manipulate data and draw insights from large data sets.
- Ability to interpret, modify and create complex custom database stored procedures and functions.
- Experience with interpreting query execution plans to identify opportunities for improved performance in a very high-volume database environment.
- Extensive experience with Microsoft SQL Server.
- Proficiency in Power BI
- Excellent communication skills, both written and oral, and strong interpersonal skills.
Desirable Qualifications:
- Cloud computing in Microsoft Azure including Power BI solution architecture, data lake storage techniques and strategies and ETL using Synapse/Data Factory.
- Experience implementing source/version control in SSIS.
- Practical experience working with the Epic EHR and their Clarity and Caboodle analytic platforms.
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 required to self-disclose any conviction history and will be subject to a criminal background check and credential/education verification.
For additional questions contact Kirsten Kordick kirsten-kordick@uiowa.edu
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.
