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.

• Develop new features and software improvements across backend and firmware layers • Test, deploy and debug backend API and firmware services • Write clear, tested, documented code for both application and embedded systems • Create and review technical design, code, and documentation • Contribute to Wynd’s infrastructure which includes mobile, desktop, embedded, and server-side applications

• Own and Optimize Enterprise Systems. You will be responsible for the day-to-day health, performance, and continuous improvement of Ollie’s core enterprise systems, including ERP, WMS, and related operational platforms. You will ensure systems are configured to support scale, reduce manual work, and enable accurate, reliable execution across the business. • Own End-to-End Business Processes Across Systems. You will own key business workflows that span multiple systems — from order creation through fulfillment, billing, and downstream reporting. This includes documenting current-state processes, designing future-state improvements, and ensuring system behavior aligns with real operational needs. • Drive Integrations and Data Flow Integrity. You will partner with technical teams and vendors to define, maintain, and improve integrations between systems (e.g., commerce platforms, ERP, WMS, 3PLs). You will help ensure data is accurate, timely, and reliable across systems, and will support monitoring, reconciliation, and issue resolution when things break. • Empower Finance and Operations Teams. You will serve as a trusted partner to Finance and Operations stakeholders, translating business needs into system solutions. You will proactively identify opportunities for automation, standardization, and process improvement that enable teams to operate more efficiently and with greater confidence in the data. • Execute with Technical Expertise. You will contribute hands-on where needed by configuring systems, writing scripts or workflows to support critical business functions, and implementing best practices for testing, QA, documentation, and controlled releases. • Contribute to the Long-Term Systems Vision. You will help shape the roadmap for Ollie’s enterprise systems by identifying gaps, proposing improvements, and prioritizing initiatives that support growth, scalability, and operational excellence.

• Provide pre-sales technical support and technical expertise to our customers and partners with objective to achieve sales targets. • Establish trusted advisory role with strategic customers and partners (CIO, CISO). • Enable and/or update partner network on product evolution. • Perform workshops with prospects or customers on product evaluations and do demonstrations. • Perform hands-on tests to validate customer proof-of-concept setups, network designs, and network deployments using new products and feature. • Respond to RFI’s/RFP’s. • Provide market and product feedback to product management and back-office. • Keep up-to-date on competitive solutions, products, and services. • Author whitepapers, knowledge base articles, and other customer/partner facing content.