The Center for Research Informatics (CRI) at the University of Chicago is seeking to enhance its data warehousing and business intelligence capabilities to support biomedical researchers. This role will involve analyzing healthcare data, developing insights, and improving data management systems to advance research and quality improvement initiatives.
Requirements
- Expert in SQL and Excel.
- Proficiency in relational databases with experience designing transformations, mappings, and working with reference table.
- Experience with ETL tools.
- Understanding of various common data models (OMOP, PCORnet).
- Experience working with application development and/or agile teams.
- Epic Clarity Data Model certification required w/in 6 months of employment.
- Epic Cosmos Super User certification required w/in 6 months of employment.
Responsibilities
- Gather and analyze healthcare and other related data to identify and interpret trends in support of data requests, business cases, and proposed projects.
- Design, construct, test, and maintain data warehouse and related functionality including extraction and transformation of data using SSIS.
- Design, develop, and test business intelligence outputs (including visualization) to ensure useful and insightful information using software including R, Python, Tableau, and/or Excel to support research and quality improvement initiatives.
- Test and validate data with the purpose of understanding and making conclusions to support decision-making processes.
- Design and perform statistical analyses.
- Manage a variety of information systems and data files, including large and complex files: analyzing file structure, using and creating file layouts, transforming raw data into finished products.
- Monitor for timely and accurate completion of select datasets.
Other
- Minimum requirements include a college or university degree in related field.
- Minimum requirements include knowledge and skills developed through 2-5 years of work experience in a related job discipline.
- High level of problem solving and decision-making skills.
- Ability to translate technical information to non-technical audiences.
- Critical thinking and multi-tasking skills with the ability to manage multiple projects.
