Summit Pacific Medical Center ยท 2 months ago
EHR Reporting Specialist
Elma, Washington
Full-time
Onsite
Mid Level
$36.74/hr - $58.22/hr
3+ years expSummit Pacific Medical Center is a vibrant and expanding public hospital district that operates a Critical Access Hospital. The EHR Reporting Specialist will design, build, validate, and maintain clinical and operational reports and dashboards that support decision-making across the organization, collaborating with clinical leaders and IT to ensure accuracy and security of reporting solutions.
Elder CareHealth CareMedical
No H1B
Responsibilities
Develop, maintain, and optimize Epic reporting artifacts including Clarity reports, Caboodle/Kronos extracts, Radar dashboards, and Cogito/Reporting Workbench items where applicable
Write complex SQL queries and stored procedures to extract, transform, and load clinical and operational data from Epic and ancillary databases
Design and publish interactive Power BI dashboards and paginated reports for clinical operations, quality, finance, and executive stakeholders
Validate report logic and data accuracy through systematic testing, reconciliation, and peer review; document validation results and data lineage
Translate business requirements into technical specifications; lead requirements-gathering sessions with clinical and administrative teams
Implement performance tuning and indexing strategies to improve query and report performance; monitor report runtimes and usage
Apply data governance, security, and privacy best practices to reporting solutions, ensuring HIPAA compliance and role-based access controls
Provide end-user training, create user guides, and offer ongoing support for report consumers; triage and resolve production issues
Participate in project planning, change management, and cross-functional initiatives to improve reporting workflows and data quality
Qualification
Required
Bachelor's degree in Health Informatics, Computer Science, Information Systems, Public Health, or related field
3+ years of hands-on experience building reports and dashboards using Epic reporting tools and Power BI
Epic reporting certification(s) such as Reporting Workbench, Clarity, Caboodle, and/or Cogito
Advanced SQL skills for querying, ETL development, and performance tuning
Proven working knowledge of Epic data structures and common reporting sources (Clarity, Caboodle, Chronicles, Cogito)
Demonstrated ability to design clear, user-focused Power BI reports and implement row-level security
Strong written and verbal communication skills for translating technical concepts to clinical and business stakeholders
Preferred
Experience with SQL Server, SSRS, Azure Data Factory, or other ETL/orchestration tools
Familiarity with clinical quality measures, HEDIS, CMS reporting, or population health analytics
Experience with DAX and Power Query (M) for advanced Power BI modeling
Background in Lean, Six Sigma, or analytics-driven process improvement projects
Benefits
Competitive Compensation
Medical
Prescription
Dental (including Orthodontia)
Vision
Healthcare FSA and daycare FSA
Daycare subsidized benefit
Life Insurance
Accidental Death and Dismemberment (AD&D)
Short- and long-term disability
Generous employer 403b match contributions for retirement
457 retirement account for additional funds
Employee Assistance Program (EAP)
Tuition reimbursement
Smoking Cessation Assistance
Employee Wellness Program
Employee Committees to participate in such as Spirit Team
Beautiful on-site gym for employees
Instructor led fitness classes for employees, including Yoga, Kettlebells and Bootcamps
Walking trails on site
Company
Summit Pacific Medical Center
Summit Pacific is a public hospital that deals with critical care providing 24-hour emergency services.
Founded in 1956Elma, Washington, USA
201-500 employees
Funding
Current Stage
Growth StageTotal Funding
unknownKey Investors
Cambia Health Foundation
2025-08-21Grant
Leadership Team
Josh Martin
Chief Executive Officer
James Hansen, MBA, CPA
Chief Financial Officer
Recent News
Company data provided by crunchbase