Job 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. Washington Courts Employment Opportunity Administrative Office of the
Courts Senior Data Management Specialist Information Services Division Our Mission :
To advance the timely, effective, and equitable operations of the Washington State judicial branch. The Administrative Office of the Courts (AOC) is looking for top-performing employees who embody its core values integrity, inclusion, accountability, and teamwork . It is committed to both employee growth and work-life balance. Our diversity and inclusion efforts include embracing different cultures, backgrounds, and perspectives while fostering growth and advancement in the workplace. POSITION DETAILS
Job # : 2026-51 Status :
Regular, Full-Time Location :
Olympia, Washington Salary :
Range 72: $93,804 - $123,084 per year (DOQ). Opens :
June 9, 2026 Closes :
June 23, 2026. AOC reserves the right to close the recruitment at any time but no sooner than seven calendar days after posting. WASHINGTON STATE RESIDENCY AND TELEWORK INFORMATION AOC
requires employees to reside in Washington State. Any exceptions must be approved. If you are invited to interview and currently reside outside of Washington State, seek more information about residency requirements from the AOC hiring manager of this recruitment. This position requires at least 2 days per week working onsite at AOC facilities 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. 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. The workweek may fluctuate depending on workload or agency needs. Overnight travel may be required based on business needs. This position is not overtime eligible. The AOC is an equal opportunity employer and does not discriminate based on gender, pregnancy, race, color, national origin, ancestry, religion, creed, physical, mental or sensory disability (actual or perceived), use of a service animal, marital status, sexual orientation, gender identity or expression, veteran or military status, age, HIV or Hepatitis C status, or any other basis protected by federal or state law. Persons of disability needing assistance in the application process, or those needing this announcement in an alternative format, please contact the AOC Human Resource Office, at (360) 704-4143, or fax (360) 586-4409, or via email to Recruitment@courts.wa.gov . Candidates who are offered a job with AOC must possess work authorization that does not require sponsorship by the employer for a visa now or in the future. 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.
