Washington State Department of Social and Health Services
DSHS FTAA IT Data Management - Senior/Specialist
Washington State Department of Social and Health Services, Olympia, Washington, United States, 98502
Overview
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). 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. Responsibilities
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 Qualifications
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 OR 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 The Following Required Experience May Have Been Obtained Concurrently
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 How to Apply
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. Equal Opportunity
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, veteran status, disability, 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. Supplemental Information: Prior to a new hire, a background check including criminal history may be conducted. This announcement may be used to fill multiple vacancies. Employees driving on state business must have a valid driver’s license. 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 protected characteristics as defined by law.
#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). 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. Responsibilities
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 Qualifications
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 OR 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 The Following Required Experience May Have Been Obtained Concurrently
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 How to Apply
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. Equal Opportunity
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, veteran status, disability, 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. Supplemental Information: Prior to a new hire, a background check including criminal history may be conducted. This announcement may be used to fill multiple vacancies. Employees driving on state business must have a valid driver’s license. 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 protected characteristics as defined by law.
#J-18808-Ljbffr