The Database Administrator is responsible for supporting the Business Intelligence data warehouse at Cook County Health (CCH). The primary responsibility is to write SQL queries, develop and maintain ETL jobs and support production-level dashboards and reports. Ensures confidentiality, availability, and integrity of data stored while delivering reports, datasets, and data marts to CCH internal and external partners.
This position is exempt from Career Service under the CCH Personnel Rules.
Executes data management activities including but not limited to processing feeds from internal and external vendors, instantiation of the knowledge base required for care management.
Builds advanced SQL queries for supporting ETL and user reports.
Generates reports using SQL Server Reporting Services (SSRS) and Tableau.
Plans and conducts structured testing of database designs to confirm functionality and performance.
Maximizes the performance of the databases by using proper techniques of indexing.
Participates in project meetings and makes recommendations on quality management issues.
Develops, implements and maintains complex data models and logical database designs.
Documents the architecture and maintains data dictionaries for data marts.
Attends and participates in department and/or committee meetings.
Performs other duties and/or projects as assigned.
Bachelor's Degree from an accredited college or university (must provide proof official transcripts at time of interview)
Three (3) years of experience generating SQL queries and/or automating SQL server database jobs (SSRS & SSIS) and/or working with Tableau dashboards/Power BI
One (1) year of experience providing database support for Microsoft SQL Server
Bachelor's Degree in Computer Science or Computer Information Systems from an accredited college or university (must provide official transcripts at time of interview)
Experience with Script Programming
Prior experience working in healthcare
KNOWLEDGE, SKILLS, ABILITIES AND OTHER CHARACTERISTICS
Knowledge of SQL and experience with Microsoft SQL or other relational databases
Excellent interpersonal, verbal and written communication skills necessary to communicate with all levels of staff and a patient population composed of diverse cultures and age groups
Excellent program development, management and leadership skills
Demonstrate analytical and organizational, problem-solving, critical thinking and conflict management/resolution skills
Demonstrate attention to detail, accuracy and precision to support research and presentation skills
Demonstrate analytical and organizational, problem-solving, critical thinking, and conflict resolution skills
Analyze, solve and correct issues in real time
Ability to prioritize, plan, and organize projects and tasks
Ability to multi-task and meet deadlines in a fast paced and stressful environment
Ability to adhere to department policies and standards utilizing best practices
Ability to maintain a professional demeanor and composure when challenged
Able to work with others in team environment
Ability to work independently and on multiple projects
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, "Are you a Military Veteran?"
Attach a copy of their DD 214, DD 215 or NGB 22 (Notice of Separation at time of application filing. Please note: If you have multiple DD214s, 215s, or NGB 22S, Please submit the one with the latest date. Coast Guard must submit a certified copy of the military separation from either the Department of Transportation (Before 9/11) or the Department of Homeland Security (After 9/11). Discharge papers must list an Honorable Discharge Status. Discharge papers not listing an Honorable Discharge Status are not acceptable.
A copy of a valid State ID Card or Driver's License which identifies the holder of the ID as a Veteran, may also be attached to the application at time of filing.
If items are not attached, you will not be eligible for Veteran Preference
VETERANS MUST PROVIDE ORIGINAL APPLICABLE DISCHARGE PAPERS OR APPLICABLE STATE ID CARD OR DRIVER'S LICENSE AT TIME OF INTERVIEW
MUST MEET REQUIRED QUALIFICATIONS AT TIME OF APPLICATION
*Degrees awarded outside the United States with the exception of those awarded in one of the United States' territories and Canada must be credentialed by an approved U.S. credential evaluation service belonging to the National Association of Credential Evaluation Services (NACES) or the Association of International Credential Evaluators (AICE). Original credentialing documents must be presented at time of interview.
*Please note all offers of Employment are contingent upon the following conditions: satisfactory professional & employment references, healthcare and criminal background checks, appropriate licensure/certifications and the successful completion of a physical and pre-employment drug screen.
*CCHHS is strictly prohibited from conditioning, basing or knowingly prejudicing or affecting any term or aspect of County employment or hiring upon or because of any political reason or factor.
COOK COUNTY HEALTH AND HOSPITALS SYSTEM IS AN EQUAL OPPORTUNITY EMPLOYER
ABOUT COOK COUNTY HEALTH (CCH)
The Cook County Health’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.
CCH 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, CCH 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.
COOK COUNTY HEALTH IS AN EQUAL OPPORTUNITY EMPLOYER