Salary : $93,804.00 - $123,084.00 Annually
Location : Thurston County - Olympia, WA
Job Type: Exempt
Job Number: 2026-51
Department: Administrative Office of the Courts
Opening Date: 06/09/2026
Closing Date: 6/23/2026 11:59 PM Pacific

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
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

Duties

• 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.

Qualifications
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.

Supplemental Information
HOW TO APPLY
For more information about the position, to review the job description, application submission requirements, supplemental questions, inquire about benefits, or to apply for the position:
IMPORTANT INFORMATION

• 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.

More than Just a Paycheck!
Employee benefits are not just about the kind of services you get, they are also about how much you may have to pay out of pocket. Washington State offers one of the most competitive benefits packages in the nation.

We understand that your life revolves around more than just your career. Like everyone, your first priority is ensuring that you and your family will maintain health and financial security. That's why choice is a key component of our benefits package. We have a selection of health and retirement plans, paid leave, staff training and other compensation benefits that you can mix and match to meet your current and future needs.

Read about our benefits:
The following information describes typical benefits available for full-time employees who are expected to work more than six months. Actual benefits may vary by appointment type or be prorated for other than full-time work (e.g. part-time); view the job posting for benefits details for job types other than full-time.

Note: If the position offers benefits which differ from the following, the job posting should include the specific benefits.

Insurance Benefits
Employees and their families are covered by medical (including vision), dental and basic life insurance. There are multiple medical plans with affordable monthly premiums that offer coverage throughout the state.

Staff are eligible to enroll each year in a medical flexible spending account which enables them to use tax-deferred dollars toward their health care expenses. Employees are also covered by basic life and long-term disability insurance, with the option to purchase additional coverage amounts.

To view premium rates, coverage choice in your area and how to enroll, please visit the Public Employees Benefits Board (PEBB) website. The Washington Wellness program from the Health Care Authority works with PEBB to support our workplace wellness programs.

Dependent care assistance allows the employee to save pre-tax dollars for a child or elder care expenses.

Other insurance coverage for auto, boat, home, and renter insurance is available through payroll deduction.

The Washington State Employee Assistance Program promotes the health and well-being of employees.

Retirement and Deferred Compensation
State Employees are members of the Washington Public Employees' Retirement System (PERS). New employees have the option of two employer contributed retirement programs. For additional information, check out the Department of Retirement Systems' web site.

Employees also have the ability to participate in the Deferred Compensation Program (DCP). This is a supplemental retirement savings program (similar to an IRA) that allows you control over the amount of pre-tax salary dollars you defer as well as the flexibility to choose between multiple investment options.

Social Security
All state employees are covered by the federal Social Security and Medicare systems. The state and the employee pay an equal amount into the system.

Public Service Loan Forgiveness
If you are employed by a government or not-for-profit organization, and meet the qualifying criteria, you may be eligible to receive student loan forgiveness under the Public Service Loan Forgiveness Program.

Holidays
Full-time and part-time employees are entitled to paid holidays and one paid personal holiday per calendar year.

Note: Employees who are members of certain Unions may be entitled to additional personal leave day(s), please refer to position specific Collective Bargaining Agreements for more information.

Full-time employees who work full monthly schedules qualify for holiday compensation if they are employed before the holiday and are in pay status for at least 80 nonovertime hours during the month of the holiday; or for the entire work shift preceding the holiday.

Part-time employees who are in pay status during the month of the holiday qualify for the holiday on a pro-rata basis. Compensation for holidays (including personal holiday) will be proportionate to the number of hours in pay status in the month to that required for full-time employment, excluding all holiday hours. Pay status includes hours worked and time on paid leave.

Sick Leave
Full-time employees earn eight hours of sick leave per month. Overtime eligible employees who are in pay status for less than 80 hours per month, earn a monthly proportionate to the number of hours in pay status, in the month to that required for full-time employment. Overtime exempt employees who are in pay status for less than 80 hours per month do not earn a monthly accrual of sick leave.

Sick leave accruals for part-time employees will be proportionate to the number of hours in pay status, i