EHR Reporting Specialist

Get to know Summit Pacific Medical Center:

Your trusted partner in Health and Wellness, Summit Pacific is a vibrant and expanding public hospital district that operates a Critical Access Hospital with a Level IV trauma designation, three rural healthcare clinics, and a seven-day-a-week urgent care clinic. Our vision is “Through Summit Care, we will build the healthiest community in the Nation.” Our hospital is unique due to its size and accessibility. We pride ourselves on our ability to give patients quick access to a provider.

• Critical Access Hospital
• 24/7 Emergency Department
• Level II Cardiac Center
• Level III Stroke Center
• Level IV Trauma Care

To learn more about Summit Pacific, visit www.summitpacificmedicalcenter.org

Pay Range (depending on experience):

.

Role Summary

The EHR Reporting Specialist will design, build, validate, and maintain clinical and operational reports and dashboards that support decision-making across the organization. This role requires deep experience with Epic reporting tools, strong SQL development skills, and the ability to create intuitive visualizations in Power BI or other reporting options. The Specialist will partner with clinical leaders, IT, and EHR & Data Governance committees to ensure reports are accurate, secure, and aligned with organizational priorities.

Key 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.

Required Qualifications

• Education: Bachelor’s degree in Health Informatics, Computer Science, Information Systems, Public Health, or related field.
• Experience: 3+ years of hands-on experience building reports and dashboards using Epic reporting tools and Power BI.
• Certification: Epic reporting certification(s) such as Reporting Workbench, Clarity, Caboodle, and/or Cogito.
• Technical Skills: Advanced SQL skills for querying, ETL development, and performance tuning.
• EHR Knowledge: Proven working knowledge of Epic data structures and common reporting sources (Clarity, Caboodle, Chronicles, Cogito).
• Visualization: Demonstrated ability to design clear, user-focused Power BI reports and implement row-level security.
• Communication: Strong written and verbal communication skills for translating technical concepts to clinical and business stakeholders.

Preferred Qualifications

• Advanced Tools: Experience with SQL Server, SSRS, Azure Data Factory, or other ETL/orchestration tools.
• Healthcare Analytics: Familiarity with clinical quality measures, HEDIS, CMS reporting, or population health analytics.
• Programming: Experience with DAX and Power Query (M) for advanced Power BI modeling.
• Process Improvement: Background in Lean, Six Sigma, or analytics-driven process improvement projects.

Skills and Competencies

• Analytical Thinking: Able to troubleshoot complex data issues and design robust reporting solutions.
• Detail Orientation: Meticulous about data accuracy, validation, and documentation.
• Collaboration: Works effectively with clinical leaders, IT, informatics, and data analyst teams.
• Prioritization: Manages competing requests and delivers high-impact reports on schedule.
• Security Mindset: Understands PHI handling, access controls, and audit logging requirements.

Work Environment and Benefits

• Position based on-site with travel to satellite locations as needed.
• Competitive salary and comprehensive benefits including medical, dental, retirement plan, and paid time off.
• Professional development opportunities and support for Epic certification and analytics training.
• Collaborative team culture focused on improving patient care through data-driven insights.

Work Shift:

Working Location:

Benefits:

Our uniquely designed benefits are here to support you and your family in staying well, growing professionally and achieving financial security!

We take care of you, so you can focus on delivering our mission of caring for everyone, especially the most vulnerable in our communities.

Benefits offered by SPMC:

• 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

Additional Information:

• Summit Pacific is a vibrant and expanding nonprofit public hospital district serving east Grays Harbor County, Washington. Founded in 1982, Summit Pacific now operates three locations comprised of a critical access hospital, primary care clinics, an urgent care clinic and range of ancillary and specialty services.
• Far enough to have privacy and enjoy the small-town lifestyle, yet close enough to have the benefits of the city. There are many year-round recreational activities in and around Grays Harbor such as:
• Hiking/ walking trails – whether you’re looking for short easy walking trails or long hikes you can find many trails located either on site or just miles from Summit Pacific. There are many great hiking trails about an hour away at the Quinault Rainforest which is also the home of some of the largest trees in the world!
• Kayaking – There are many areas that are easily accessible and have beautiful views.
• Nature viewing – Multiple whale watching towers and tours, state parks, Olympic Game Farm (where you can feed the animals straight from your car)
• Fishing & Hunting – If you’re looking for areas to hunt/ fish or looking for guided tours this is a great area! Westport is just 42 miles away with many opportunities to catch or buy fresh fish off the docks!
• Other activities – Multiple museums, winery, arcades, rentable mopeds, Seabrook (vacation beach town), many areas to surf for experienced surfers and surfing lessons for those who want to learn.
• Nearby colleges – Grays Harbor College is a community college located in Aberdeen with other community colleges located in surrounding areas, as well as some state colleges and universities in other areas of WA state.

Summit Pacific Medical Center is an equal opportunity provider and employer that is committed to a policy of non-discrimination on the basis of race, sex, age, religion, color, national origin, ancestry, disability, marital status, arrest and court record, sexual orientation, and status as a covered veteran. This policy covers admission and access to, and participation in, treatment and employment in the hospital’s programs, activities, services, and employment.

This organization participates in E-Verify. E-Verify is a service that verifies authorization to work in the U.S. through the U.S. Department of Homeland Security (DHS) and the U.S. Department of Social Security (SSA). For further information on E-Verify contact DHS at 1-888-464-4218.