Senior Healthcare Data and Analytics Specialist
University of Chicago
Department
BSD CRI - Data Warehouse
About the Department
We are committed to increasing diversity, equity, and inclusion for the benefit of our team members, our institution, our clients, and our community. We will accomplish this by incorporating our values into hiring practices, retention, and culture.
Job Summary
An ideal candidate will be able to quickly master medical terminology related to filling data requests, communicate effectively with business analysts, cross-functional technical teams, and academic clients, and write SQL queries that optimize the organization of data deliverables, perform analyses using R and Python, and generate visualizations using Tableau. 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. Incumbent must adhere to all institutional data governance policies and may be partially or wholly supported by partnerships with Departments, Sections, and other Research Units. Positions with contractual grant funding or other departmental funding support may be required to work in person up to 4 days per week. Position operates within a federal recharge center.
This at-will position is wholly or partially funded by contractual grant funding which is renewed under provisions set by the grantor of the contract. Employment will be contingent upon the continued receipt of these grant funds and satisfactory job performance.
Responsibilities
- Gathers and analyzes healthcare and other related data to identify and interpret trends in support of data requests, business cases, and proposed projects.
- Designs, constructs, tests, and maintains data warehouse and related functionality including extraction and transformation of data using SSIS.
- Designs, develops, and tests business intelligence outputs, including visualization, to ensure useful and insightful information using software including R, Tableau, and/or Excel to support research and quality improvement initiatives.
- Tests and validates data with the purpose of understanding and making conclusions to support decision-making processes.
- Manages a variety of information systems and data files, including large and complex files, analyzing file structure, using and creating file layouts, and transforming raw data into finished products.
- Monitors for timely and accurate completion of work.
- Participates in strategic initiatives to enhance data management and reporting to support research and quality improvement initiatives.
- Collaborates closely with a cross-functional team of data scientists, project managers, and developers to ensure high-quality data delivery to faculty.
- Collaborates with faculty, staff, and other research teams.
- Performs duties in a matrixed management environment.
- Proactively identifies issues and opportunities to improve data systems and related policies as an aspect of data governance.
- Communicates effectively with management, support staff, and faculty partners.
- Adheres to all institutional data governance policies.
- Develops Business Intelligence (BI) and other analytical applications. Works to achieve an integrated reporting and analysis environment, effectively leveraging analytical systems and tools.
- Guides requirements analysis, translating requirements into a scope document and developing reporting deliverables based on the design.
- Works with users to ensure deliverables are meeting or exceeding expectations. Provides support and communicates issues to users as defined by IT standards.
- Performs other related work as needed.
Minimum Qualifications
Education:
Minimum requirements include a college or university degree in related field.
Work Experience:
Certifications:
---
Preferred Qualifications
Education:
- Healthcare or clinical/medical degree.
Experience:
- 5 years of experience with ETL tools.
- 5 years of experience with SQL, Python, Java, Tableau.
- Translating between clinical and IT/informatics domains.
- Background with various common data models (OMOP, PCORnet).
Licenses and Certifications:
- Clarity certification.
Technical Skills or Knowledge:
- Understanding of various common data models (OMOP, PCORnet).
- Understanding of research methodology and healthcare terminology.
- 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 tables.
- Familiarity of other analytic platforms including R, Stata, Python, SAS.
- Familiarity with business intelligence and visualization tools such as Tableau, Power BI, etc.
Preferred Competencies
- High level of problem-solving and decision-making skills.
- 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.
- Investigating data issues and working with a cross-functional team for problem resolution.
- Strict understanding of and adherence to data governance policies.
Working Conditions
- Hybrid, with 2 days on-site.
Application Documents
- Resume/CV (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
Role Impact
Scheduled Weekly Hours
Drug Test Required
Health Screen Required
Motor Vehicle Record Inquiry Required
Pay Rate Type
FLSA Status
Pay Range
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
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 equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender, gender identity, or expression, national or ethnic origin, shared ancestry, 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.
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.
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.