At Northwestern Medicine, every patient interaction makes a difference in cultivating a positive workplace. This patient-first approach is what sets us apart as a leader in the healthcare industry. As an integral part of our team, you'll have the opportunity to join our quest for better health care, no matter where you work within the Northwestern Medicine system. We pride ourselves on providing competitive benefits: from tuition reimbursement and loan forgiveness to 401(k) matching and lifecycle benefits, our goal is to take care of our employees. Ready to join our quest for better?

Job Title: EPIC Cogito Administrators

Job Description

EPIC Cogito Administrators for various and unanticipated work locations (HQ: Chicago, IL). Responsible for the oversight, maintenance, and troubleshooting of the Cogito relational data workflows and Epic infrastructure within the Enterprise Data Warehouse environment. Implement and support Epic Cogito and SQL Server database in a large Hospital system. Manage the Epic Cogito data warehouse, ensuring data accuracy and conducting regular quality checks including claims, recruitment and metadata. Design and implement SQL server database platforms and Clarity/Caboodle implementation. Collaborate with Storage, Networking, and Windows Infrastructure teams to implement best server-performance practices. Provide technical support and troubleshooting assistance to end-users, resolving complex issues, including database availability and disaster recovery. Develop and maintain system documentation, including architectural diagrams, models, SOPs, and user guides. Lead system upgrades, patches, various projects, and testing. Monitoring and troubleshooting daily Clarity and Caboodle, ETL processes, as well as SlicerDicer JumpStart. Support upgrades, server administration and installations across Clarity, Caboodle, SlicerDicer, BI RESTful, SSAS cubes, SQL Syntax, and Interconnect-based Cogito servers and tools. Custom ETL design and development (SSIS) and developing Azure Cloud pipelines.

Required Skills:

Bachelor’s degree in Computer Science, IT or related field plus 5 years of progressive experience in Epic Cogito required. Required: 5 years: Epic ETL workflows, Clarity data warehousing practices, databases, SQL syntax, Epic related Cubes, claims, recruitment, metadata; SSIS design & development; database availability and disaster recovery. 3 years: Develop and maintain Caboodle data models, SlicerDicer, and KB SQL; daily troubleshooting and routine maintenance. Experience must include: implement strategies to improve clarity and caboodle ETL load. Background check and drug screen required. Hybrid work available, must live in state that NM is registered for business. Certification in EPIC Clarity & Caboodle Administration required. $89,856/yr - $117,660/yr.

REQ ID : LMT90689U

All your information will be kept confidential according to EEO guidelines.

Northwestern Medicine is an equal opportunity employer (disability, VETS) and does not discriminate in hiring or employment on the basis of age, sex, race, color, religion, national origin, gender identity, veteran status, disability, sexual orientation or any other protected status.

Background Check

Northwestern Medicine conducts a background check that includes criminal history on newly hired team members and, at times, internal transfers. If you are offered a position with us, you will be required to complete an authorization and disclosure form that gives Northwestern Medicine permission to run the background check.  Results are evaluated on a case-by-case basis, and we follow all local, state, and federal laws, including the Illinois Health Care Worker Background Check Act.

Artificial Intelligence Disclosure

Artificial Intelligence (AI) tools may be used in some portions of the candidate review process for this position, however, all employment decisions will be made by a person. 

Benefits

We offer a wide range of benefits that provide employees with tools and resources to improve their physical, emotional, and financial well-being while providing protection for unexpected life events. Please visit our Benefits section to learn more.

Sign-on Bonus Eligibility (if sign-on bonus offered for position): Internal employees and rehires who left Northwestern Medicine within 1 year are not eligible for the sign on bonus. Exception: New graduate internal employees seeking their first licensed clinical position at NM may be eligible depending upon the job family.