Database Analyst/ETL Developer

The University of Chicago; Chicago (IL); On-site; USD 80,000 - 120,000; Full time

Job summary

An established academic medical institution is seeking a diligent data analyst to support its Clinical Research Data Warehouse. This role involves managing data requests, developing ETL processes, and performing data analysis using SQL, R, and Python. The ideal candidate will thrive in a collaborative environment, working closely with faculty and cross-functional teams to enhance data management and reporting initiatives. Join a forward-thinking organization committed to impactful research and innovative solutions in healthcare. This position offers a unique opportunity to contribute to meaningful advancements in clinical research and data informatics.

Benefits

Health benefits

Retirement plans

Paid time off

Flexible work hours

Qualifications

• 2-5 years of experience in data management and analysis.
• Proficient in SQL and familiar with ETL tools.

Responsibilities

• Analyze healthcare data to support research and quality improvement.
• Design and maintain data warehouse functionality and BI outputs.

Skills

SQL

R

Python

Tableau

Data Management

ETL Architecture

Data Analysis

Statistical Analysis

Education

Bachelor's Degree in related field

Master's Degree in relevant field

Tools

SSIS

SAS

STATA

Power BI

Excel

Job description

Department

BSD CRI - Data Warehouse

About the Department

The University of Chicago biomedical enterprise houses three entities: The Biological Sciences Division (BSD), the University of Chicago Medicine (UCM), and the Pritzker School of Medicine. Collectively called UCM, we are one of the nation's leading academic medical institutions and have been at the forefront of discovery, education, and clinical care since 1927. Located 20 minutes south of downtown Chicago, our Hyde Park main campus provides a single environment for learning, world-renowned basic science and clinical research, and outstanding clinical care.

The BSD is the largest academic unit within the University. The BSD is comprised of faculty from ten basic science departments, 13 clinical departments, and several Centers and Institutes. The approximately 1,300 faculty and 3,000 staff members working in the BSD collaborate across the organization to achieve our Mission, Vision, and Values (MVV):

MISSION: As part of the University of Chicago, we pursue globally impactful solutions to seemingly unsolvable challenges. Through our rigorous research, innovative education, and comprehensive care and healing, we collaborate on life-changing advancements that create meaningful results for our community and the world, including a greater, more equitable future for all.

VISION: Together, we elevate the human experience with knowledge and health care.

VALUES:

• Commit to Excellence: We contribute our exceptional talents to all we do and empower the same spirit of excellence in others.
• Embrace Curiosity: We stay open to new ideas, champion diverse perspectives, and drive a culture of thoughtful risk-taking to deliver transformative innovation.
• Embody Equity: We identify systemic issues and then foster change to drive a more equitable environment inclusive of diverse people, ideas, and fields of science.
• Grow Together: We meaningfully collaborate with one another to create something bigger than we could ever achieve alone.
• Make a Difference: We lead with heart and compassion in all our interactions. We create positive change in our areas of influence, whether expanding scientific inquiry, developing the next generation of leaders, or healing our community.
• Take Ownership: We accomplish what we say we will and hold ourselves and one another accountable for our actions.

The MVV serves as our True North, charting our strategic plan for the next ten years and beyond. It is an exciting time to be a part of the University of Chicago and the BSD. Our team is helping shape the future for our learners, staff, faculty, patients, and community.

The Center for Research Informatics (CRI) is an organization within the Biological Sciences Division (BSD) that provides informatics resources and services to University faculty in alignment with the mission, vision, and values of the academic medical center. Four main services comprise the CRI's operations: application development, bioinformatics, research storage and computing, and clinical research data warehousing and business intelligence. Through these service lines, the CRI enables clinical and translational research of the highest scientific merit and advances the state of the art of clinical research informatics. The CRI recruits intellectually curious candidates looking to deliver innovative and exciting solutions for biomedical researchers.

Job Summary

