Epic Cogito Administrator - Remote

Requisition number: 2389328

Job category: OptumInsight Consulting

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.

The Cogito Administrator is a remote Analyst-level role, responsible for the configuration, monitoring, support and administration of the Epic Systems application/data infrastructure. The Cogito (Reporting) Administrator will help to maintain an optimized database infrastructure to support numerous client reporting and data needs. High level tasks include creating and maintaining the reporting and data warehouse databases, and installing, maintaining, and supporting the nightly Extract, Transform, and Load (ETL) processes into the reporting and data warehouse databases.

The Cogito Administrator will help create and foster a culture of diversity and inclusion within a new and growth-minded service line for UnitedHealth Group. The role will exemplify and reflect the UnitedHealth Group core Values.

The Cogito Administrator must be a self-motivated individual with exceptional communication, presentation and interpersonal skills and the ability to work well in team environments.

You'll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges. For all hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week.

Primary Responsibilities:

• Configure and maintain the reporting databases according to environment strategies

• Engage in capacity planning exercises to ensure adequate system resources like RAM, CPU, and storage

• Monitor database size, health, and performance

• Create and manage plans for maintaining statistics and indexes

• Manage logins for different types of database access

• Apply updates to production and non-production environments

• Perform database backups and verify restores to ensure business continuity

• Follow vendor and Epic best practices for hardware and software configuration

• Verify Extract, Transform, and Load (ETL) processes are completed daily and are error-free

• Add new tables, columns, indexes, etc.. to database tables and objects

• Work with Business Intelligence Developers to provide report data

• Respond to emergency after-hours issues

• Collaborate with technical teams and Epic support

You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.

Required Qualifications:

• Certification in EPIC Clarity & Caboodle Administration

• 4+ years of experience with Epic ETL workflows, Caboodle data warehousing practices, databases, SQL syntax, claims, metadata; SSIS design & development; database availability and disaster recovery

• 4+ years of experience with the implementation of strategies to improve clarity and caboodle ETL load

Preferred Qualifications:

• Experience with running Epic environments in Azure

• Clear understanding and experience in Microsoft SQL Server environments

• Understanding of the Extract, Transform, and Load process

• US based to support the US market hours

Key Competencies:

• Ability to perform basic troubleshooting on Microsoft SQL Server databases/servers

• Required to complete and maintain an Epic Cogito Administration certification

• Installs, upgrades, maintains and supports Epic reporting databases (Clarity, Caboodle, SlicerDicer etc.) server platforms

• Apply Epic database updates to all installed databases

• Works with other teams to apply and validate updates to databases and ETL infrastructure

• Monitors and optimizes the performance of Epic nightly ETL processes and Epic database updates

• Defines and implements security, audit, and resource allocation policies and procedures. Defines, creates, and manages service user accounts, profiles, privileges, roles, and required audit information

• Communicate and coordinate with other teams (UNIX, MS SQL, Windows, Network, SAN etc.) related to database, application and environment support and projects

*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy

Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. The salary for this role will range from $72,800 - $130,000 annually based on full-time employment. We comply with all minimum wage laws as applicable.

Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.

UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.

UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.