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.
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 analytics 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.
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 Kirsten Kordick kirsten-kordick@uiowa.edu
Additional Information
- Classification Title: Lead Database Administrator
- Appointment Type: Professional and Scientific
- Schedule: Full-time
- Work Modality Options: Remote within Iowa
Compensation
- Pay Level: 5B
- Starting Salary Minimum: 82,821.00
Contact Information
- Organization: Healthcare
- Contact Name: Kirsten Kordick
- Contact Email: kirsten-kordick@uiowa.edu