EPIC Cogito Administrator Associate, Full-time, Days

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?

The EPIC Cogito Administrator Associate, reflects the mission, vision, and values of NM, adheres to the organization’s Code of Ethics and Corporate Compliance Program, and complies with all relevant policies, procedures, guidelines and all other regulatory and accreditation standards.

Northwestern Medicine Information Services drives innovative, high-value solutions to transform health care.

We are committed to supporting the relentless pursuit of better medicine by providing exceptional service to our patients and guests as well as internal clients across the organization. To ensure excellence, our team goes to extraordinary lengths to ensure that our systems work together seamlessly.

Northwestern Medicine understands that technology plays an integral role in shaping the future of health care. Information Services strategically supports the organization by:

• Leveraging AI, automation and rollout of advanced cyber controls that support digital transformation strategies
• Implementing advanced technologies in clinical and administrative areas
• Furthering development of the end user support model to help enhance modern infrastructure

Responsibilities:

To succeed in this role, you must be attentive, detail oriented, highly driven, and a strong communicator. Some of those qualities include but are not limited to:

• The EPIC Cogito Administrator Associate is 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
• Design and implement SQL server database platforms and Clarity/Caboodle implementation, ensuring high availability and optimal performance
• 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
• Develop and maintain system documentation, including architecture diagrams, SOPs, and user guides
• Lead system upgrades, patches, various projects, and testing, ensuring seamless transitions to new versions
•  This will include monitoring and troubleshooting daily Clarity and Caboodle Extract, Transform, and Load (ETL) processes, as well as SlicerDicer JumpStart.
• The role is also expected to support Epic quarterly upgrades, as well as server administration and necessary installations across Clarity, Caboodle, SlicerDicer, BI RESTful, SSAS cubes, and Interconnect-based Cogito servers and tools.
• In addition to overseeing Epic released workflows, this position will also require occasional custom ETL development (SSIS) and developing Azure Cloud pipelines.

Required:

• Bachelors in related field (or equivalent experience)
• Obtain EPIC Cogito Systems Administration Certification within 6 months of hire
• General knowledge of Epic ETL workflows, Clarity and Caboodle data models, SlicerDicer, and KB SQL
•  3+ years' experience in core discipline
• Excellent verbal and written communications skills
• General knowledge of data warehousing practices, databases, SQL syntax
• Ability to perform daily troubleshooting and routine maintenance
• General knowledge of SSIS design/development
• General knowledge of database availability and disaster recovery

Preferred:

• Master’s degree
• Previous experience working in an Agile environment

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.

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