Lead Database Administrator - Enterprise Data & Analytics

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 employee travel policy when working at a remote location.

Position Summary:

Develop, administer, and control institutional data resources to assure their availability, performance, integrity, and security. Provide continuous support by modifying and enhancing existing custom data structures. Create, monitor, and maintain SSIS Extract, Transform, and Load (ETL) processes for internal/external extracts, merging of data across enterprise data sources to create consumable content for our enterprise analytics developers. Administer, monitor, secure, and deploy enterprise analytics tools. Collaborate with organizational analytics teams to migrate existing analytics content to the Power BI infrastructure: including creation of dataflows from enterprise data sources, and development of semantic models for analytics resources. Establish best practice guidelines and development workflows for all analy tics development. Provide Power BI tool support by troubleshooting performance issues, implementing backup/recovery strategies, and managing security models.

Position Responsibilities

Develop and maintain databases and analytical content associated with organizational initiatives.
Develop processes that automate data collection, data integration, and reporting efforts.
Execute Power BI administrative tasks to support infrastructure growth. This involves managing workspaces, securing resources, developing performance monitoring tools, and overseeing deployment pipelines.
Offer best practice guidance and documentation for Power BI development to both internal and external developers. Conduct QA checks of Power BI content before deploying it into production workspaces.
Monitor Power BI capacity activity, addressing issues such as slow report performance, capacity overload, inefficient data models, resource allocation, and long-running queries. Assist with troubleshooting these problems.
Support development teams with Power BI issues by researching, troubleshooting, and engaging with the tool vendor when necessary to resolve problems.
Work with analytics teams across the organization to develop and implement dataflows and semantic models.
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 for business initiatives 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,821.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

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.

This position is not eligible for University sponsorship for employment authorization.

For additional questions contact Kirsten Kordick kirsten-kordick@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.