What are the responsibilities and job description for the Database Architect - ICTS - Biomedical Informatics position at Jobs@UIOWA?
Our Database Architect’s support the primary mission of the Institute for Clinical and Translational Science – Biomedical Informatics Core. This position is primarily responsible for solution consultation to grant and research programs. Oversees various specialized data, database, ETL/BI, Master Data Management (MDM) and analysis services. The Database Architect manages a team of database analysts, DBA’s, ETL/BI developers, working with specialized biomedical data to support the primary mission of the Institute for Clinical and Translational Science.
Duties to include but not limited to:
- Lead the architecture, data modeling, ETL/BI (Extract Transform and Load/Business Intelligence) design, development, and implementation for biomedical research tools such as enterprise data warehouse for research (EDW4R) and datamart(s).
- Consults with colleagues and research community to define data architecture requirements, identify needs and verify preliminary design and output of a limited scope.
- Collaborate to lead ongoing development of the enterprise data warehouse for research (EDW4R), an aggregated data structure including patient data and various key extant data sources.
- Architect, design, and develop large-scale (enterprise) data warehouse components. Coordinate all aspects of database application development. Make strategic database application decisions.
- Contribute to the development and management of the ICTS Biomedical Data Request service, which provides researchers with secure and compliant extractions of data from clinical databases including patient medical records and billing.
- Facilitate and coordinate logical and physical databases for highly available and/or complex integrated solutions. Evaluate potential database environment solutions.
- Collaborate and define a vision for moving beyond custom data extraction, migration and management services into a more automated project-specific model that could be replicated across multiple research studies.
- Plan and coordinate multiple database environments including on premise and cloud strategies.
- Serve as technical go-to expert or functional lead; foresee technological change and develop technology roadmaps. Lead project teams.
- Demonstrated ability to lead a team in developing effective solutions and making informed decisions.
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.
This position is eligible to participate in a hybrid (partially remote) and/or remote work schedule. Remote work must be performed at a location within the state of Iowa. 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.
Percent of Time: 100%
Pay Grade: 6B
https://hr.uiowa.edu/pay/guide-pay-plans
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?, click here
Required Qualifications
- A bachelor’s degree in computer science or management information systems and experience in application development is required. An equivalent combination of education and related experience may also meet these minimum requirements.
- A minimum of 7 years of extensive experience understanding of SQL, Java, .net, ruby, or Python programming language(s).
- Strong background in web development and proficient writing in HTML5, CSS, and javascript for multiple web browsers on multiple platforms.
- Extensive experience with web application configuration.
- Extensive experience using Microsoft SQL Server or other relational database systems to design database driven applications.
- Ability to work independently and with multi-disciplinary teams.
- Excellent communication skills and extensive experience working with customers.
- Experience managing application development and database management staff.
- Knowledge and experience with project management and software development methodologies.
- Supervisory experience (1-3 years).
- Professional job-related experience fostering or promoting a welcoming and respectful work/academic environment where people of all backgrounds and perspectives feel welcomed and appreciated; or demonstrated the ability to do so.
- Experience in developing and designing data strategies for data extraction, integration and implementation of systems, data warehouse and data marts.
- Training in health science domain.
- Ability to facilitate, and moderate discussions with stakeholders for decision-making.
- Experience with healthcare systems like Epic, GE-IDX, and Cerner is desirable.
- Ability to present technical concepts to non-technical staff.
- A master’s degree in informatics, computer science, engineering, information science or related field is desirable.
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
Job openings are posted for a minimum of 14 calendar days and may be removed from positing 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.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.
Remote within Iowa: This position is eligible for primarily remote work but may require limited work onsite at times. Remote work must be performed at a location within the state of Iowa and comply with the remote work program and related policies.
As previously discussed, this position is eligible for hybrid 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.
For additional questions, please contact Amy Stewart at amy-stewart@uiowa.edu
This position is not eligible for University sponsorship for employment authorization.
