Data Management Specialist

The Data Management Specialist is responsible for analyzing, collecting, sorting, and creating 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 journey-level expertise in all data management functions.

Advance the efficient and effective operation of the Washington Judicial System.

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.

Job #: 2026-15

Status
:
Regular, Full-Time*

Location
:
Olympia, Washington

Salary
:
Range 68: $84,984 - $111,504 per year (DOQ).

Opens
:
February 27, 2026

Closes
:
March 20, 2026. AOC reserves the right to close the recruitment at any time but no sooner than seven calendar days after posting.

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

• Serves as technical resource on strategic data loading, synchronization, and data quality processing projects to meet organizational business objectives.
• Designs, constructs, tests, optimizes, and deploy Extract/Transform/Load (ETL) processes to support internal enterprise applications.
• Conducts all Software Development Life Cycle (SDLC) phases related to the definition, design, development, and implementation of new subject areas for enterprise application databases.
• Creates ETL workflows from data sources to data stores.
• Develops ETL processes using various tools in a complex data environment.
• Develops optimized SQL Server stored procedures, functions, and database views for use in applications, jobs, and ETL workflows.
• Creates and maintains data flow diagrams for existing and future ETL processes.
• Creates and maintains detailed source-to-target ETL mapping specifications.
• Participates in defining database requirements, analyzing existing models and reports looking for opportunities to improve their efficiency, and resolving technical problems.
• Translates business requirements into application designs and solutions.
• Conducts ETL audits and implements controls to ensure quality of data meets or exceeds defined standards and thresholds.
• Responds to customer service requests and provides journey-level troubleshooting, problem resolution and consulting.
• Conduct 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.
• Performs other duties as assigned.

A combination of education and experience demonstrating a working knowledge of the duties, responsibilities and competencies of the Software Developer may substitute for the qualifications listed.

A Bachelor’s degree in Information Technology, Computer Science, or a closely allied field, AND:

• Five (5) years of experience in a complex information technology environment, TO INCLUDE:
• Three (3) years of experience using modern ETL and data cleansing tools, such as Informatica Power Center Designer, Informatica Power Center Workflow Manager, Informatica Power Center Workflow Monitor, Informatica Power Center Repository, and/or SQL 2012 or higher programmable objects.

• Knowledge of data modeling and database design at the conceptual, logical, and physical level.
• Experience in modern ETL and data quality tools.
• Working experience using modern source control tools, such…