Incumbent will be responsible for filling data requests for the Clinical Research Data Warehouse (CRDW), as well as for supporting ETL Architecture and Development. This includes understanding and implementing data extractions, transformations, and loads, writing SQL code to incorporate new data sources into data warehouses and affiliated data marts, both local and distributed, and working with existing teams to further development according to existing standards and conventions. There is also a need for data management expertise. This includes data source acquisition and positioning, providing ongoing feedback and support to expand available data sources while improving the team’s understanding of existing data sources, transforming and loading data into data models and platforms, both standardized and unstandardized, and creating and maintaining a growing body of documentation. Incumbent will perform data analysis to answer research questions under the direction of several University faculty members and also support quality improvement initiatives and external reporting. Finally, this position involves translating technical specifications into SQL code, generating data deliverables, and conducting code review. An ideal candidate will be able to quickly master medical terminology related to filling data requests, communicate effectively with a business analyst and clients, write SQL queries which optimize the organization of data deliverables, perform analyses using R and Python, generate visualizations using Tableau, and adhere to all administrative policies and procedures. Prior to delivery of data, the incumbent will assist with data quality checks, making sure that each deliverable matches the original request specifications and that the data is of the highest quality. Position resides in a federal recharge center.

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.
• Advanced statistical analysis, including programs R, SAS, STATA.
• Participates in the development of queries and retrieval systems.
• Monitors the database storage system used to securely store and organize datasets.
• Proactively identify issues and opportunities to improve data systems and related policies as an aspect of data governance.
• Investigates, analyzes and resolves day-to-day technical problems using standard procedures.
• Works with stakeholders to gather and analyze requirements for developmental programs. Receives a moderate level of guidance to design applications to meet University and business requirements.
• Performs code testing on components and works to ensure that appropriate implementation standards are met. Evaluates design alternatives for development cost and solutions using various methods.
• Supports and maintains existing applications. Works with web developers and responds to requests from users.
• Performs other related work as needed.

Minimum Qualifications

Education: Minimum requirements include a college or university degree in related field.

Work Experience: Minimum requirements include knowledge and skills developed through 2-5 years of work experience in a related job discipline.

Certifications:

---

Preferred Qualifications

Education:

• Master’s Degree in a relevant field.

Experience:

• Experience with ETL tools.
• Experience working with research methodologies.
• Experience in organizing, analyzing, and disseminating significant amounts of information with attention to detail and accuracy.
• Experience in data management, including extraction, transformation, loading, validation/testing, and structuring of data.

Technical Skills or Knowledge:

• Various common data models (OMOP, PCORnet).
• Healthcare data including ICD-9, ICD-10, and CPT.
• SQL and Excel.
• Analytic platforms including R, Stata, Python, SAS.
• Business intelligence and visualization tools such as Tableau, Power BI, etc.

Licenses and Certifications:

• Clarity.

Preferred Competencies

• Understanding of various common data models (OMOP, PCORnet).
• Knowledge of hospitals and healthcare.
• Knowledge of research processes.
• High level of problem solving and decision-making skills.
• Knowledge of healthcare data including ICD-9, ICD-10, and CPT.
• Expert in SQL and Excel.
• Proficiency in relational databases with experience designing transformations, mappings, and working with reference table.
• Ability to translate technical information to non-technical audiences.
• Critical thinking and multi-tasking skills with the ability to manage multiple projects.
• Time management skills.
• Proficiency in creating technical specifications, business cases, and other development-related documentation.
• Experience in other analytic platforms including R, Stata, Python, SAS.
• Experience with business intelligence and visualization tools such as Tableau, Power BI, etc.
• Experience investigating data issues and working with a cross-functional team for problem resolution.
• Energized by working through complex problems.
• Intellectual curiosity.
• Ability to use standard and custom in-house reporting tools.
• Ability to use analytical and quantitative skills and diagnostic techniques to resolve problems.
• Ability to manage complex technical details.
• Ability to work in a collaborative team environment.
• Ability to handle multiple tasks and assignments.
• Confidentiality related to sensitive University matters such as, strategic initiatives, trade secrets, quiet periods, and scientific discoveries yet to be put in the public domain.

Working Conditions

• Office, hybrid.

Application Documents

• Resume (required)
• Cover Letter (preferred)

When applying, the document(s) MUST be uploaded via the My Experience page, in the section titled Application Documents of the application.

Job Family

Information Technology

Role Impact

Individual Contributor

Scheduled Weekly Hours

40

Drug Test Required

No

Health Screen Required

No

Motor Vehicle Record Inquiry Required

No

Pay Rate Type

Salary

FLSA Status

Exempt

Pay Range

$80,000.00 - $120,000.00

The included pay rate or range represents the University’s good faith estimate of the possible compensation offer for this role at the time of posting.

Benefits Eligible

Yes

The University of Chicago offers a wide range of benefits programs and resources for eligible employees, including health, retirement, and paid time off. Information about the benefit offerings can be found in the Benefits Guidebook.

Posting Statement

The University of Chicago is an Affirmative Action/Equal Opportunity/Disabled/Veterans and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender, gender identity, national or ethnic origin, age, status as an individual with a disability, military or 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 Applicant Inquiry Form.

We seek a diverse pool of applicants who wish to join an academic community that places the highest value on rigorous inquiry and encourages a diversity of perspectives, experiences, groups of individuals, and ideas to inform and stimulate intellectual challenge, engagement, and exchange.

All offers of employment are contingent upon a background check that includes a review of conviction history. A conviction does not automatically preclude University employment. Rather, the University considers conviction information on a case-by-case basis and assesses the nature of the offense, the circumstances surrounding it, the proximity in time of the conviction, and its relevance to the position.

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: http://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.