• Job Description

  Req#: 5307842
  Salary: $92,760.00 - $124,752.00 Annually
  Location : Thurston County - Olympia, WA
  Job Type: Full Time - Permanent
  Remote Employment: Remote Optional
  Job Number: 2026-03127
  Department: Health Care Authority
  Division: SPI
  Opening Date: 04/14/2026
  Closing Date: 4/21/2026 11:59 PM Pacific
  Salary Information: The high end of the salary range, Step M is typically a longevity step
  
  Description
  Senior Data Quality Specialist (ITDM-SS/SPI)
  
  71028833
  
  This senior data manager performs critical high-level data quality work to ensure HCA provides data and reports that align with federal requirements. This position creates new processes, develops technical documentation, and reviews data for quality. The ideal candidate will bring team and/or project leadership experience into this role that works with multiple systems and partners to troubleshoot issues and create symbiosis in data quality efforts. If you are in search of an opportunity to ensure this critical work is accurate to ensure funding for health care programs across Washington, this may be the position for you!
  
  All HCA employees will apply an equity lens to their work, which may include but is not limited to all analyses of core business and processes.
  
  About the division:
  
  The Strategy, Policy, and Innovation division (SPI) of the Health Care Authority (HCA) is statutorily directed to study all state-purchased health care, alternative health care delivery systems, and strategies for the procurement of health services, and to coordinate state agency efforts to develop and implement uniform policies across state purchased health care programs. The division is structured to provide expert direction, consultation, and support for these activities. SPI is responsible for driving policy design, development, and implementation of health reform, and health transformation activities and program development and refinements for all programs.
  
  The Chief Data Office (DATA) team is within SPI to provide data, analytics, and decision support tools to support HCA's initiatives and programs. Personnel work to provide data management, governance, and data-driven decision support applications to improve decisions about clinical quality and health care purchasing.
  
  About the position:
  
  This position coordinates with internal and external stakeholder requirements for accessing claims and eligibility information from the ProviderOne Operational Data Store (ODS) and Enterprise Data Warehouse (EDW). Serves as the primary data analyst responsible for the current Transformed Medicaid Statistical Information System (T-MSIS) and CMS-416 mandated federal reports.
  
  This position is responsible for maintaining good data quality standards of both the ProviderOne ODS and the EDW by reviewing design documents to ensure the warehouses are functioning properly, identifying any potential issues, providing recommendations to implement the best technical solution, and executes ProviderOne release testing. This position performs data analysis, develops analytical and business reports using SQL Server Reporting Services (SSRS), interface development for data exchange using SQL Server Integration Services (SSIS). The position also writes complex Oracle SQL code for ad-hoc data pulls, ad-hoc queries, Public Disclosure Requests (PDR), and Washington State Institutional Review Board (WSIRB) research requests, just to name a few.
  
  This position is eligible to telework and is typically not required to report on-site. The default assigned work location of all Health Care Authority (HCA) positions - both on-site and telework eligible positions - is within the State of Washington. This position reports to Olympia, WA. Frequency of onsite work will vary based on business and operational needs. All agency employees are required to report on-site in Olympia on their first and last days of employment to pick up and return state-issued equipment, regardless of telework status or location.
  
  Duties
  Some of what you will do:
  
  Coordinate and work with internal and external agencies and vendors for federal mandated reports (T-MSIS, CMS-416, ETC) development, maintenance, and enhancement.
  
  • Coordinate with internal and external users, vendors, and Centers for Medicare & Medicaid Services (CMS) for gathering and documenting report requirements, coding, testing, and delivering reports.
  • Responsible for all maintenance activities related to T-MSIS and CMS-416 federal reports, including working with vendor, developing automated testing platform, coordinating with other administrators, ensuring defects and issues are reported to vendor, and creating test cases, scenarios, and queries.
  
  Develop SQL to provide reports or data sets for HCA business areas, other state agencies, Washington State Institutional Review Board (WSIRB), Data Share Agreements (DSAs) or Public Disclosure Requests (PDRs).
  
  • Gather and document report or data pull requirements.
  • Develop detailed report specifications and test, maintain, and enhance complex analytical and business driven reports or data sets.
  • Perform code review and peer review.
  • Design and create web-based reports for ProviderOne business users, researchers, policy makers, and the public.
  • Automate report generation via SSIS packages or similar report automation tools.
  
  Identify and assist in finding potential data quality issues.
  
  • Conduct analysis on potential issues discovered by the Data Warehouse users.
  • Work with vendors through daily or weekly meetings, frequent e-mail, and help desk tickets to solve complex system issues and problems.
  • Coordinate and work with vendors to get issues resolved through established ProviderOne defect resolution process.
  
  Design, develop and enhance analytical and business reports using BI tools such as Power BI and SSRS.
  
  Design, develop and maintain reports and reoccurring data requests using SQL Server Integration Services (SSIS) or Data Visualization tool.
  
  Qualifications
  Required qualifications:
  
  Qualifying candidates will meet one of the following criteria options:
  
  Option 1:
  
  • Nine (9) years of progressive professional IT experience in one or more of the following IT disciplines consulting, analyzing, designing, programming, installing and/or maintaining computer software applications.
  
  Option 2:
  
  • Associate degree or equivalent and
  • Seven (7) years of progressive professional IT experience in one or more of the following IT disciplines consulting, analyzing, designing, programming, installing and/or maintaining computer software applications.
  
  Option 3:
  
  • Bachelor's degree or equivalent and
  • Five (5) years of progressive professional IT experience in one or more of the following IT disciplines consulting, analyzing, designing, programming, installing and/or maintaining computer software applications.
  
  Option 4:
  
  • Master's degree or equivalent and
  • Three (3) years of progressive professional IT experience in one or more of the following IT disciplines consulting, analyzing, designing, programming, installing and/or maintaining computer software applications.
  
  Option 5:
  
  • Three (3) years as a Journey level IT professional in state service.
  
  Required competencies:
  
  • The ability to take action to learn and grow.
  • The ability to take action to meet the needs of others.
  • Three (3) years of experience working with a large data warehouse.
  • Three (3) years of experience writing SQL code, performance tuning.
  • Two (2) years of experience developing reports using Microsoft Reporting Services (SSRS) or equivalent software.
  • Two (2) years of experience utilizing testing methodologies and developing testing platforms.
  
  Preferred qualifications:
  
  • Experience in creating reports using Power BI, Tableau, or similar BI tool software.
  • Experience working in and building software source control (e.g. GitHub)
  • Experience developing and working in Star Schema data warehouses.
  • Experience in report development, building, deploying, and troubleshooting using SQL Server Integration Services (SSIS) or equivalent software.
  • Experience with health care data.
  • Experience with the ProviderOne On-line system and data warehouses.
  • Experience with any helpdesk ticketing system.
  
  How to apply:
  
  Only candidates who reflect the minimum qualifications on their NEOGOV profile will be considered. Failure to follow the application instructions below may lead to disqualification. To apply for this position, you will need to complete your profile which includes three professional references and attach in separate files:
  
  • A cover letter that specifically addresses how you meet the qualifications for this position
  • Current resume
  
  To take advantage of veteran preference, please do the following:
  
  • Attach a copy of your DD214 (Member 4 long-form copy), NGB 22, or USDVA signed verification of service letter.
  • Please black out any PII (personally identifiable information) data such as social security numbers. Include your name as it appears on your application in careers.wa.gov.
  
  Supplemental Information
  About HCA:
  
  Functioning as both the state's largest health care purchaser and its behavioral health authority, the Washington State Health Care Authority (HCA) is a leader in ensuring Washington residents have the opportunity to be as healthy as possible.
  
  There are three pillars of our work: Apple Health (Medicaid); the Public Employees Benefits Board (PEBB) and School Employees Benefits Board (SEBB) programs; and behavioral health and recovery. Under these pillars, HCA purchases health care, including behavioral health treatment for more than 2.7 million Washington residents and provides behavioral health prevention, crisis, and recovery supports to all Washington residents.
  
  What we have to offer:
  
  • Meaningful work with friendly co-workers who care about those we serve
  • A clear agency mission that drives our work and is person-centered
  • A healthy work/life balance, including alternative/flexible schedules and mobile work options.
  • A great total compensation and benefit package
  • A safe, pleasant workplace in a convenient location with restaurants, and shopping nearby.
  • And free parking!
  
  Notes:
  
  This position is covered by the Washington Federation of State Employees (WFSE). Once the listed position(s) is(are) filled, this recruitment announcement may also be used to fill additional position(s) for up to sixty (60) days.
  
  Prior to a new hire, a background check including criminal record history will be conducted. Information from the background check will not necessarily preclude employment.
  
  HCA is an equal opportunity employer. We value the importance of creating an environment in which all employees can feel respected, included, and empowered to bring unique ideas to the agency. HCA has five employee resource groups (ERGs). ERGs are voluntary, employee-led groups whose aim is to foster a diverse, inclusive workplace aligned with HCA's mission. Our diversity and inclusion efforts include embracing different cultures, backgrounds and viewpoints while fostering growth and advancement in the workplace. Studies have shown women, racial and ethnic minorities, and persons of disability are less likely to apply for jobs unless they feel they meet every qualification as described in a job description. Persons over 40 years of age, disabled and Vietnam era veterans, as well as people of all sexual orientations and gender identities are also encouraged to apply. If you have any questions about the required qualifications or how your experience relates to them, please contact us at Persons with disabilities needing assistance in the application process, or those needing this job announcement in an alternative format may contact Jake Nelko at or 360.725.0945.
  
  The Washington State Health Care Authority (HCA) is an All applicants with a in the United States are encouraged to apply.
  E-Verify® is a registered trademark of the U.S. Department of Homeland Security.
  to receive a list of new job postings at HCA.
  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
  01
  
  Please select the highest level of education that you have completed:
  • High school graduation or equivalent
  • Associate degree
  • Bachelor's degree
  • Master's degree or higher
  • None of the above
  
  02
  
  Which of the following best describes your progressive professional IT experience in one or more of the following IT disciplines consulting, analyzing, designing, programming, installing and/or maintaining computer software applications?
  • I do not have this experience.
  • Less than 3 years
  • More than 3 years, but less than 5 years
  • More than 5 years, but less than 7 years
  • More than 7 years, but less than 9 years
  • More than 9 years
  
  03
  
  If you indicated you have the experience noted in the above question, please explain how, where, and when you gained this knowledge and experience (must be reflected in the work experience of your application). Do not state "see resume" or copy and paste that material. If you answered no, please type N/A in the text box below.
  04
  
  Which of the following best describes your professional work experience as a Journey level IT professional in state service?
  • I do not have this experience.
  • Less than 1 year
  • More than 1 year, but less than 2 years
  • More than 2 years, but less than 3 years
  • More than 3 years
  
  05
  
  Do you have the ability to take action to learn and grow?
  • Yes
  • No
  
  06
  
  Do you have the ability to take action to meet the needs of others?
  • Yes
  • No
  
  07
  
  Which of the following best describes your professional work experience working with a large data warehouse?
  • I do not have this experience.
  • Less than 3 years
  • More than 3 years
  
  08
  
  Which of the following best describes your professional work experience writing SQL code, performance tuning?
  • I do not have this experience.
  • Less than 3 years
  • More than 3 years
  
  09
  
  Which of the following best describes your professional work experience developing reports using Microsoft Reporting Services (SSRS) or equivalent software?
  • I do not have this experience
  • Less than 2 years
  • More than 2 years
  
  10
  
  Which of the following best describes your professional experience utilizing testing methodologies and developing testing platforms?
  • I do not have this experience.
  • Less than 2 years
  • More than 2 years
  
  11
  
  Which of the following best describes your professional experience in creating reports using Power BI, Tableau, or similar BI tool software?
  • I do not have this experience
  • Less than 1 year
  • More than 1 year, but less than 2 years
  • More than 2 years, but less than 3 years
  • More than 3 years, but less than 4 years
  • More than 4 years, but less than 5 years
  • More than 5 years
  
  12
  
  Which of the following best describes your professional experience working in and building software source control (e.g. GitHub)?
  • I do not have this experience
  • Less than 1 year
  • More than 1 year, but less than 2 years
  • More than 2 years, but less than 3 years
  • More than 3 years, but less than 4 years
  • More than 4 years, but less than 5 years
  • More than 5 years
  
  13
  
  Which of the following best describes your professional experience developing and working in Star Schema data warehouses?
  • I do not have this experience
  • Less than 1 year
  • More than 1 year, but less than 2 years
  • More than 2 years, but less than 3 years
  • More than 3 years, but less than 4 years
  • More than 4 years, but less than 5 years
  • More than 5 years
  
  14
  
  Which of the following best describes your professional work experience in report development, building, deploying, and troubleshooting using SQL Server Integration Services (SSIS) or equivalent software?
  • I do not have this experience.
  • Less than 1 year
  • More than 1 year, but less than 2 years
  • More than 2 years, but less than 3 years
  • More than 3 years, but less than 4 years
  • More than 4 years, but less than 5 years
  • More than 5 years
  
  15
  
  Which of the following best describes your professional work experience with health care data?
  • I do not have this experience.
  • Less than 1 year
  • More than 1 year, but less than 2 years
  • More than 2 years, but less than 3 years
  • More than 3 years, but less than 4 years
  • More than 4 years, but less than 5 years
  • More than 5 years
  
  16
  
  I acknowledge that I have included at least three references, and that I have uploaded a cover letter and resume in the attachments section of my application.
  • Yes
  • No
  
  17
  
  If hired for this position, do you currently possess required documents to allow you to legally work within the United States? The attached link lists acceptable documents: https://www.uscis.gov/i-9-central/form-i-9-acceptable-documents
  • Yes
  • No
  
  18
  
  Will you require sponsorship for an employment-related immigration benefit, either now or in the future?
  • Yes
  • No
  
  Required Question

• About the company

  The best remote jobs for you

Notice