We seek a Database ETL Developer for the new Duchossois Family Institute (DFI) at the University of Chicago. The DFI seeks to accelerate research and interventions based on how the human immune system, microbiome and genetics interact to maintain health. A large focus of the DFI is on advancing scientific discovery through building a vibrant research and innovation community as part of a DFI Research Incubator. The Database ETL Developer will create and maintain an integrated knowledge base of biomedical data. Working within the informatics team, the candidate will be responsible for developing and maintaining queries and stored procedures, developing reports, troubleshooting and fixing data related issues, and assisting with data quality initiatives. The role will include integrating data from multiple sources to create a scalable database that supports Web-based querying and access. The role will also include ETL development, monitoring and maintenance of processes.
This at-will position is wholly or partially funded by extramural funds (e.g., grant, gift, endowment) which are renewed under provisions set by the grantor. Employment will be contingent upon the continued receipt of these extramural funds and satisfactory job performance. If this position is eliminated due to the discontinuation of extramural funding, you will be given a minimum of one pay period's written notice (if exempt: 30 days, if non-exempt: 2 weeks), or pay in-lieu of notice.
Design, create, modify and remove relational database objects (tables, views, indexes, keys, stored procedures, functions, etc.) to support development projects.
Design, build, and maintain extract-transformation-load (ETL) processes.
Work with Application Development Teams, Project Management, QA, and Security to support a institute wide research data management platform.
Assist other developers with MYSQL/PostgreSQL questions as needed.
Support application testing efforts from a database perspective.
Ability to profile and improve queries.
Data expert for migrating data from existing applications and schema.
Collaborate with and support biomedical scientists.
Commitment to providing a high level of service and working in a team environment required. High degree of professionalism required.
Strong project management and prioritization skills.
Exceptional attention to detail, accuracy and thoroughness.
Self-motivation and ability to work independently and on deadline required.
Strong problem solving skills required.
Ability to win the trust and confidence of faculty and administrators required.
Education, Experience and Certifications:
Bachelor's degree in computer science or another relevant computer related field required.
2-3 years of experience as a database developer.
Strong knowledge of relational database systems and SQL (MYSQL preferred).
Understanding of data gathering, validation, cleansing, transforming, and modeling/diagramming techniques.
Ability to efficiently write database code without compromising data quality, privacy or security.
Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels.
Extract, transform, and load legacy data. Develop, test, integrate, and deploy ETL routines using ETL tools and external programming/scripting languages as necessary.
Strong programming skills to code, script and automate using Python.
Excellent collaboration and teamwork skills.
2-3 years of experience working with biomedical/clinical/PHI data.
Experience in data wrangling/munging and statistical analysis.
Experience with big data architectures is a plus.
Biomedical/Clinical/PHI data experience is a plus.
Experience working with research data and clinical development support.
NOTE: When applying, all required documents MUST be uploaded under the Resume/CV section of the application
The University of Chicago is an Affirmative Action/Equal Opportunity/Disabled/Veterans Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national or ethnic origin, age, status as an individual with a disability, protected veteran status, genetic information, or other protected classes under the law. For additional information please see the University's Notice of Nondiscrimination.
Staff Job seekers in need of a reasonable accommodation to complete the application process should call 773-702-5800 or submit a request via the Applicant Inquiry Form.
The University of Chicago's Annual Security & Fire Safety Report (Report) provides information about University offices and programs that provide safety support, crime and fire statistics, emergency response and communications plans, and other policies and information. The Report can be accessed online at: securityreport.uchicago.edu. Paper copies of the Report are available, upon request, from the University of Chicago Police Department, 850 E. 61st Street, Chicago, IL 60637.
Internal Number: JR04179
About University of Chicago
One of the world's premier academic and research institutions, the University of Chicago has driven new ways of thinking since our 1890 founding. Today, UChicago is an intellectual destination that draws inspired scholars to our Hyde Park and international campuses, keeping UChicago at the nexus of ideas that challenge and change the world.