EPIC Cogito Administrator Associate, Full-time, Days

Company Description

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 Description

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.

Qualifications

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

Additional Information

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 hist