DSHS FTAA IT Data Management - Senior Specialist

Salary : $94,620.00 - $127,248.00 Annually
Location : Thurston County - Olympia, WA
Job Type: Full Time - Permanent
Job Number: 2026-07767
Department: Dept. of Social and Health Services
Division: FTAA
Opening Date: 09/22/2026
Closing Date: 9/29/2026 11:59 PM Pacific
Salary Information: The high end of the salary range, Step M is typically a longevity step

Description
DSHS FTAA Epic Senior Business Intelligent Analyst

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

Please include the following:

• 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

Questions? Please contact and reference #07767.
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.

Supplemental Information
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 . Applicants who are deaf or hard of hearing may call through Washington Relay Service by dialing 7-1-1 or 1-.

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 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
More than Just a Paycheck!
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.

Read about our benefits:
The following information describes typical benefits available for full-time employees who are expected to work more than six months. Actual benefits may vary by appointment type or be prorated for other than full-time work (e.g. part-time); view the job posting for benefits details for job types other than full-time.

Note: If the position offers benefits which differ from the following, the job posting should include the specific benefits.

Insurance Benefits
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.

Retirement and Deferred Compensation
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.

Social Security
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.

Public Service Loan Forgiveness
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.

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

Sick 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. Overtime exempt employees who are in pay status for less than 80 hours per month do not earn a monthly accrual of sick leave.

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.

Vacation (Annual Leave)
Full-time employees accrue vacation leave at the rates specified in (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 (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 , 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.

Military Leave
Washington State supports members of the armed forces with 21 days paid military leave per year.

Bereavement Leave
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.

Additional Leave
Leave Sharing

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