• Collaborate with stakeholders to understand business needs and translate them into detailed requirements and agent specifications. • Analyze and document existing process to identify areas for improvement and automation. • Create and maintain comprehensive documentation, including requirements, system design, and user manuals. • Design, develop, and deploy basic autonomous AI agents using generative AI tools and frameworks such as Gemini Enterprise and Copilot. • Integrate AI agents with existing business software, tools, and APIs. • Review test plans to ensure the quality and reliability of AI agent outputs against expected business outcomes. • Coordinate with users to conduct User Acceptance Testing (UAT) and obtain sign-off for deployment. • Oversee the rollout and deployment of AI agents into production environments. • Act as the primary point of contact for stakeholders, providing regular updates on project progress. • Communicate complex concepts, process and solutions to both technical and non-technical audiences. • Manage stakeholder expectations and ensure that the final solution meets their needs. • Collaborate with development team to translate business needs to requirements. • Foster a culture of innovation, collaboration, and continuous learning within the team. • Stay up-to-date with the latest advancements in generative AI, machine learning, and related technologies.

• Requirements & Systems Analysis (Primary) Partner with stakeholders to gather, analyze, and document business requirements, functional specifications, user stories, and acceptance criteria. Translate business needs into clear, testable requirements and ensure alignment with system capabilities and constraints. Create and maintain process models, use cases, workflows, and supporting artifacts to communicate intent and “definition of done.” Identify gaps, ambiguities, and risks early; propose options and tradeoffs to drive decisions. Act as a liaison across field engineering, R&D, and customer stakeholders to keep delivery aligned and measurable. • QA, UAT, and Release Validation (Secondary) Build and execute test plans and test cases tied directly to requirements and acceptance criteria. Perform hands-on functional and regression testing for releases; coordinate integration testing needs with engineering as required. Plan, coordinate, and facilitate UAT with end users, including entry/exit criteria, test guidance, and sign-off workflows. Identify, document, and track defects with clear reproduction steps and expected vs. actual results; support triage and verification of fixes. Review test outcomes, summarize quality risk, and communicate release readiness to stakeholders. • Automation & AI-Assisted Testing (Expectation) Contribute to light automation over time by drafting and maintaining a small set of high-value automated checks (e.g., smoke/regression), in partnership with engineering. Use AI-assisted workflows to accelerate test case design, exploratory testing, and automation/script drafting—while following Totara security requirements and avoiding exposure of customer or federal data in unapproved tools. Continuously reduce repetitive manual work by improving test coverage, reusability, and clarity of test assets. • Collaboration & Communication Work closely with cross-functional teams (engineering, operations, customer stakeholders) to ensure alignment on scope, risks, and timelines. Provide clear status updates on requirements readiness, UAT progress, defects, and quality risk. Participate in planning, stand-ups, reviews, and retrospectives to improve delivery execution and quality outcomes. • Documentation & Reporting Maintain high-quality documentation of requirements, acceptance criteria, test plans, test cases, defects, and UAT artifacts. Produce quality summaries (coverage, defect themes, outstanding risk) for internal and customer-facing stakeholders when needed. Support knowledge base and user documentation updates when changes impact user workflows.

• System Administration • Maintain and update software systems to ensure optimal performance. • Review product updates, assess applicability to NorthStar, and plan and execute system updates. • Act as the primary point of contact with vendor • Participate as a system subject matter expert in process optimization initiatives. • Provide guidance and support to end users in leveraging system capabilities to support process improvement. • Manage Tier 2 and Tier 3 help desk tickets

