Job Number:

Job Posting

Closing Date

Organization

The Data Integration Manager works with cross-functional teams and current Cook County Health (CCH) and industry partners to ensure seamless connectivity and data integration between the health plan and delegated partners, vendors and care management clinical systems. Works closely with the Third-Party Administrator, delegates, vendors, participating hospitals and business leads to understand and develop workflows and goals to implement and support Medicaid and Medicare products.

This position is exempt from Career Service under the CCH Personnel Rules.

Typical Duties

• Provides reporting on data management and quality issues and concerns to the Chief Operating Officer, Health Plan Services and key business leads of each department within health plan services.
• Reviews Centers for Medicare and Medicaid Service (CMS) and Healthcare and Family Services (HFS) regulations and guidance to ensure applicable departmental processes, policies and procedures are well documented and result in efficient and compliant administration of Health Plan Services' program.
• Builds advanced SQL queries to extract datasets from a clinical data warehouse to support CCH's research and quality improvement activities.
• Generates reports using Tableau, SQL Analysis, Reporting Services and web-based applications.
• Plans and conducts structured testing of database designs to confirm functionality and performance. Automates the maintenance of data with storage procedures, scripts, Data Transaction Services and SQL Server Integration Services (SSIS).
• Maximizes the performance of the databases by using proper techniques of slicing and indexing.
• Participates in stakeholder and leadership meetings and makes recommendations on quality management issues and concerns.
• Develops, implements and maintains complex data models and logical database designs.
• Documents the Database Architecture and the Data Dictionaries.
• Performs other duties as assigned.

*

• Bachelor's Degree from an accredited college or university in Computer Science or related field
• Two (2) years of experience as a Data Manager or similar role
• One (1) year of experience working with Microsoft-SQL Server 2012-2017, SQL Data Analysis Services, SQL Data Transformation Services, SQL Server Integration System, Tableau or SQL Reporting Services
• Prior experience writing stored procedures (sproc), complex queries, correlated/nested sub-queries, derived tables, and Common Table Expressions (CTE)
• Prior experience implementing database security elements to meet HIPAA and Health Information Technology for Economic and Clinical Health Act (HITECH) standards
• Position requires moderate local travel for which the employee must possess a valid driver's license and insured vehicle or otherwise provide an acceptable and reliable means of transportation

Preferred Qualifications

• Master's degree from an accredited college or university in business administration, health care administration, public policy, social work, or public health
• Five (5) years of experience as a Data Manager or similar role
• Prior experience with government programs such as Medicaid and Medicare compliance rules
• Coursework in healthcare administration, project management, process improvement or operations management

Knowledge, Skills, Abilities and Other Characteristics

• Knowledge of the principles of Medicaid Managed Care principles and management practices
• Knowledge and familiarity with SQL queries to extract datasets from enterprise data warehouse Medicare and/or Medicaid insurance payment systems
• Knowledge of Microsoft Office Suite (Access, Excel, PowerPoint and Word)
• Knowledge and understanding of implementation, startups and operationalizing Managed Care programs
• 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
• Demonstrate excellent 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
• Ability to adhere to confidentiality standards, HIPAA compliance program and cultural competency program
• Ability to establish and maintain effective working relationships with individuals at all levels, internally and externally
• 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 maintain a professional demeanor and composure when challenged
• Ability to function autonomously and as a team member in a multidisciplinary team
• Ability to train by presenting concepts and demonstrating tasks
• Ability to perform accurate and reliable mathematical calculations to support reimbursement analysis and measure financial performance
• Ability to work flexible hours
• Must be able to travel to work sites throughout Cook County

VETERAN PREFERENCE

PLEASE READ

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 and Honorable Discharge Status. Discharge papers not listing an Honorable Discharge Status are not acceptable

OR

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.

Benefits Package

• Medical, Dental, and Vision Coverage

• Basic Term Life Insurance

• Pension Plan

• Deferred Compensation Program

• Paid Holidays, Vacation, and Sick Time

• You may also qualify for the Public Service Loan Forgiveness Program (PSLF)

For further information on our excellent benefits package, please click on the following link: http://www.cookcountyrisk.com/

MUST MEET ALL REQUIRED QUALIFICATIONS AT TIME OF APPLICATION FILING.

*Degrees awarded outside of 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 bust 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 & HOSPITALS SYSTEM IS AN EQUAL OPPORTUNITY EMPLOYER