EPIC Cogito Administrator Associate, Full-time, Days

Northwestern Memorial Healthcare•Chicago, IL

4d•$33 - $44

About The Position

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.

Requirements

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

Nice To Haves

Master’s degree
Previous experience working in an Agile environment

Responsibilities

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.