Impact Advisors, LLC is a nationally recognized healthcare management consulting firm delivering Best in KLAS advisory, implementation, and optimization services. We are driven by a commitment to exceed client expectations and are proud to be a trusted partner to many of the nation's leading healthcare organizations. Our mission to drive patient-centered, value-driven outcomes has earned us prestigious industry accolades. To learn more about us, visit www.impact-advisors.com Impact Advisors, LLC is a nationally recognized healthcare management consulting firm delivering Best in KLAS advisory, implementation, and optimization services. We are driven by a commitment to exceed client expectations and are proud to be a trusted partner to many of the nation's leading healthcare organizations. Our mission to drive patient-centered, value-driven outcomes has earned us prestigious industry accolades. To learn more about us, visit www.impact-advisors.com Job Overview We’re seeking an experienced Epic Systems Database Administrator to own the reliability, performance, security, and lifecycle management of our Epic Cogito (analytics), Clarity (reporting), and Caboodle (enterprise data warehouse) platforms. You’ll be the go?to expert for database architecture, optimization, upgrades, and issue resolution—partnering closely with Epic application teams, reporting/BI developers, and infrastructure/security stakeholders to deliver high?quality, compliant analytics at scale. What You’ll Do Platform Administration & Reliability - Administer and support Epic Clarity (operational reporting database), Cogito (analytics framework including SlicerDicer), and Caboodle (EDW) environments—primarily on Microsoft SQL Server. - Configure and maintain HA/DR (e.g., SQL Server Always On AGs, failover clustering, log shipping) and routinely test backup/restore and disaster recovery scenarios. - Monitor capacity, jobs, ETL schedules, and platform health; triage and resolve performance incidents and failed jobs. - Support Epic-delivered Clarity ETL processes and Caboodle load frameworks; coordinate refresh windows and data latency expectations. - Develop, maintain, and harden SSIS/SQL Agent packages, stored procedures, and job orchestration supporting reporting and analytics. Performance & Optimization - Analyze query plans, tune SQL, add/adjust indexing strategies, and optimize ETL loads for Clarity & Caboodle. - Proactively identify hotspots (I/O, CPU, memory), refine resource allocation, and implement performance baselines and SLOs. Security, Compliance & Auditing - Implement least-privilege access models, manage logins/roles, and enforce encryption (at rest and in transit). - Maintain HIPAA compliance; support auditing, PHI/PII controls, and respond to security assessments. - Coordinate with InfoSec on vulnerability remediation, patching cadence, and configuration hardening. Upgrades & Lifecycle Management - Plan and execute Epic version upgrades and related database schema changes; maintain environment parity across dev/test/prod. - Apply OS/SQL Server patches, cumulative updates, and firmware/driver updates with minimal downtime. - Document configurations, runbooks, and operational SOPs; contribute to change management and CAB processes. Collaboration & Support - Partner with application analysts, report writers, and data engineers to troubleshoot data issues, validate models, and refine performance. - Provide on-call rotation coverage for critical incidents; offer mentorship to junior DBAs and analysts. - Participate in new solution design—capacity planning, data modeling considerations, and infrastructure sizing. Qualifications & Skills Core Epic & Data Platform Expertise - 5+ years administering Epic Clarity/Cogito/Caboodle or similar healthcare analytics platforms. - Deep experience with Microsoft SQL Server (2016+): database design, indexing, partitioning, query tuning, and performance troubleshooting (DMVs, wait stats, query store). - Hands-on with SQL Server HA/DR: Always On Availability Groups, clustering, backups/restores, log shipping, and DR exercises. - Knowledge of Caboodle data models and load frameworks - Familiarity with Reporting Workbench and/or SlicerDicer - Experience supporting Epic Clarity ETL cycles, refresh windows, and downstream reporting dependencies. - Proven enforcement of HIPAA compliance, PHI/PII handling, audit logging, encryption, and role-based access control. - Familiarity with enterprise change management, ITIL practices, and regulated environment controls. - Proficient with monitoring/observability (e.g., SQL Server native tools, SCOM, SolarWinds/DPA, Redgate, or equivalent). - Strong documentation and communication skills; comfort collaborating across clinical, technical, and leadership teams. - On call support experience, incident triage, and root-cause analysis. Preferred Qualifications - Epic Certifications/Proficiencies: Cogito, Clarity Data Model, Caboodle. - Working knowledge of Epic Chronicles/IRIS concepts. - Exposure to Azure or AWS RDS for SQL workloads. - Scripting automation with PowerShell or other scripting languages Travel is based on client needs At Impact Advisors, we are committed to transparency and equity in our compensation practices. The compensation for this role includes a salary range of $140,000 to $170,000 and may also be eligible for an annual performance bonus. This range reflects consideration of several factors, including skills, experience, training, certifications, and organizational needs. Our People and Culture: At Impact Advisors, we cultivate a caring, fun, honest, and autonomous work environment. Our success stems from our associates' dedication and a shared mission to create a “Positive Impact.” We embrace diversity and inclusion, fostering an environment where all employees feel valued and empowered. Join Impact Advisors and make a real difference in healthcare. For salaried positions, this role may also be eligible for an annual performance bonus. Additional benefits and perks may also be available, depending on the position and employment terms. This range reflects consideration of several factors, including skills, experience, training, certifications, and organizational needs. Our People and Culture At Impact Advisors, we cultivate a caring, fun, honest, and autonomous work environment. Our success stems from our associates' dedication and a shared mission to create a “Positive Impact.” We embrace diversity and inclusion, fostering an environment where all employees feel valued and empowered. Join Impact Advisors and make a real difference in healthcare.