ASCP EHR Reporting Specialist

EHR Reporting Specialist

Join a dynamic healthcare team in the Pacific Northwest region as an EHR Reporting Specialist. This role focuses on designing, building, validating, and maintaining clinical and operational reports and dashboards that empower decision-making across the organization.

You will leverage your expertise with Epic reporting tools and advanced SQL skills to create intuitive visualizations using Power BI or similar platforms. Collaborating closely with clinical leaders, IT, and data governance committees, you will ensure reports are accurate, secure, and aligned with organizational goals.

Develop and optimize Epic reporting artifacts including Clarity reports, Caboodle/Kronos extracts, Radar dashboards, and Reporting Workbench items.

Write complex SQL queries and stored procedures to extract, transform, and load clinical and operational data.

Design and publish interactive Power BI dashboards and paginated reports for various stakeholders including clinical operations, quality, finance, and executives.

Validate report logic and data accuracy through thorough testing, reconciliation, and documentation.

Translate business requirements into technical specifications and lead requirements-gathering sessions.

Implement performance tuning strategies to enhance query and report efficiency.

Apply data governance, security, and privacy best practices ensuring HIPAA compliance and role-based access controls.

Provide end-user training, create user guides, and offer ongoing support for report consumers.

Participate in project planning, change management, and cross-functional initiatives to improve reporting workflows and data quality.

Bachelor's degree in Health Informatics, Computer Science, Information Systems, Public Health, or a related field is required.

Minimum of 3 years 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 are essential.

Advanced SQL skills for querying, ETL development, and performance tuning.

Strong knowledge of Epic data structures and common reporting sources.

Proven ability to design user-focused Power BI reports with row-level security.

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.

Programming skills in DAX and Power Query (M) for advanced Power BI modeling.

Background in Lean, Six Sigma, or analytics-driven process improvement projects.

Analytical thinking with the ability to troubleshoot complex data issues.

Detail-oriented approach to data accuracy, validation, and documentation.

Strong collaboration skills working with clinical leaders, IT, informatics, and data analyst teams.

Effective prioritization to manage competing requests and deliver high-impact reports on schedule.

Security mindset with understanding of PHI handling, access controls, and audit logging.

This full-time position is based on-site with occasional travel to satellite locations. The role offers a competitive salary and comprehensive benefits including medical, dental, retirement plans, and paid time off. Professional development opportunities and support for Epic certification and analytics training are provided. The team culture is collaborative and focused on improving patient care through data-driven insights.