Administrator, Epic Cogito & Report Database

This position is hybrid and will require 3 days on site at one of the following Quest sites: Secaucus NJ or Schaumburg IL. Remote: This position can also be 100% remote if not located near a hub within certain criteria.

Pay Range: $00 plus yearly bonus.

Salary offers are based on a wide range of factors including relevant skills training experience education and where applicable certifications obtained. Market and organizational factors are also considered. Successful candidates may be eligible to receive annual performance bonus compensation.

Benefits Information: We are proud to offer best-in-class benefits and programs to support employees and their families in living healthy happy lives. Our pay and benefit plans have been designed to promote employee health in all respects physical financial and developmental. Depending on whether it is a part-time or full-time position some of the benefits offered may include: Day 1 Medical supplemental health dental & vision for FT employees who work 30 hours

• Best-in-class well-being programs
• Annual no-cost health assessment program
• Blueprint for Wellness
• healthyMINDS mental health program
• Vacation and Health/Flex Time
• 6 Holidays plus 1 MyDay off
• FinFit financial coaching and services
• 401(k) pre-tax and/or Roth IRA with company match up to 5% after 12 months of service
• Employee stock purchase plan
• Life and disability insurance plus buy-up option
• Flexible Spending Accounts Annual incentive plans
• Matching gifts program
• Education assistance through MyQuest for Education Career advancement opportunities and so much more!

As the Epic Cogito Database Administrator within the Infrastructure team you are accountable for the architecture performance security and day-to-day administration of Quest Diagnostics Epic reporting database ecosystem. This critical infrastructure role focuses heavily on managing the backend data environments primarily Epic Clarity and Caboodle as well as the underlying infrastructure for SlicerDicer.

You will serve as the primary technical authority for Cogito infrastructure ensuring a highly available optimized and secure data foundation. A key aspect of this role is maintaining a strong collaborative partnership with the Cogito Application Team. The Epic Cogito & Reporting Systems Database Administrator is accountable for database health successful ETL execution schema management and architectural capacity planning.

• Serve as the primary infrastructure liaison to the Cogito Application Team advising BIDs and the Cogito Sr. Manager on database capabilities limitations and performance optimization.
• Lead architectural design and capacity planning exercises for the Epic Cogito stack ensuring adequate system resources (RAM CPU storage) for current and future organizational analytics needs.
• Mentor and cross-train infrastructure team members on Epic database operations.
• Accountable for all installations upgrades patching and database configurations for the Epic Cogito suite (Clarity Caboodle) in coordination with the broader infrastructure team (UNIX MS SQL Windows Network).
• Monitor troubleshoot and proactively address unusual system behavior to ensure optimal system performance and high availability.
• Accountable for executing backups restores environment refreshes and disaster recovery procedures for the Cogito databases.
• Own maintain and support the nightly Extract Transform and Load (ETL) processes (e.g. using Epic Console/Compass) into the reporting and data warehouse databases.
• Lead the troubleshooting research and resolution of complex Clarity and Caboodle data extraction errors minimizing downtime for the Application team.
• Execute the addition of new tables columns and indexes to database tables as requested by the BI Developers to support organizational analytics.
• Configure SlicerDicer-related infrastructure access and manage the database-level security and service accounts.
• Define create and manage database user accounts profiles privileges roles and audit information ensuring compliance with Quest security standards.
• Perform advanced hands-on tuning of T-SQL queries indexing strategies and relational database designs to optimize query performance for downstream BI tools.

Required WorkExperience:

• 5 years acting as an Epic Cogito Database or ETL Administrator
• Strong proficiency in Clarity Caboodle SlicerDicer
• Strong background supporting BI/Data Warehouse teams in an enterprise healthcare environment

Preferred Work Experience:

• Experience operating as a lead or senior technical resource in 3 or more large-scale Epic implementations.

Education:

• Bachelors degree in Computer Science Information Technology Healthcare Administration or equivalent professional work experience. (Required)
• Masters degree in a technical or IT-related field. (Preferred)

Technical Training or Professional Licensing:

• Active Epic Certifications in Clarity ETL Administrator and Caboodle Administrator (Required)
• Microsoft SQL Server administration (Required)

Travel required: Less than 25%