DSHS FTAA Epic Senior Business Intelligent Analyst

State of Washington; Olympia (WA); On-site; USD 95,000 - 130,000; Full time

Job summary

State of Washington is seeking an experienced Epic Senior BI Analyst to lead data management for FTAA IT, focusing on EHR data, Epic tools, and reporting. You will translate requirements, design dashboards, and drive data-driven improvements across health services statewide.

The role requires deep Epic expertise, strong SQL, Agile delivery, and certification in BI platforms. Join a mission-driven team serving 2.9 million Washingtonians with privacy compliant data solutions.

Qualifications

• Bachelor’s degree in Health Informatics, CS, IS, or related field; 7+ years Epic analytics/implementation.
• Epic experience in healthcare delivery settings with Epic backend DB.
• 7+ years Epic experience with leadership/senior responsibilities.
• Proficient in SQL and data engineering for multi-table queries.
• Experience with Agile/Scrum, Jira or Azure DevOps.

Responsibilities

• Review clinical data requests and prioritize backlog for sprint execution.
• Translate business requirements into User Stories, Epics, and Themes in Jira/ADO.
• Analyze EHR usage data to identify bottlenecks and inform roadmap.
• Design and build automated data visualizations and dashboards.
• Perform rapid analyses during public health events or inquiries.
• Write and optimize complex SQL across multiple tables.
• Configure Epic Cogito reporting tools for real-time data delivery.
• Ensure data privacy per HIPAA and state policies.
• Audit database schemas against standardized healthcare terminologies.

Skills

Epic experience

Healthcare analytics

Data analysis

Education

Bachelor’s degree in Health Informatics, CS, IS, or related field

CBAP or CCBA certification

BI platform certifications (Power BI, Tableau)

Tools

Epic Cogito

SlicerDicer

Clarity Data Model

CABoodle Data Model

Power BI/Tableau

Jira/Azure DevOps

Job description

DSHS FTAA IT Data Management - Senior Specialist

We are seeking an experienced Epic Senior Business Intelligent Analyst to join our team at the Finance, Technology, Analytics, and Accounting Administration (FTAA) and Division of Enterprise Technology (DIT). This is an amazing opportunity for you to utilize your Epic Caboodle, Cogito, Slicer Dicer, and/or Clarity experience and certificates.

In this role you will be a subject matter expert in Electronic Health Records (EHR), clinical operational workflow context, EHR data models, coding terminology and standards, data privacy and compliance, integration and downstream system context and have Epic specific reporting knowledge. You will also support the reporting and integration of the DSHS EHR product and ensure it aligns with the vision and needs of the Health and Human Services (HHS) Coalition organizations, its staff, business partners, community partners and the 2.9 million Washingtonians served by these coalition organizations statewide.

Some of what you will do:

• Review and analyze incoming clinical data requests from DSHS and Health Care Management and Coordination Systems (HCMACS) business partners using objective scoring metrics to estimate development effort and prioritize the data backlog for sprint execution


• Translate ambiguous healthcare business requirements into clear, technically sound User Stories, Epics, and Themes within Jira


• Perform quantitative analyses on EHR system usage data using database auditing tools to discover operational workflow bottlenecks, resulting in data-backed feature recommendations for the software development roadmap


• Conceptualize, design, and build automated data visualizations and clinical dashboards


• Conduct rapid-response, ad-hoc statistical analyses on raw EHR datasets during public health emergencies or legislative inquiries


• Write and optimize complex, multi-table SQL queries


• Configure and deploy embedded Epic Cogito reporting tools to deliver real-time data to healthcare workers


• Subject all custom SQL code and dashboards to rigid peer reviews and data validation testing prior to live production deployment


• Evaluate data extraction patterns and user report access lists against HIPAA regulations and state data privacy policies


• Map and audit database schemas against standardized healthcare coding terminologies

Who should apply?

