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.

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 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 as Azure Dev Ops.
• Capable of implementing improved ETL and data cleaning components utilized in the enterprise application databases and overall information delivery solutions.
• Capable of translating 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.
• Skilled in ETL methodologies and data manipulation requiring complex database coding.
• Ability to integrate data cleansing services into ETL processes to satisfy the needs of the business community.
• Proficient in utilizing Microsoft 365 products, including Teams, Outlook, Word, Excel, PowerPoint, and others, with expertise appropriate to the responsibilities of the role.
• Ability to create workflows based on business specifications.
• 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 in order to independently manage high-risk, high-profile initiatives impacting services.

For more information about the position, review the job description, application…