The University of Iowa Health Care Information Systems has a opportunity to join our team as a Senior Database Administrator! In this role, you will develop institutional analytic data resources and associated maintenance processes (e.g. ETL) across multiple domains to assure optimal availability, performance, integrity, and security. You will provide ongoing support (modifications, enhancements) to existing custom data warehouse structures. You will design and implement data warehouse models in relational (MS SQL Server) and cloud (MS Fabric) environments. You will maintain and extend content in our Caboodle data warehouse (from EHR vendor, Epic) through the administration of vendor-supplied Extract, Transform and Load (ETL) processes and modification of those processes through the vendor interface. You will support data delivery by developing/maintaining Power BI components (Dataflows, Semantic Models, etc.). You will be under the direction and oversight of senior data architecture staff.
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 remote work program and related policies and employee travel policy when working at a remote location.

EDUCATION REQUIREMENTS:

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

EXPERIENCE REQUIREMENTS:

• 2-4 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 to identify opportunities for improved performance in a very high-volume database environment.
• Extensive experience with Microsoft SQL Server.
• Conversant with Power BI
• Excellent communication skills, both written and oral, and strong interpersonal skills.

DESIRED QUALIFICATIONS:

• Cloud computing in Microsoft Fabric 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.
  This position is not eligible for University sponsorship for employment authorization.
  For additional questions contact Stuart Wood - stuart-wood@uiowa.ed

HCIS services University of 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
• Salary: $75,283.00 to commensurate – Paygrade 4B
• The 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
• Percent of Time: 100%
• Location: 3281 Ridgeway Drive, Coralville, IA
• Staff Type: Professional & Scientific
• Type of Position: Regula

• 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.
• Collaborate with cross-functional teams to implement models and monitor outcomes.
• 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 University of 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

• Salary: $75,283.00 to commensurate – Paygrade 4B
• The 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
• Percent of Time: 100%
• Location: 3281 Ridgeway Drive, Coralville, IA
• Staff Type: Professional & Scientific
• Type of Position: Regular