University of Chicago - Chicago, IL
posted 6 months ago
The ETL Developer position at the University of Chicago is a critical role within the Center for Research Informatics (CRI), which operates under the Biological Sciences Division (BSD). The CRI is dedicated to providing informatics resources and services that align with the mission of the academic medical center. The incumbent will be responsible for fulfilling data requests for the Clinical Research Data Warehouse (CRDW) and supporting ETL architecture and development. This involves understanding and implementing data extractions, transformations, and loads, as well as writing SQL code to incorporate new data sources into data warehouses and affiliated data marts, both local and distributed. The role requires collaboration with existing teams to further development according to established standards and conventions. In addition to ETL responsibilities, the position demands data management expertise, including data source acquisition and positioning. The incumbent will provide ongoing feedback and support to expand available data sources while enhancing the team's understanding of existing data sources. Responsibilities also include transforming and loading data into both standardized and unstandardized data models and platforms, as well as creating and maintaining comprehensive documentation. The ETL Developer will perform data analysis to answer research questions under the guidance of University faculty members and support quality improvement initiatives and external reporting. The role also involves translating technical specifications into SQL code, generating data deliverables, and conducting code reviews. An ideal candidate will quickly master medical terminology related to data requests, communicate effectively with business analysts and clients, and write optimized SQL queries for data deliverables. Proficiency in R and Python for analysis, as well as Tableau for data visualization, is also essential. Prior to delivering data, the incumbent will assist with data quality checks to ensure that each deliverable meets the original request specifications and maintains the highest quality standards. This position is situated within a federal recharge center, emphasizing the importance of accuracy and efficiency in data management.