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 involves supporting the Clinical Research Data Warehouse (CRDW) by managing data requests and developing ETL architecture. The role requires expertise in data extraction, transformation, and loading processes, as well as proficiency in SQL and data management. The incumbent will work closely with faculty members to perform data analysis, ensure data quality, and generate insightful visualizations to support research initiatives.

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.

Requirements

• Proficiency in SQL for data extraction and transformation.
• Experience with ETL tools, particularly SSIS.
• Strong analytical skills to interpret complex data sets.
• Ability to write and optimize SQL queries for data deliverables.
• Familiarity with data visualization tools such as Tableau.
• Experience with programming languages such as R and Python for data analysis.
• Strong communication skills to interact with faculty and stakeholders.

Nice-to-haves

• Experience in a healthcare or clinical research environment.
• Familiarity with data governance principles.
• Knowledge of data quality assurance processes.

Benefits

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