Database Administrator - Otolaryngology

The University of Iowa; Iowa City (IA); On-site; USD 65,000 - 90,000; Full time

Job summary

The University of Iowa is seeking a Clinical Research Data Analyst to provide data management and analysis for the Department of Otolaryngology. You will design and implement database functionality, articulate data needs, and fulfill data requests across research teams.

Responsibilities include creating queries, cleansing and validating data, developing dashboards, and collaborating with researchers and IT to support multiple projects in a cross-functional environment.

Qualifications

• Bachelor’s degree in CS/IS/health informatics or data science, or equivalent experience.
• 1+ year experience with database systems (SQL, Oracle).
• Ability to work with multi-disciplinary teams and multiple projects simultaneously.

Responsibilities

• Develop queries to extract data for researchers and fulfill data requests.
• Perform data cleansing, conversions, and validation; conduct data integrity audits.
• Create/maintain database functionality and dashboards for research needs.
• Review database specifications; design and document data models.
• Provide analysis, implementation and support of programmatic solutions.
• Collaborate with researchers, IT teams, and project managers on multiple projects.

Skills

Data analysis

SQL

Team collaboration

Data modeling

Education

Bachelor's degree in CS/IS/health informatics/data science

Tools

SQL

Oracle

MS Access

Job description

The Clinical Research Data Analyst will provide data management and data analysis for the Department of Otolaryngology/Cochlear Implant and Age-Related Hearing Loss Research Teams. This position will work with researchers to design and implement database functionality, help articulate their data needs, define data request requirements, and fulfill data requests. The position will work with a wide variety of healthcare data. The position functions as a data engineer for Department of Otolaryngology/Cochlear Implant and Age-Related Hearing Loss Research Teams for meeting various research data / reporting requirements.

Key Areas of Responsibilities and Specific Job Tasks:

Data Analysis, Migration and Management:

• Utilize database languages to create queries to extract data from the Department of Otolaryngology/Cochlear Implant and Age-Related Hearing Loss Research Teams to fulfil data requests from researchers.
• Manage data cleansing, conversions, and validation. Conduct data integrity audits.
• Develop quality control procedures for database
• Monitor workflow processes; may gather requirements or recommend improvements to processes.

Database Development/Reporting:

Create/maintain database functionality based upon data type, experiment designs, and research needs.

Maintain documentation and respond to database requests.

Create data reports and dashboards

Evaluate data quality and suggest approaches for data cleansing and ensuring data completeness and correction.

Design/Modeling:

Review database specification. Design, review and write documentation.

Implementation:

Provide analysis, implementation and support of programmatic solutions including some application development as needed.

Project Management and Communication:

Collaborating with:

• Research coordinators
• IT teams
• Documenting workflows and database specifications
• Managing multiple research projects simultaneously
• Training researchers on database use

Administration/Support:

Provide technical or application support to users.

Follow established core practices and processes.

Contribute ideas. Seek ways to improve assigned processes.

Work in a cross-functional team environment and coordinate work/activities.

Multi-task on multiple projects for different roles and responsibilities.

Act as a database Subject Matter Expert for research teams.

Required Qualifications:

• Bachelor’s degree in computer science, information systems, health informatics, or data science or equivalent combination of education and relevant experience is required.
• Minimum of 1 year experience with database management systems (e.g., SQL, Oracle).
• Demonstrated ability to work with multi-disciplinary teams and multiple projects simultaneously.

Desired Qualifications:

• Familiarity with healthcare systems (Epic preferably) and the underlying database structures.
• Experience working with MS Access and other database tools.
• Experience working with Electronic Data Capture systems (e.g., REDCap).
• Experience with SQL.
• Experience with database design, normalization, and optimization.

Position and Application Details:

Job openings are posted for a minimum of 7 calendar days and may be removed from posting and filled any time after the original 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. Up to 5 professional references will be requested at a later step in the recruitment process.

For additional questions, please contact [e-mail].

Additional Information

• Classification Title: Database Administrator
• Appointment Type: Professional and Scientific
• Schedule: Full-time

Compensation

Contact Information

• Contact Name: Ashley Nelson
• Contact Email: [e-mail]

Equal opportunity employer

The University of Iowa is an equal opportunity 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, or associational preferences.

Persons with disabilities who need assistance or accommodations with the application or interview process may contact University Human Resources/Faculty and Staff Disability Services, [phone] or [e-mail] . For jobs in UI Health care, please contact UI Health care Leave & Disability Administration at 319-356-7543 .

My Profile

Create and manage profiles for future opportunities.

Contact us to learn more about how to qualify for Veteran's Preference.