A Bachelor’s degree in Health Informatics, Computer Science, Information Systems, or a related field
AND
Seven years of progressively responsible experience in Epic application analysis, configuration, and implementation, including at least two years in a lead or senior capacity.
OR
A minimum of eleven years experience progressively responsible experience, with statewide authority and impact, consulting with and providing high level advice to organization leadership regarding the administration of health record management and administration. This includes developing and implementing state policies and operational procedures which are informed by state and federal policies and regulations.
Must demonstrate depth in the following areas:

• Epic & Healthcare Context (minimum two to three years): Direct hands-on experience working in a healthcare delivery setting (such as a hospital, state health authority, or corrections infirmary), with specific experience utilizing Epic’s backend database architecture


• Data Engineering & SQL: A proven track record of writing, tuning, and optimizing multi-table SQL queries against relational or dimensional database schemas


• Agile Framework Delivery: At least 2 years of experience operating directly within an Agile/Scrum software development lifecycle, including experience writing structured user stories, epics, and acceptance criteria in tools like Jira or Azure DevOps


• Data and Reporting Visualization: Proficiency in designing, publishing, and securing production-tier enterprise dashboards using tools like Power BI or Tableau

Graduate degrees (such as a Master's degree in Health Informatics, Data Science, or Public Administration) can substitute for up to one to two years of general experience. Conversely, highly relevant professional IT or data engineering experience can substitute year-for-year for the formal degree.

What we're looking for:

• Epic Cogito Fundamentals / Tools Admin: Verifies mastery over Epic's front-end reporting suite, including Radar dashboards, Reporting Workbench, and SlicerDicer


• Epic Caboodle Data Model: Verifies the technical ability to query and customize Epic’s pre-aggregated dimensional data warehouse


• Epic Clarity Data Model (Clinical and/or Revenue modules): Verifies deep structural knowledge of Epic's massive relational SQL backend databases


• Business Analysis Professional Certification: Certified Business Analysis Professional (CBAP) or Certification of Capability in Business Analysis (CCBA) to validate Agile requirements gathering skills


• BI Platform Certifications: Microsoft Certified: Power BI Data Analyst Associate, or Tableau Desktop Certified Professional

The Department of Social and Health Services’ (DSHS) vision that people find human services to shape their own lives requires that we come together with a sense of belonging, common purpose, shared values, and meaningful work. It is crucial to our agency’s vision that you bring a fairness, access, and social justice commitment to your work with DSHS. We strive to support all Washingtonians, including Black, Indigenous, and People of Color, people with physical, behavioral health, and intellectual disabilities, elders, LGBTQIA+ individuals, immigrants and refugees, and families building financial security.

Prior to a new hire, a background check including criminal record history may be conducted. Information from the background check will not necessarily preclude employment but will be considered in determining the applicant’s suitability and competence to perform in the job. This announcement may be used to fill multiple vacancies. Employees driving on state business must have a valid driver's license. Employees driving a privately owned vehicle on state business must have liability insurance on the privately owned vehicle.

Washington State Department of Social and Health Services is an equal opportunity employer and does not discriminate in any area of employment, its programs or services on the basis of age, sex, sexual orientation, gender, gender identity/expression, marital status, race, creed, color, national origin, religion or beliefs, political affiliation, military status, honorably discharged veteran, Vietnam Era, recently separated or other protected veteran status, the presence of any sensory, mental, physical disability or the use of a trained dog guide or service animal by a person with a disability, equal pay or genetic information. Persons requiring accommodation in the application process or this job announcement in an alternative format may contact the Recruiter at [phone]. Applicants who are deaf or hard of hearing may call through Washington Relay Service by dialing 7-1-1 or 1-800-833-6384.

Relationship and Reporting Structure ( Nepotism ) Disclosure: If you are selected for hire, you must disclose whether you have a relative, household member, close friend, or romantic partner within your potential supervisory chain of command. DSHS has a Relationships and the Reporting Structure policy that prohibits nepotism and can be reviewed https://www.dshs.wa.gov/sites/default/files/rpau/ap/DSHS-AP-18-17-Internet-Official-Housekeeping-2024.pdf. Applicants whose appointment would result in a prohibited reporting relationship are not eligible for appointment to that position.

E-Verify® is a registered trademark of the U.S. Department of Homeland Security