Healthcare Data Programmer Analyst​

University of Chicago

University of Chicago

This job is no longer accepting applications

See open jobs at University of Chicago.
Software Engineering, IT
Chicago, IL, USA
Posted on Thursday, March 23, 2023


BSD CRI - Data Warehouse

About the Department

​​The Center for Research Informatics (CRI) is an organization within the Biological Sciences Division (BSD) that provides informatics resources and services to BSD faculty. Four main services comprise the CRI's operations: applications development, bioinformatics, IT infrastructure and scientific computing, and clinical research data warehousing/business intelligence. Through these service lines, the CRI enables research of the highest scientific merit and advances the state of the art of clinical and translational informatics. The CRI recruits exceptional candidates looking to leverage state-of-the-art technologies to deliver innovative and exciting solutions biomedical researchers.

​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

​​Clinical Research Data Warehouse (CRDW)

​Incumbent will be responsible for supporting data requests for the CRDW, as well as for ETL Architecture and Development of our common data model infrastructure. Incumbent will spend 80% of his/her/their time supporting these efforts. 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 may 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, 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.

​Software Development

​Incumbent will spend 20% of their time working cross-functionally with the Software Development team optimizing and modernizing custom programs, integrating and migrating data, reporting from various information systems, creating new database schemas, evaluating and implementing open-source software, and giving demonstrations of current projects. Incumbent will be responsible for our installation of REDCap, working closely with the REDCap analyst team, to improve and expand functionality, maintain upgrades, and facilitate 21CFR compliance. The software development team works primarily with C#, ASP.NET, .NET Core, MSSQL Server, MVC, and Web API; however, there is work that may require the use of other programming languages such as Python and Django.​


Clinical Research Data Warehouse (CRDW)

  • 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 Sr. 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.

Software Development

  • Design and development Work as part of the team on existing and new projects, fixing bugs, adding new features.

  • Cross-functional engagement - Work with other functional partners to contribute to product strategy.

  • Support - In collaboration with the CRI front line support, professional services, and other members of the team.

  • ​Provide technical guidance on resolving customer support issues, as needed.


  • ​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


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.



Preferred Qualifications


  • Understanding of various common data models (OMOP, PCORnet).

  • Experience with ETL tools.

  • Experience working with application development and/or agile.

  • Experience working within regulatory and security requirements for use of electronic personal health information (HIPAA).

  • Experience with SAML-based authentication.

  • Experience creating custom software.

  • Experience with C#, ASP.NET, MSSQL Server, and .NET MVC.

  • Experience with Web technologies (REST, HTML, CSS, Javascript, AJAX) and frameworks (React, Angular, Bootstrap, Blazor) and ORM (EF, NHibernate).

  • Experience in backend database (relational, NoSQL) development and optimization.

  • Experience with HTTP servers (IIS, Apache).

  • Experience with a distributed version control system (Subversion, Git).

  • Knowledge of modern JavaScript tools such as Webpack, Babel, ESLint, Gulp, NPM, Bower, Browserify, Grunt and similar technologies.

  • Experience with unit and integration testing tools.

  • Experience in other analytic platforms including R, Stata, Python, SAS.

  • Experience with business intelligence and visualization tools such as Tableau, Power BI, etc.

  • Expert in SQL and Excel.

  • Knowledge of healthcare data including ICD-9, ICD-10, and CPT.

Preferred Competencies

  • High level of problem solving and decision-making skills.

  • 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 investigating data issues and working with a cross-functional team for problem resolution.

  • Energized by working through complex problems.

  • Intellectual curiosity.

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

FLSA Status


Pay Frequency


Scheduled Weekly Hours


Benefits Eligible


Drug Test Required


Health Screen Required


Motor Vehicle Record Inquiry Required


Posting Statement

Employees must comply with the University’s COVID-19 vaccination requirements. More information about the requirements can be found on the University of Chicago Vaccination GoForward.

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 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.

This job is no longer accepting applications

See open jobs at University of Chicago.