Database Administrator ICTS Biomedical Informatics
Job Summary
The Clinical Research Data Analyst supports biomedical and translational research through the extraction integration analysis and management of complex clinical and research data. This position works closely with researchers clinicians data teams and institutional stakeholders to translate research questions into actionable data solutions using electronic health record (EHR) and related healthcare data sources.
The successful candidate will serve as a key contributor supporting the Enterprise Data Warehouse for Research (EDW4R) and other research data platforms. Responsibilities include data querying cohort identification data validation data integration reporting and support for research data workflows. The position requires strong technical skills attention to detail and the ability to collaborate effectively within interdisciplinary research environments.
This role is not entry level and requires prior experience working with healthcare or biomedical data including familiarity with EHR systems and healthcare data structures. The ideal candidate is intellectually curious collaborative adaptable and capable of independently solving complex data problems in support of clinical and translational research initiatives.
Duties to include but not limited to:
Utilize SQL and related database technologies to extract transform validate and analyze clinical and research data from the Enterprise Data Warehouse for Research (EDW4R) and related systems
Collaborate with researchers and project teams to define data requirements cohort criteria and reporting specifications
Develop and maintain reports queries dashboards and supporting documentation for research and operational needs
Create and maintain database objects forms extracts and reporting workflows supporting research initiatives
Review and interpret database specifications data models and research data requirements
Participate in data modeling and metadata management activities related to clinical and research datasets
Provide analysis design implementation and operational support for research data and reporting solutions
Develop and maintain programmatic solutions and automation workflows supporting research data operations
Provide technical and operational support for research data and associated workflows
Support routine database administration activities including review validation and security processes
Follow established core practices and processes.
Coordinate and provide support on activities across multiple concurrent projects and priorities
For a full job description please send an e-mail to the contact listed below.
About ICTS: 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: 3B
within Iowa: This position is eligible for a combination of on-campus and remote work. Remote work must be performed 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.
Benefits Highlights:
-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 clickhere
Minimum of 3 years of professional experience working with healthcare clinical biomedical or research data
Experience querying and analyzing data using SQL or related database technologies
Experience working with electronic health record (EHR) data and healthcare terminology systems
Understanding of healthcare data structures clinical workflows and healthcare coding systems (ICD CPT LOINC SNOMED etc.)
Demonstrated ability to manage multiple projects and priorities in collaborative environments
Strong analytical organizational communication and problem-solving skills
Ability to work independently while collaborating effectively across interdisciplinary teams
Desirable Qualifications
Experience working with Epic including Clarity Caboodle or related reporting databases
Epic Certifications: Clarity Caboodle
Experience supporting clinical translational or academic research initiatives
Familiarity with research data warehouses and large-scale healthcare datasets
Experience using Python R SAS or similar tools for data analysis or automation
Familiarity with healthcare interoperability and data exchange standards such as HL7 or FHIR
Experience with data visualization and reporting tools such as Tableau or Power BI
Experience working within academic healthcare or CTSA-supported environments
Familiarity with HIPAA data governance and research compliance practices
Application Process:
In order to be considered for an interview applicants must upload the following documents and mark them as a Relevant File to the submission:
Resume
Cover Letter
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.Hybrid within Iowa: This position is eligible for a combination of on-campus and remote work. Remote work must be performed at a location within the state of Iowa and comply with the remote work program and related policies.
For additional questions please contact Amy Stewart at .edu
This position is not eligible for University sponsorship for employment authorization.
Required Experience:
Unclear Seniority
About Company
The University of Iowa is a top-tier public research university in Iowa City—home to more than 32,000 students, offering world-class programs across 200+ fields of study, renowned especially for its creative writing, acclaimed medical center, and balanced excellence in the arts and sc ... View more