Data Warehouse Developer I - University of Rochester : Job Details

As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better. Embedded in that ideal are the values we share: equity, leadership, integrity, openness, respect, and accountability. Together, we will set the highest standards for how we treat each other to ensure our community is welcoming to all and is a place where all can thrive.Job Location (Full Address):220 Hutchison Rd, Rochester, New York, United States of America, 14620Opening:Worker Subtype:RegularTime Type:Part timeScheduled Weekly Hours:20Department:600223 SON Staff/Research ProgramsWork Shift:Range:UR URG 111Compensation Range:$63,815.00 - $95,723.00The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job's compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.Responsibilities:GENERAL PURPOSE:Responsible for the design, development, implementation, and support of various components for the enterprise data warehouse and associated data sources. Provides support for reporting projects and works on projects as assigned. Interacts with multiple disciplines to ensure data services needs are met. Supports enterprise data systems by assisting with building a foundation for integrated analytical applications/extracts in SQL tools (SSIS/SSRS/T-SQL), Virtual and Physical data warehousing, Epic Systems and reporting BI tools. Completes service requests intake documentation and process documentation. Assists with projects and analysis and/or programming addressing challenging tasks may be assigned as needed.Schedule8 AM-4:30 PMResponsibilitiesGENERAL PURPOSE:SQL Developer to support a cutting-edge research study focused on AI-Driven Learning for Event Recognition and Treatment (ALERT) using real-time patient monitoring data. The SQL Developer will play a critical role in managing and optimizing databases that store large volumes of real-time clinical data, facilitating the development and deployment of AI models aimed at improving 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)QUALIFICATIONS: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 Or equivalent combination of education and experience required.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.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.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.Excellent problem-solving skills and attention to detail required.The University of Rochester is committed to fostering, cultivating, and preserving a culture of equity, diversity, and inclusion to advance the University┐s mission to Learn, Discover, Heal, Create ┐ and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion/creed, sex, sexual orientation, citizenship status, or any other status protected by law. This commitment extends to the administration of our policies, admissions, employment, access, and recruitment of candidates from underrepresented populations, veterans, and persons with disabilities consistent with these values and government contractor Affirmative Action obligations.EOE Minorities / Females / Protected Veterans / Disabled:The University of Rochester is committed to fostering, cultivating, and preserving a culture of equity, diversity, and inclusion to advance the University's mission to Learn, Discover, Heal, Create – and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion/creed, sex, sexual orientation, citizenship status, or any other status protected by law. This commitment extends to the administration of our policies, admissions, employment, access, and recruitment of candidates from underrepresented populations, veterans, and persons with disabilities consistent with these values and government contractor Affirmative Action obligations.Notice: If you are a Current Employee, please log into myURHR to search for and apply to jobs using the Jobs Hub. Your application, if submitted using this portal, cannot be moved forward.Learn. Discover. Heal. Create.Located in western New York, Rochester is our namesake and our home. One of the world's leading research universities, Rochester has a long tradition of breaking boundaries—always pushing and questioning, learning and unlearning. We transform ideas into enterprises that create value and make the world ever better.If you're looking for a career in higher education or health care, the University of Rochester may offer the perfect opportunity for your background and goalsAt the University of Rochester, we commit to diversity, equity, and inclusion and united by a strong commitment to be ever better—Meliora. It is an ideal that informs our shared mission to ensure all members of our community feel safe, respected, included, and valued.