State of Washington
DSHS FTAA IT Data Management - Senior/Specialist
State of Washington, Olympia, Washington, United States, 98502
DSHS FTAA IT Data Management Senior/Specialist
We are seeking a Senior IT Data Management Specialist to join the Business Intelligence Unit (BIU) within the Research and Data Analysis Division (RDA) at the Department of Social and Health Services (DSHS).
Our BIU mission is to empower partners across the agency by transforming raw data into trusted, well-governed, and actionable insights—enabling effective data exploration, analysis, and decision‑making that support problem‑solving, risk management, continuous improvement, and strategic outcomes.
In this role, you will play a critical part in advancing DSHS’s enterprise data management and analytics capabilities. Reporting to the BIU Manager, you will lead efforts to strengthen data governance, improve data quality and interoperability, and manage complex data integration and transformation processes across multiple systems and platforms. You will ensure that data assets are accessible, reliable, and secure to support the department’s analytical and reporting initiatives.
This is a senior technical position that bridges business intelligence, data architecture, and governance disciplines. The ideal candidate has a strategic mindset, excels in collaboration across diverse teams, and brings a passion for building sustainable, enterprise‑scale data solutions.
Some of what you’ll do:
Design and manage ETL solutions across on‑premises and cloud environments to support enterprise data integration
Develop and maintain pipelines and SQL‑based transformations for fact and dimension models
Build and optimize Power BI semantic models to deliver scalable and reusable reporting datasets
Create and maintain database objects such as stored procedures, views, and functions to support complex business needs
Implement and document data architecture through ERDs and metadata to ensure consistency and transparency
Collaborate across programs and state agencies (e.g., DSHS, EQUITY, HCA, DCYF) to ensure data alignment and interoperability
Monitor, test, and troubleshoot data flows to maintain performance, reliability, and accuracy
Apply data governance, privacy, and security standards in compliance with state and federal requirements
Utilize Azure DevOps for version control, deployment pipelines, documentation, and sprint‑based project tracking
Provide technical guidance and promote best practices in enterprise data management and integration
Who should apply:
A Bachelor’s degree including 9 semester or 15 quarter hours of computer science courses and 7 years of consultative, administrative, or supervisory experience in information technology analysis, system maintenance, or troubleshooting/problem resolution experience, or analyzing, designing, or programming computer systems applications or databases
11 years of consultative, administrative, or supervisor experience in information technology analysis, system maintenance, or troubleshooting/problem resolution experience, or analyzing, designing, or programming computer systems applications or databases
A Master’s degree will substitute for one year of the required experience
Five years of progressively responsible experience in a lead role is required due to the enterprise nature of assignments. This experience could be through performance of direct supervisory function for staff, direct management of contracted resources or matrix management of staff resources for a project or similar endeavor.
What we’re looking for:
Experience developing dashboards using Business Intelligence tools
Experience with data warehouse methodologies, such as Kimball
Extensive knowledge of coding languages, including Java, XML, and SQL
Proven work experience as an ETL developer
Interested?
Chronological Resume
Cover Letter
Three References
Questions?
Please contact sharon.sterling@dshs.wa.gov or call 360-725-5810 and reference job number 07302. To learn more about DSHS, go to www.dshs.wa.gov.
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 an equity, anti‑racism, and social justice commitment to your work with DSHS. We strive to create greater access and affirming representation of the communities we serve, 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 (360) 725-5810. Applicants who are deaf or hard of hearing may call through Washington Relay Service by dialing 7-1-1 or 1-800-833-6384.
E-Verify® is a registered trademark of the U.S. Department of Homeland Security
#J-18808-Ljbffr
We are seeking a Senior IT Data Management Specialist to join the Business Intelligence Unit (BIU) within the Research and Data Analysis Division (RDA) at the Department of Social and Health Services (DSHS).
Our BIU mission is to empower partners across the agency by transforming raw data into trusted, well-governed, and actionable insights—enabling effective data exploration, analysis, and decision‑making that support problem‑solving, risk management, continuous improvement, and strategic outcomes.
In this role, you will play a critical part in advancing DSHS’s enterprise data management and analytics capabilities. Reporting to the BIU Manager, you will lead efforts to strengthen data governance, improve data quality and interoperability, and manage complex data integration and transformation processes across multiple systems and platforms. You will ensure that data assets are accessible, reliable, and secure to support the department’s analytical and reporting initiatives.
This is a senior technical position that bridges business intelligence, data architecture, and governance disciplines. The ideal candidate has a strategic mindset, excels in collaboration across diverse teams, and brings a passion for building sustainable, enterprise‑scale data solutions.
Some of what you’ll do:
Design and manage ETL solutions across on‑premises and cloud environments to support enterprise data integration
Develop and maintain pipelines and SQL‑based transformations for fact and dimension models
Build and optimize Power BI semantic models to deliver scalable and reusable reporting datasets
Create and maintain database objects such as stored procedures, views, and functions to support complex business needs
Implement and document data architecture through ERDs and metadata to ensure consistency and transparency
Collaborate across programs and state agencies (e.g., DSHS, EQUITY, HCA, DCYF) to ensure data alignment and interoperability
Monitor, test, and troubleshoot data flows to maintain performance, reliability, and accuracy
Apply data governance, privacy, and security standards in compliance with state and federal requirements
Utilize Azure DevOps for version control, deployment pipelines, documentation, and sprint‑based project tracking
Provide technical guidance and promote best practices in enterprise data management and integration
Who should apply:
A Bachelor’s degree including 9 semester or 15 quarter hours of computer science courses and 7 years of consultative, administrative, or supervisory experience in information technology analysis, system maintenance, or troubleshooting/problem resolution experience, or analyzing, designing, or programming computer systems applications or databases
11 years of consultative, administrative, or supervisor experience in information technology analysis, system maintenance, or troubleshooting/problem resolution experience, or analyzing, designing, or programming computer systems applications or databases
A Master’s degree will substitute for one year of the required experience
Five years of progressively responsible experience in a lead role is required due to the enterprise nature of assignments. This experience could be through performance of direct supervisory function for staff, direct management of contracted resources or matrix management of staff resources for a project or similar endeavor.
What we’re looking for:
Experience developing dashboards using Business Intelligence tools
Experience with data warehouse methodologies, such as Kimball
Extensive knowledge of coding languages, including Java, XML, and SQL
Proven work experience as an ETL developer
Interested?
Chronological Resume
Cover Letter
Three References
Questions?
Please contact sharon.sterling@dshs.wa.gov or call 360-725-5810 and reference job number 07302. To learn more about DSHS, go to www.dshs.wa.gov.
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 an equity, anti‑racism, and social justice commitment to your work with DSHS. We strive to create greater access and affirming representation of the communities we serve, 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 (360) 725-5810. Applicants who are deaf or hard of hearing may call through Washington Relay Service by dialing 7-1-1 or 1-800-833-6384.
E-Verify® is a registered trademark of the U.S. Department of Homeland Security
#J-18808-Ljbffr