Senior Database Administrator - University of Iowa

The University of Iowa Institute for Clinical and Translational Science (ICTS) Biomedical Informatics Core is seeking a senior database administrator which includes analysis, design, documentation, development, testing, implementation, and maintenance of the Clinical Research Data Warehouse (CRDW). The position will be responsible for extensive data processing, extraction, integration, analysis and database development activities. This position functions as a SQL and ETL developer for the Clinical Research Data Warehouse (CRDW) for meeting diverse research data requirements.

Duties to include but not limited to:

Design, develop and support of database management systems (based on Microsoft SQL and others as assigned) that use the relational structure.
Perform analysis of third party data sources for loading into the Clinical Research Data Warehouse (CRDW).Troubleshoot assigned applications and customer reported issues.
Design / update relational and dimensional data models.
Create / manage / database and required database objects (tables, indexes, stored procedures etc.)
Translate customer needs to technical teams.
Analyze data models (as needed) and extract / integrate data.
Implements relational, dimensional models using appropriate ETL/BI tools and techniques.
Use appropriate ETL, BI tools and techniques for required data processing, data loading, reporting and analytics.
Provide operational support.
Contribute ideas. Seek way to improve assigned processes. May provide functional supervision; provide direction, assignments, feedback, coaching and counseling to assure outcomes are achieved.
Work in cross functional team environment and coordinate work/activities.

Qualifications: Skills

Duties to include but not limited to:

Design, develop and support of database management systems (based on Microsoft SQL and others as assigned) that use the relational structure.
Perform analysis of third party data sources for loading into the Clinical Research Data Warehouse (CRDW).Troubleshoot assigned applications and customer reported issues.
Design / update relational and dimensional data models.
Create / manage / database and required database objects (tables, indexes, stored procedures etc.)
Translate customer needs to technical teams.
Analyze data models (as needed) and extract / integrate data.
Implements relational, dimensional models using appropriate ETL/BI tools and techniques.
Use appropriate ETL, BI tools and techniques for required data processing, data loading, reporting and analytics.
Provide operational support.
Contribute ideas. Seek way to improve assigned processes. May provide functional supervision; provide direction, assignments, feedback, coaching and counseling to assure outcomes are achieved.
Work in cross functional team environment and coordinate work/activities.

Qualifications: Experience

Education Qualifications

Bachelor's degree in Computer Science, Engineering, Information Science or related field or equivalent combination of education and relevant application development experience.

Experience Requirements
Experience (typically 3-5 years) in complex SQL writing, data extraction and data modeling.
Experience (typically 3 years) working with ETL tools (SSIS etc).
Demonstrated ability to work with multi-disciplinary teams and multiple projects simultaneously.
Healthcare domain knowledge and familiarity with healthcare standards and terminologies, i.e. ICD9 Codes, CPT4 Codes etc.

Desirable Qualifications
Familiarity with healthcare system (Epic preferably) and the underlying database structures (e.g., Clarity, Caboodle).
Epic certifications(s) related but not limited to the following: Clarity Data Model, Clinical Data Model, Cogito Fundamentals
Experience working with 3rd party data to define system requirements, integration strategies and implement interfaces.
Experience with BI and other data warehousing tools.

Qualifications: Education
Bachelor's degree
How to apply

Application Process: In order to be considered, applicants must upload a resume and cover letter (under submission relevant materials) that clearly address how they meet the listed required and desired qualifications of this position to jobs@uiowa.edu under requisition #21003338.

Job openings are posted for a minimum of 14 calendar days. Applications will be accepted until 11:59 PM on August 22, 2021.

Successful candidates will be subject to a criminal background check.

Please note regarding references: Five professional references will be requested and required at a later step in the recruitment process.

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

Application Instructions

Application Process: In order to be considered, applicants must upload a resume and cover letter (under submission relevant materials) that clearly address how they meet the listed required and desired qualifications of this position to jobs@uiowa.edu under requisition #21003338.

Job openings are posted for a minimum of 14 calendar days. Applications will be accepted until 11:59 PM on August 22, 2021.

Successful candidates will be subject to a criminal background check.

Please note regarding references: Five professional references will be requested and required at a later step in the recruitment process.

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

Employer/Host
Employer Job ID
21003338
Job Family
Job Type
City

Iowa City, IA
United States

Last modified
Sunday, August 22, 2021 - 08:00