Senior Data Management Specialist

Salary : $93,804.00 - $123,084.00 Annually
Location : Olympia, WA
Job Type: PROJECT-Funded: Full-Time
Job Number: 2025-81
Division: Information Services Division
Department: CLJ-CMS Project (I11)
Opening Date: 01/08/2026
Closing Date: 1/22/2026 11:59 PM Pacific

Position Profile
Join a high performing team in support of a transformational software replacement project for the Washington Courts of Limited Jurisdiction (District and Municipal Courts). We are replacing a legacy Case Management System with a commercial-off-the-shelf (COTS) solution to improve services for the court and probation customers of AOC.
The Courts of Limited Jurisdiction (CLJ-CMS) project is seeking an experienced Data Migration Specialist to join a high-performing team of technical specialists. This position will work with the project's Business Analysts and Vendor to identify field level data mapping, migrate data from SQL Server and other data sources and convert it over to the COTS products.

This position is responsible for designing, testing, and executing data conversion routines to migrate data from legacy databases into the new COTS database using current ETL tools and best practices. The successful candidate will create and implement automated validation routines to report on and ensure that data quality, integrity, and completeness are maintained. This position will participate in design reviews of high risk, high impact statewide systems and services.
Reporting to the CLJ-CMS IT Supervisor, this senior-level position is expected to work independently and has decision making responsibility commensurate with the role.
Washington Courts Employment Opportunity

Administrative Office of the Courts
Data Migration Specialist

(Senior Data Management Specialist)

Courts of Limited Jurisdiction - Case Management System (CLJ-CMS Project)
Information Services Division
Our Mission: 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.
POSITION DETAILS
Job #: 2025-81

Status: Project - Limited Duration, Full-Time*

Location: Olympia, Washington

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

Opens: January 8, 2026

Closes: January 22, 2026 at 12:00 AM. AOC reserves the right to close the recruitment at any time but no sooner than seven calendar days after posting. If you applied to this position in the last few months there is no need to reapply.
*Duration: This is a CLJ-CMS project position that is currently funded through December 31, 2027.
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 two (2) days per week working onsite at AOC facilities

Duties and Responsibilities

• Work with project and agency business analysts and technical staff as well as vendor resources to identify field level data mapping, moving data from SQL Server and other data sources and converting it into the COTS products.
• Responsible for designing, testing, and executing data conversion routines to migrate data from legacy databases into the new COTS database using current ETL tools and best practices.
• Create and implement automated validation routines to ensure that data quality, integrity, and completeness are maintained; provide reports as requested.
• Participate in design reviews of high risk, high impact statewide systems and services.
• Responds to customer service requests and provides expert level troubleshooting, problem resolution and consulting.
• Participates in design reviews of high risk, high impact statewide systems and services.
• Reviews and evaluates work products for accuracy and applicability.
• Performs duties as required.

Qualifications and Credentials
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
Demonstrates Agency Values:

• Integrity
• Inclusion
• Accountability
• Teamwork

Behavioral Competencies:

• Proven analytical and problem-solving abilities.
• Strong leadership skills.
• Ability to effectively prioritize and execute tasks in a high-pressure environment.
• Good written, oral, and interpersonal communication skills.
• Ability to conduct research into data, software, and reporting solutions as required by the business.
• Ability to communicate ideas in business-friendly and user-friendly language.
• Highly self-motivated and directed.
• Keen attention to detail.
• Team-oriented and skilled in working within a collaborative environment.
• Tact/diplomacy.

Knowledge, Skills and Abilities:

• Skilled in writing SQL queries or other program languages for data verification and quality assurance purposes and creating analysis-ready data tables.
• Experienced or proficient with computer database software, analytical tools, and other programming languages, including SQL, R or Python, HTML, C#, ArcGIS, and/or other IT-related languages or applications
• Experience with Git source control and CI/CD technologies is strongly desired.
• Demonstrated experience and expertise in the following:
  • T-SQL
  • SQL Server
  • Data Conversion
  • Data Cleansing methodologies
• Experience with Extract, Transform and Load (ETL) tools strongly desired.
• Able to identify key facts in a range of data; notices when data is inaccurate, incomplete, or needs verification; distinguishes information not pertinent to a decision or solution.
• Breaks down complex information into parts. Sorts and groups data and applies relationships. Sees underlying principles, patterns, or themes in various related information.
• Detailed-oriented, strong organizational skills, and ability to multi-task in a fast-paced environment.
• Strong initiative-taker with a positive, can-do attitude, with the ability to work independently and as a team member in a fast-paced environment under tight deadlines.
• Strong commitment to trust, teamwork, and collaboration principles by demonstrating transparent communication.
• Experience creating meaningful executive-level reports and data dashboard solutions using tools like SQL Server Reporting Services (SSRS) and Power BI
• Ability to communicate effectively and professionally, both orally and in writing. Must possess the ability to communicate technical information to lay audiences using plain language and communicate effectively and efficiently with skilled technical staff.
• Interpersonal skills to work across divisions and ability to cultivate and maintain effective professional working relationships with co-workers, customers and clients.
• Ability to learn new concepts and skills, absorb and retain new information quickly.

Supplemental Information
For more information about the position, to review the job description, application submission requirements, supplemental questions, inquire about benefits.
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.

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-5524, 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.
We are a team-oriented culture, and a balance of family and work-life in a wonderful community. We offer a family-friendly package of pay, benefits, paid time off, and workplace opportunities to help you get the most out of your career and life.

Our compensation plan includes:

• Health, Dental, and Vision Plans
• Retirement Plan Options
• Deferred Compensation Plan
• Paid Time Off (Vacation, Sick Leave and Holidays)
• Paid Basic Life Insurance Policy and Long Term Disability Insurance
• Employee Assistance Program
• Flexible Spending Account and Dependent Care Assistance Program
• Public Service Loan Forgiveness

Part-time employees will receive benefits on a pro-rated basis.

To learn more details about all we have to offer, visit the benefits page at
01

Do you hold a Bachelor's degree in Information Technology, Computer Science, OR closely allied field?

• Yes
• No

02

Do you have at least eight (8) years of experience in a complex information technology environment including at least 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?

• Yes
• No

03

Supplemental Question from Question Two (2): Please describe your education and experience in regards to the qualification of this position.
04

This position requires working onsite at least two (2) days per week at the AOC office in Olympia, Washington. Are you still interested in applying for this position?

• Yes
• No

Required Question

---