Senior Data Migration Specialist

About the Department

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 Project 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 Senior Data Migration Specialist (Senior Data Management Specialist) Courts of Limited Jurisdiction – Case Management System (CLJ-CMS Project)  Information Services Division

Our Mission: To advance the timely, effective, and equitable operations of the Washington State judicial branch.

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 #: 2026-70

Status: Project – Limited Duration, Full-Time* 

Location: Olympia, Washington

Salary: Range 72: $95,676 - $125,544 per year (DOQ).  

Opens:  August 5, 2026

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

*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

Position Duties

Minimum Qualifications

A combination of education and experience demonstrating a working knowledge of the duties, responsibilities and competencies of the Senior Data Migration Specialist 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:

Other Qualifications

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: CLICK HERE TO APPLY

IMPORTANT INFORMATION

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, citizenship or immigration 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-4143, or fax (360) 586-4409, or via email to [email protected]. 

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

Benefits

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, in the month to that required for full-time employment. Pay status includes hours worked, time on paid leave and paid holiday.

Vacation (Annual Leave)
Full-time employees accrue vacation leave at the rates specified in WAC 357-31-165(1) or the applicable collective bargaining agreement (CBA). Full-time employees who are in pay status for less than 80 nonovertime hours in a month do not earn a monthly accrual of vacation leave.

Part-time employees accrue vacation leave hours in accordance with WAC 357-31-165(1) or the applicable collective bargaining agreement (CBA) on a pro rata basis. Vacation leave accrual will be proportionate to the number of hours in pay status, in the month to that required for full-time employment.

Pay status includes hours worked, time on paid leave and paid holiday.

As provided in WAC 357-58-175, an employer may authorize a lump-sum accrual of vacation leave or accelerate the vacation leave accrual rate to support the recruitment and/or retention of a candidate or employee for a Washington Management Service position. Vacation leave accrual rates may only be accelerated using the rates established WAC 357-31-165.  

Note: Most agencies follow the civil service rules covering leave and holidays for exempt employees even though there is no requirement for them to do so. However, agencies are required to adhere to the applicable RCWs pertaining holidays and leave.

Military Leave
Washington State supports members of the armed forces with 21 days paid military leave per year.

Bereavement Leave 
Most employees whose family member or household member dies, or for loss of pregnancy, are entitled to five (5) days of paid bereavement leave. In addition, the employer may approve other available leave types for the purpose of bereavement leave.

Additional Leave
Leave Sharing
Parental Leave
Family and Medical Leave Act (FMLA)
Leave Without Pay

Please visit the State HR Website for more detailed information regarding benefits.

Updated 01-07-2026

Agency Information

EmployerState of WashingtonAddress View Job Posting for Agency Information

View Job Posting for Location, Washington, 98504 Website http://www.careers.wa.gov