Senior Data Management Specialist

Range: $93,804 - $123,084 per year (DOQ)

Salary: $93,804.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: 06/23/2026 11:59 PM Pacific

The Senior Data Management Specialist leads and oversees the analysis, collection, sorting, and creation of electronic data for integration of applications, software systems, and workflow processes into the Washington State courts information systems, providing senior-level expertise to all data management functions.

• Lead technical team on strategic data loading, synchronization, and data quality processing projects.
• Develop overall strategies for design of ETL processes and design, construct, test, optimize, and deploy them.
• Provide guidance to junior data management specialists on all SDLC phases related to new subject areas for enterprise application databases.
• Create highly complex ETL workflows from data sources to data stores.
• Develop ETL processes using various tools in the agency's complex data environment.
• Develop optimized stored procedures, functions, and database views.
• Ensure all data flow diagrams for ETL processes adhere to standards and practices.
• Maintain detailed source-to-target ETL mapping specifications.
• Lead efforts to define database requirements, analyze existing models, and identify opportunities for improvement.
• Translate complex business requirements into application designs and solutions.
• Utilize Microsoft 365 products including Teams, Outlook, Word, One Note, PowerPoint.
• Develop ETL audits and controls to ensure data quality meets or exceeds defined standards.
• Conduct reviews of other data management specialists' work products.
• Communicate data problems and issues to stakeholders.
• Respond to customer service requests with senior-level troubleshooting, problem resolution and consulting.
• May perform lead duties for a workgroup, resolving procedure or workflow conflicts and informing manager of needs.
• Perform other duties as assigned.

• Bachelor's degree in Information Technology, Computer Science, or closely allied field.
• Eight (8) years of experience in a complex information technology environment, including:

• Five (5) years of experience using modern ETL and data cleansing tools such as Informatica Power Center and SQL 2012 or higher.

• Advanced knowledge of data modeling and database design at conceptual, logical, and physical levels.
• Experience with modern ETL and data quality tools in a technically complex environment.
• Experience with modern source control tools such as Azure Dev Ops.
• Ability to evaluate and recommend improvements to ETL and data cleaning components.
• Ability to translate complex business requirements into detailed technical designs.
• Advanced skills in ETL methodologies and complex database coding.
• Expertise in integrating data cleansing services into ETL processes.
• Ability to create workflows based on business specifications.
• Knowledge of the SDLC sufficient to lead code reviews.
• Experience conducting system, regression, and user acceptance testing.
• Strong communication and problem resolution skills.

• Must reside in Washington State or have exceptions approved.
• At least 2 days per week onsite at AOC facilities.

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.

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