ETL Developer - JR26283-3800

University of Chicago - Chicago, IL

Full-time - Entry Level

Chicago, IL

Educational Services

About the position

The ETL Developer position at the University of Chicago's Center for Research Informatics (CRI) involves managing data requests for the Clinical Research Data Warehouse (CRDW) and supporting ETL architecture and development. The role requires expertise in data extraction, transformation, and loading, as well as writing SQL code to integrate new data sources. The incumbent will also perform data analysis, support quality improvement initiatives, and ensure high-quality data deliverables while adhering to administrative policies.

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.
• 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.
• Participate in strategic initiatives to enhance data management and reporting to support research and quality improvement initiatives.
• Collaborate closely with a cross-functional team of Data Scientists, Project Managers, and Developers to ensure high-quality data delivery to faculty.
• Proactively identify issues and opportunities to improve data systems and related policies as an aspect of data governance.
• Investigate, analyze and resolve day-to-day technical problems using standard procedures.
• Work with stakeholders to gather and analyze requirements for developmental programs.
• Perform code testing on components and work to ensure that appropriate implementation standards are met.
• Support and maintain existing applications. Work with web developers and respond to requests from users.
• Perform other related work as needed.

Requirements

• Experience with SQL and data warehousing concepts.
• Proficiency in ETL tools, particularly SSIS.
• Knowledge of data analysis and visualization tools such as R, Python, and Tableau.
• Ability to communicate effectively with stakeholders and team members.
• Experience in managing large and complex data files.

Nice-to-haves

• Familiarity with healthcare data and medical terminology.
• Experience in quality improvement initiatives.
• Knowledge of data governance practices.

Benefits

• Health insurance coverage
• Dental insurance coverage
• Retirement savings plan (401k)
• Paid holidays
• Flexible scheduling
• Professional development opportunities