Senior Data Management Specialist; Data Migration Specialist
Listed on 2026-01-12
-
IT/Tech
Database Administrator, IT Consultant, Data Engineer, Data Analyst
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.
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.
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.
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.
- Respond to customer service requests and provide 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.
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.
EDUCATION AND EXPERIENCEA 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 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.
- Integrity
- Inclusion
- Accountability
- Teamwork
- Proven analytical and problem‑solving…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).