Lead Database Administrator - Military Veterans

This position is eligible for remote work within Iowa and will require a work arrangement form to be completed upon the start of your employment. Per policy, work arrangements will be reviewed annually, and must comply with the and .

Position Summary:

Develop, administer, and control institutional analytic data resources across multiple domains to assure their availability, performance, integrity, and security. Provide ongoing support (modifications, enhancements) to existing custom data warehouse structures. Design and implement data warehouse structures in relational (MS SQL Server) and cloud (MS Azure) environments. Extend content in our Caboodle data warehouse (from EHR vendor, Epic) by: Administration of vendor-supplied Extract, Transform and Load (ETL) processes, Creation of vendor and non-vendor-supplied database objects, Participate in the integration of non-Epic sourced data. Develop and maintain various Power BI components (Dataflows, Semantic Models, etc.). Contribute to the development of a future Master Data Management implementation. Aid in troubleshooting performance problems, backup/recovery strategies, security models, etc.

Position Responsibilities

• Create and maintain databases and analytic applications associated across a variety of domains.
• Support development of processes that automate data collection, data integration, and reporting.
• Develop, implement, and maintain statistical models and machine learning algorithms.
• Perform statistical analysis and interpret data to create actionable insights.
• Collaborate with cross-functional teams to implement models and monitor outcomes.
• Design and build predictive models and machine-learning algorithms.
• Maintain clear and complete documentation for all analytical processes and procedures.
• Provide data management support to ensure data quality, consistency, and accuracy.
• Adapt and learn new methodologies or tools based on project requirements.
• As a member of HCIS, adhere to Enterprise Analytics Division expectations.
• Participate in upgrade-related validations as needed for source systems.
• Participate in off hours support as needed .

Health Care Information Systems (HCIS) provides and supports information and communication systems and technology that facilitate quality patient care, progressive medical education, and innovative research.

HCIS services Iowa Health Care by providing comprehensive, high-level support for patient care delivery, internal and external communication, technology innovation, medical education, and research. Creating and maintaining a positive, productive, and rewarding environment for information technology and communication staff

Pay Grade: https://hr.uiowa.edu/pay/pay-plans/professional-and-scientific-pay-structure

University of Iowa offers a generous benefits package, including 24 days paid vacation per year to start and paid sick leave. Complete information regarding the full benefits package may be viewed at https://hr.uiowa.edu/benefits

Salary: $82,812.00 to commensurate - 5B

Percent of Time: 100%

Location: 3281 Ridgeway Dr, Coralville, IA 52241

Staff Type: Professional & Scientific

Type of Position: Regular

Education Required

Bachelor's in Computer Science, Engineering or MIS or an equivalent combination of education and experience.

Required Qualifications

• 3-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 Stuart Wood stuart-wood@uiowa.edu

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.