DSHS FTAA Epic Senior Business Intelligent Analyst
State of Washington
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Job summary
State of Washington's Department of Social and Health Services (DSHS) seeks an experienced Epic Senior BI Analyst to lead data management, analytics, and reporting initiatives within FTAA IT Data Management. You will leverage Epic Caboodle, Cogito, Slicer Dicer, and Clarity to deliver data insights for the healthcare ecosystem.
Responsibilities include translating requirements into Epics and stories, designing dashboards in Power BI/Tableau, and ensuring HIPAA‑compliant data access while
Qualifications
- Bachelor's degree in Health Informatics, Computer Science, Information Systems, or a related field.
- Seven years of progressively responsible experience in Epic application analysis, configuration, and implementation, including at least two years in a lead or senior capacity.
- Eleven years of experience consulting with and advising leadership on health record administration, policies, and procedures may substitute for the degree.
Responsibilities
- Review and analyze incoming clinical data requests and prioritize the data backlog for sprint execution.
- Translate business requirements into clear user stories, epics, and themes in Jira or Azure DevOps.
- Perform quantitative analyses on EHR usage data to identify workflow bottlenecks and inform the software roadmap.
- Design, build, and deploy automated data visualizations and clinical dashboards.
- Write and optimize complex multi‑table SQL queries and ensure data security and HIPAA compliance.
Skills
Education
Tools
Job description
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.
- 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
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.
- 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.
- 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
- Current chronological resume
- A cover letter explaining why you are interested in the job, your skills, and experience that makes you the best person for the job
- Three professional references with current contact information
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.
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/pau/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
Employee benefits are not just about the kind of services you get, they are also about how much you may have to pay out of pocket. Washington State offers one of the most competitive benefits packages in the nation.
We understand that your life revolves around more than just your career. Like everyone, your first priority is ensuring that you and your family will maintain health and financial security. That's why choice is a key component of our benefits package. We have a selection of health and retirement plans, paid leave, staff training and other compensation benefits that you can mix and match to meet your current and future needs.
Employees and their families are covered by medical (including vision), dental and basic life insurance. There are multiple medical plans with affordable monthly premiums that offer coverage throughout the state.
Staff are eligible to enroll each year in a medical flexible spending account which enables them to use tax-deferred dollars toward their health care expenses. Employees are also covered by basic life and long‑term disability insurance, with the option to purchase additional coverage amounts.
To view premium rates, coverage choice in your area and how to enroll, please visit the Public Employees Benefits Board (PEBB) website. The Washington Wellness program from the Health Care Authority works with PEBB to support our workplace wellness programs.
Dependent care assistance allows the employee to save pre‑tax dollars for a child or elder care expenses.
Other insurance coverage for auto, boat, home, and renter insurance is available through payroll deduction.
The Washington State Employee Assistance Program promotes the health and well‑being of employees.
State Employees are members of the Washington Public Employees' Retirement System (PERS). New employees have the option of two employer contributed retirement programs. For additional information, check out the Department of Retirement Systems' web site.
Employees also have the ability to participate in the Deferred Compensation Program (DCP). This is a supplemental retirement savings program (similar to an IRA) that allows you control over the amount of pre‑tax salary dollars you defer as well as the flexibility to choose between multiple investment options.
All state employees are covered by the federal Social Security and Medicare systems. The state and the employee pay an equal amount into the system.
If you are employed by a government or not-for-profit organization, and meet the qualifying criteria, you may be eligible to receive student loan forgiveness under the Public Service Loan Forgiveness Program.
Full-time and part-time employees are entitled to paid holidays and one paid personal holiday per calendar year.
Note: Employees who are members of certain Unions may be entitled to additional personal leave day(s), please refer to position specific Collective Bargaining Agreements for more information.
Full-time employees who work full monthly schedules qualify for holiday compensation if they are employed before the holiday and are in pay status for at least 80 nonovertime hours during the month of the holiday; or for the entire work shift preceding the holiday.
Part-time employees who are in pay status during the month of the holiday qualify for the holiday on a pro‑rata basis. Compensation for holidays (including personal holiday) will be proportionate to the number of hours in pay status in the month to that required for full-time employment, excluding all holiday hours. Pay status includes hours worked and time on paid leave.
Full-time employees earn eight hours of sick leave per month. Overtime eligible employees who are in pay status for less than 80 hours per month, earn a monthly proportionate to the number of hours in pay status, in the month to that required for full-time employment.
Sick leave accruals for part‑time employees will be proportionate to the number of hours in pay status, in the month to that required for full-time employment. Pay status includes hours worked, time on paid leave and paid holiday.
Full-time employees accrue vacation leave at the rates specified in WAC 357-31-165(1) or the applicable collective bargaining agreement (CBA). Full-time employees who are in pay status for less than 80 nonovertime hours in a month do not earn a monthly accrual of vacation leave.
Part‑time employees accrue vacation leave hours in accordance with WAC 357-31-165(1) or the applicable collective bargaining agreement (CBA) on a pro‑rata basis. Vacation leave accrual will be proportionate to the number of hours in pay status, in the month to that required for full‑time employment.
Pay status includes hours worked, time on paid leave and paid holiday.
As provided in WAC 357-58-175, an employer may authorize a lump‑sum accrual of vacation leave or accelerate the vacation leave accrual rate to support the recruitment and/or retention of a candidate or employee for a Washington Management Service position. Vacation leave accrual rates may only be accelerated using the rates established WAC 357-31-165.
Note: Most agencies follow the civil service rules covering leave and holidays for exempt employees even though there is no requirement for them to do so. However, agencies are required to adhere to the applicable RCWs pertaining holidays and leave.
Washington State supports members of the armed forces with 21 days paid military leave per year.
Most employees whose family member or household member dies, or for loss of pregnancy, are entitled to five (5) days of paid bereavement leave. In addition, the employer may approve other available leave types for the purpose of bereavement leave.
Leave Sharing
Parental Leave
Family and Medical Leave Act (FMLA)
Leave Without Pay
Please visit the State HR Website for more detailed information regarding benefits.
Updated 01-07-2026
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
