> Markdown version of [/jobs/ext/973209-senior-data-management-specialist](https://www.wearedevelopers.com/jobs/ext/973209-senior-data-management-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Data Management Specialist - **Company:** State of Washington - **Location:** Olympia, WA, United States (Remote available) - **Experience:** Expert - **Salary:** $93,804.0 - $123,084.0 - **Contract:** Permanent contract - **Skills:** Microsoft Word, Microsoft Windows, Application Integration Architecture, Automation of Tests, Microsoft Azure, Microsoft Outlook, Code Review, Information Systems, Databases, Data Cleansing, Data Integration, Extract Transform Load (ETL), Data Stores, Database Design, Microsoft OneNote, Microsoft PowerPoint, Systems Development Life Cycle, Software Engineering, SQL Stored Procedures, SQL Databases, Data Processing, Enterprise Software Applications, Informatica Powercenter, Information Technology, Data Management, Database View - **Published:** June 11, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=15d932b1ef2eef3e ## About the Role Do you have a Bachelor's degree?, A combination of education and experience demonstrating a working knowledge of the duties, responsibilities and competencies of the Senior Software Developer may substitute for the qualifications listed. A Bachelor's degree in Information Technology, Computer Science, OR closely allied field, AND: * Eight (8) years of experience in a complex information technology environment TO INCLUDE: + Five (5) years of experience using modern ETL and data cleansing tools, such as: Informatica PowerCenter Designer, Informatica PowerCenter Workflow Manager, Informatica PowerCenter Workflow Monitor, Informatica PowerCenter Repository, and/or SQL 2012 or higher programmable objects. THE IDEAL APPLICANT WILL ALSO HAVE SOME OR ALL OF THE FOLLOWING EXPERIENCE, EDUCATION, KNOWLEDGE, SKILLS, AND ABILITIES * Advanced knowledge of data modeling and database design at the conceptual, logical, and physical level. * Experience in modern ETL and data quality tools while working in a environment of great technical complexity. * Significant working experience using modern source control tools, such as Azure DevOps. * Capable of evaluating and making recommendations related to improving ETL and data cleaning components utilized in the enterprise application databases and overall information delivery solutions. * Capable of translating the most complex business and functional requirements into detailed technical designs and the delivery of ETL processes according to specification, participating with business analysts to gather requirements, and producing technical specifications. * Advanced skills in ETL methodologies and data manipulation requiring highly complex database coding. * Expertise in the integration of data cleansing services into ETL processes to satisfy the needs of the business community. * Ability to create workflows based on business specifications. * In-depth knowledge of the SDLC sufficient to effectively lead code reviews with the development team as needed. * Perform system, regression, and user acceptance testing using both manual and automated test processes with all assignments and work products being delivered. * Ability to understand customer expectations and meet those expectations. * Ability to identify, analyze, and resolve problems in a consultative manner bringing problems together with recommendations for solutions. * Ability to understand the overall impact of the enterprise to independently manage high-risk, high- profile initiatives impacting services. ## Description The Senior Data Management Specialist is responsible for leading and overseeing the analysis, collection, sorting, and creation of electronic data for the integration of applications, software, systems, and associated workflow processes into the information systems serving the needs of the Washington State courts. This position provides senior-level expertise to all data management functions., * Leads the technical team on strategic data loading, synchronization, and data quality processing projects to meet organizational business objectives. * Develops overall strategies to guide the design of Extract/Transform/Load (ETL) processes to support internal enterprise applications, and designs, constructs, tests, optimizes, and deploys these processes. * Provides directions to more junior data management specialists on all Software Development Life Cycle (SDLC) phases related to the definition, design, development, and implementation of new subject areas for enterprise application databases. * Creates highly complex ETL workflows from data sources to data stores. * Develops ETL processes using various tools in the most complex portions of the agency's data environment. * Develops optimized stored procedures, functions, and database views. * Ensures all data flow diagrams created and maintained for all ETL processes adhere to established standards and practices. * Creates and maintains detailed source-to-target ETL mapping specifications. * Leads efforts in defining database requirements, analyzing existing models, and reports looking for opportunities to improve their efficiency, and resolving technical problems. * Translates highly complex business requirements into application designs and solutions. * Proficient in utilizing Microsoft 365 products, including Teams, Outlook, Word, OneNote, PowerPoint, and others, with expertise appropriate to the responsibilities of the role. * Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds. * Conducts reviews of other data management specialists' work products. * Communicates data problems and issues to key stakeholders, including both technical and business end users. * Responds to customer service requests and provides senior-level troubleshooting, problem resolution and consulting. * May perform lead duties for a workgroup. These duties may include resolving procedure or workflow conflicts, providing input to the manager regarding managerial issues, and informing the manager of needs, issues, and concerns. * Performs other duties as assigned., AOC complies with the employment eligibility verification requirements of the federal government eligibility verification form I-9. The selected candidate must be able to provide proof of identify and eligibility to work in the United States consistent with the requirements for that form. AOC does not use E-verify; therefore, we are not eligible to extend STEM-Optional Practice Training (OPT). For information, please visit www.uscis.gov Persons legally authorized to work in the U.S. under federal law, including Deferred Action for Childhood Arrivals recipients, are eligible for employment unless prohibited by other state or federal law. SPECIAL NOTE: Before a new hire, a background check, including criminal history, will 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. ## Related Videos - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Are Code Reviews Worth It? Insights from 16 Years of Review Data](https://www.wearedevelopers.com/videos/1135-are-code-reviews-worth-it-insights-from-16-years-of-review-data) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) ## Related Articles - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)