Healthcare Data Analyst

Department

BSD CRI - Data Warehouse

About the Department

The University of Chicago biomedical enterprise houses three entities: The Biological Sciences Division (BSD), the University of Chicago Medicine (UCM), and the Pritzker School of Medicine. Collectively called UCM, we are one of the nation's leading academic medical institutions and have been at the forefront of discovery, education, and clinical care since 1927. Located 20 minutes south of downtown Chicago, our Hyde Park main campus provides a single environment for learning, world-renowned basic science and clinical research, and outstanding clinical care.

The BSD is the largest academic unit within the University. The BSD is comprised of faculty from ten basic science departments, 13 clinical departments, and several Centers and Institutes. The approximately 1,300 faculty and 3,000 staff members working in the BSD collaborate across the organization to achieve our Mission, Vision, and Values (MVV):

MISSION: As part of the University of Chicago, we pursue globally impactful solutions to seemingly unsolvable challenges. Through our rigorous research, innovative education, and comprehensive care and healing, we collaborate on life-changing advancements that create meaningful results for our community and the world, including a greater, more equitable future for all.

VISION: Together, we elevate the human experience with knowledge and health care.

VALUES:
• Commit to Excellence: We contribute our exceptional talents to all we do and empower the same spirit of excellence in others.
• Embrace Curiosity: We stay open to new ideas, champion diverse perspectives, and drive a culture of thoughtful risk-taking to deliver transformative innovation.
• Embody Equity: We identify systemic issues and then foster change to drive a more equitable environment inclusive of diverse people, ideas, and fields of science.
• Grow Together: We meaningfully collaborate with one another to create something bigger than we could ever achieve alone.
• Make a Difference: We lead with heart and compassion in all our interactions. We create positive change in our areas of influence, whether expanding scientific inquiry, developing the next generation of leaders, or healing our community.
• Take Ownership: We accomplish what we say we will and hold ourselves and one another accountable for our actions.

The MVV serves as our True North, charting our strategic plan for the next ten years and beyond. It is an exciting time to be a part of the University of Chicago and the BSD. Our team is helping shape the future for our learners, staff, faculty, patients, and community.

The Center for Research Informatics (CRI) is an organization within the Biological Sciences Division (BSD) that provides informatics resources and services to BSD faculty. Four main services comprise the CRI's operations: applications development, bioinformatics, IT infrastructure and scientific computing, and clinical research data warehousing/business intelligence. Through these service lines, the CRI enables research of the highest scientific merit and advances the state of the art of clinical and translational informatics. The CRI recruits exceptional candidates looking to leverage state-of-the-art technologies to deliver innovative and exciting solutions biomedical researchers.

Job Summary

The incumbent will be responsible for supporting data requests for the Clinical Research Data Warehouse (CRDW), as well as for ETL Architecture and Development. The incumbent will spend 80% of his/her/their time supporting physician-scientists. This includes understanding and implementing data extractions, transformations, and loads, writing SQL code to incorporate new data sources into data warehouses and affiliated data marts, both local and distributed and working with existing teams to further development according to existing standards and conventions. There is also a need for data management and biostatistical expertise. This includes data source acquisition and positioning, providing ongoing feedback and support to expand available data sources while improving the team’s understanding of existing data sources, transforming and loading data into data models and platforms, both standardized and unstandardized, and creating and maintaining a growing body of documentation. Incumbent will perform data analysis using coding languages to answer research questions under several University faculty members' direction and support quality improvement initiatives and external reporting. Finally, this position involves translating technical specifications into SQL code, generating data deliverables, and conducting code reviews. An ideal candidate will be able to quickly master medical terminology related to filling data requests, communicate effectively with a busin