The Data Warehousing Research Manager will manage the clinical research data warehouse for the Cook County Health & Hospitals System (CCHHS). Responsible for database and data mart design, managing clinical research data extraction, transformation, and loading. Populates and monitors several Microsoft SQL Servers to ensure the confidentiality, availability, and integrity of data stored while delivering reports, datasets, and data marts to the CCHHS research community. Works collaboratively with the Collaborative Research Unit (CRU) team and Business Intelligence. Shares all work products with team members either through an open source platform, or by revealing the source code and processes to team members.
· Responsible for the architecture, design and development of a clinical research data warehouse – managing Extract Transform Load (ETL)/Data Warehousing (DW)/Business Intelligence (BI) administration.
Creates secure data marts (CAPriCORN, Oncology, HIV) extracted from different hospital's electronic medical records (EMR), BI's Educational Data Warehouse (EDW), transformed to meet reporting needs, and loaded into CCHHS' SQL servers.
Executes data management activities including but not limited to, coordination of collection, storage, processing, analysis, and dissemination of data.
Implements and monitors data quality control measures (backup systems, disaster recovery, and Quality Assurance (QA) mechanisms) that guarantee the integrity, availability, reliability, and accuracy of the data.
Builds advanced SQL queries to extract data-sets from a clinical data warehouse to support the hospital's research activities.
Generates reports using SQL Server Reporting Services (SSRS).
Plans and conducts structured testing of database designs to confirm functionality and performance.
Automates the maintenance of data with T-SQL, stored procedures, jobs, scripts, and SQL Server Integration Services (SSIS) packages.
Maximizes the performance of the databases by using proper techniques of slicing and indexing.
Participates in project investigator's meetings and makes recommendations on quality management issues and concerns.
Maintains the data information systems on a daily basis to include operation of data servers, inspection and maintenance of network hardware and software. Trouble-shooting network, hardware, and software problems, data transfer activities and appropriate back up of data; and installs, tests and implements database management systems and upgrades.
Develops, implements and maintains complex data models and logical database designs.
Documents the architecture and maintains data dictionaries for data marts.
Parses and processes Health Level Seven International (HL7) messages.
Performs other duties as assigned.
Bachelor's Degree from an accredited college or university in computer science or related field (official transcripts required at time of interview)
Five (5) years of experience designing and building databases with three (3) years of experience in a healthcare environment
Proficiency with the following:
Microsoft SQL Server Administration
Automation of SQL server database jobs (SSRS & SSIS)
One (1) year of experience mapping the following vocabularies: SNOMED, LOINC, NDC, RxNORM
One (1) year of experience working with PCORNET, CRN VDW, OMOP Common Data Models
Prior experience as a technical leader on multicenter health care data integration projects
Current experience with Script Programming
Knowledge, Skills, Abilities and Other Characteristics
Willingness to share ideas and code
Strong interpersonal skills
· Ability to work with a diverse group of users, including clinicians, researchers and administrators
When applying for employment with the Cook County Health & Hospitals System, preference is given to honorably discharged Veterans who have served in the Armed Forces of the United States for not less than 6 months of continuous service
To take advantage of this preference a Veteran must :
Meet the minimum qualifications for the position.
Identify self as a Veteran on the employment application by answering yes to the question by answering yes to the question,
The Cook County Health & Hospitals System’s mission is to deliver integrated health services with dignity and respect regardless of a patient’s ability to pay; foster partnerships with other health providers and communities to enhance the health of the public; and advocate for policies that promote the physical, mental and social wellbeing of the people of Cook County. CCHHS is comprised of two hospitals, John H. Stroger, Jr. Hospital and Provident Hospital, a robust network of more than a dozen community health centers, the Ruth M. Rothstein CORE Center, the Community Triage Center, the Cook County Department of Public Health, Cermak Health Services, which provides health care to individuals at the Cook County Jail and the Juvenile Temporary Detention Center, and CountyCare, a Medicaid managed care health plan.The system cares for more than 300,000 patients each year and its physicians are experts in their fields, committed to providing their patients with comprehensive, compassionate and cutting-edge care. Today, CCHHS is transforming the provision of health care in Cook County by promoting community-based primary and preventive care, growing an innovative, collaborative health plan and enhancing the patient experience.