Description
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 insightsenabling 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 DSHSs 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 departments 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 youll 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 Bachelors 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 Masters 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 were 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
InterestedAlong with your completed on-line application please submit:
Chronological Resume
Cover Letter
Three References
Questions Please contact or call and reference job number 07302. To learn more about DSHS go to.
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 agencys 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.
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 applicants 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 drivers 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 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-.
E-Verify is a registered trademark of the U.S. Department of Homeland Security
Required Experience:
Senior IC
DescriptionDSHS FTAA IT Data Management Senior/SpecialistWe 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 partne...
Description
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 insightsenabling 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 DSHSs 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 departments 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 youll 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 Bachelors 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 Masters 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 were 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
InterestedAlong with your completed on-line application please submit:
Chronological Resume
Cover Letter
Three References
Questions Please contact or call and reference job number 07302. To learn more about DSHS go to.
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 agencys 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.
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 applicants 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 drivers 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 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-.
E-Verify is a registered trademark of the U.S. Department of Homeland Security
Required Experience:
Senior IC
View more
View less