Healthcare Data Analyst

University of Chicago • Chicago, IL

324d • $80,000 - $120,000

About The Position

The incumbent will be responsible for supporting data requests for the Clinical Research Data Warehouse (CRDW), as well as for ETL Architecture and Development. The incumbent will spend 80% of his/her/their time supporting physician-scientists. 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 and biostatistical 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 using coding languages to answer research questions under several University faculty members' direction and support quality improvement initiatives and external reporting. Finally, this position involves translating technical specifications into SQL code, generating data deliverables, and conducting code reviews. 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 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. The incumbent will perform statistical analyses as needed and develop reports for clinician-scientists as needed. The position operates within a federal recharge center.

Requirements

• Minimum requirements include a college or university degree in related field.
• Minimum requirements include knowledge and skills developed through 2-5 years of work experience in a related job discipline.

Nice To Haves

• Master's degree in biostatistics, computer science, or other related field OR requisite job experience in statistical analysis.
• Experience with ETL tools.
• Experience working with application development and/or agile teams.
• 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.
• Experience in other analytic platforms including R, Stata, Python, SAS, SQL.
• Experience with business intelligence and visualization tools such as Tableau, Power BI, etc.

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.
• Design and perform statistical analyses.
• 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.
• 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.

Benefits

• Health insurance
• Retirement plans
• Paid time off

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: Bachelor's degree