Data Warehouse Developer I

$63,815 - $95,723/Yr

University of Rochester - Rochester, NY

Part-time - Entry Level

Rochester, NY

Educational Services

About the position

The Data Warehouse Developer I position at the University of Rochester is a part-time role focused on supporting a research study that utilizes AI-driven learning for event recognition and treatment. The developer will manage and optimize databases that handle large volumes of real-time clinical data, contributing to the development and deployment of AI models aimed at enhancing patient outcomes.

Responsibilities

• Design, develop, and maintain SQL databases to support data storage, retrieval, and analysis for the research study.
• Write and optimize SQL queries to extract data from real-time patient monitoring systems.
• Collaborate with researchers, data scientists, and AI engineers to ensure efficient integration of data pipelines with AI models.
• Assist in creating and managing data marts or data warehouses as needed for the study.
• Support data extraction for model training, testing, and validation purposes.
• Ensure the accuracy, security, and integrity of large-scale clinical datasets.
• Perform regular database performance tuning and troubleshooting.
• Collaborate with interdisciplinary teams to enhance database design and support research objectives.
• Other duties as assigned (e.g., drafting abstracts and research papers)

Requirements

• Associate's degree in related discipline such as Computer Science, Business, Mathematics, Statistics, Science or Engineering required.
• Bachelor's degree in Biomedical Informatics or a related field preferred.
• 2 years of related experience or equivalent combination of education and experience required.
• Proven experience as an SQL Developer, with expertise in writing complex queries and stored procedures required.
• Strong knowledge of SQL databases (e.g., MySQL, PostgreSQL, or SQL Server) required.
• Excellent problem-solving skills and attention to detail required.

Nice-to-haves

• Background in a healthcare-related field and experience working with clinical data, electronic health records (EHR), or patient monitoring systems preferred.
• Familiarity with AI or machine learning projects, especially in healthcare preferred.
• Experience working with large datasets in a healthcare or research environment preferred.
• Understanding of data normalization, indexing, and performance optimization preferred.
• Familiarity with real-time data systems and their integration with AI models is a plus preferred.
• Ability to work collaboratively in an interdisciplinary research team.

Benefits

• Part-time schedule with flexible hours
• Opportunity to work on cutting-edge research
• Engagement in a collaborative interdisciplinary team environment