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.
ICTS Description: The Institute for Clinical and Translational Science (ICTS) at the University of Iowa was approved by the Iowa Board of Regents in 2007 to support the work of investigators involved in clinical and translational science. Our mission is to accelerate translational science through programs to develop the translational workforce, to promote engagement of community members and other stakeholders, to promote research integration across the lifespan, and to catalyze innovative clinical and translational research. These efforts will lead to the development of novel therapies and healthcare delivery strategies, the integration of translational research and clinical practice, and, ultimately to measurable improvements in the health of Iowa and the nation.
Percent of Time: 100%
Pay Grade: 4B
Regular salaried position located in Iowa City, Iowa
Fringe benefit package including paid vacation; sick leave; health, dental, life and disability insurance options; and generous employer contributions into retirement plans
For more information about Why Iowa?, click here
Bachelor's degree in Computer Science, Engineering, Information Science or related field or equivalent combination of education and relevant application development experience.
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.
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.
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 https://uiowa.referrals.selectminds.com/jobs/senior-database-administra….
Job openings are posted for a minimum of 14 calendar days. Applications will be accepted until 11:59 PM on December 31, 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.