Location: Chicago, IL Job Description: Understands business requirements and needs of business owners and assist with defining data elements and data structure that the team should leverage to enable analytics capabilities.
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, 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.
Proactively identify issues and opportunities to improve data systems and related policies as an aspect of data governance.
Manage and direct junior ETL developers.
Leads in the development of new systems, features, and tools. Solves complex problems and identifies opportunities for technical improvement and performance optimization. Reviews and tests code to ensure appropriate standards are met.
Utilizes in-depth technical knowledge of existing and emerging technologies, including public cloud offerings from Amazon Web Services, Microsoft Azure, and Google Cloud.
Acts as a technical consultant and resource for faculty research, teaching, and/or administrative projects.
Leads or coordinates teams or projects for activities relating to software support and/or development.
Performs other related work as needed.
Preferred Qualifications Education: Bachelor's or Master's.
Experience: Understanding of various common data models (OMOP, PCORnet).
7 years experience with ETL tools.
7 years experience with SQL, python, Java, Tableau.
Understanding of research methodology and healthcare terminology.
Licenses and Certifications: Clarity.
Preferred Competencies 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.
Working Conditions Office environment.
Application Documents Resume (required)
Cover Letter (preferred)
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 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.
About University of Chicago (UC)
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.
Connections working at University of Chicago (UC)
