What are the responsibilities and job description for the Data Migration Specialist position at Administrative Office of the Courts?
JOB
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 a Data Migration Specialist. Responsibilities include working with the project’s Business Analysts and the Vendor to identify the field level data mapping, migrating the data from SQL Server and other data sources and converting 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 OpportunityAdministrative Office of the Courts Data Migration Specialist(Senior System Support Analyst)Courts of Limited Jurisdiction – Case Management System Project (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 DETAILSJob #: 2025-004Status: Project – Limited-Duration, Full-Time*Location: Olympia, WashingtonSalary: Range 72: $91,068 - $119,496 per year (DOQ). Opens: Thursday, January 23, 2025Closes: Wednesday, February 5, 2025. AOC reserves the right to close the recruitment at any time. *Duration: This is a CLJ-CMS project position that has secured funding through June 30, 2025. It is anticipated that continued funding will be approved 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 one (1) day per week working onsite at AOC facilities.
EXAMPLE OF DUTIES
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.
SUPPLEMENTAL INFORMATION
The workweek may fluctuate depending on workload or agency needs.Overnight travel may be required based on business needs.This position is not covered under the overtime provisions of the Fair Labor Standards Act (FLSA) depending upon salary level. 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-4143, or fax (360) 586-4409, or via email to Recruitment@courts.wa.gov. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and complete the required employment eligibility verification form upon hire. SPECIAL NOTE: Before 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.
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 a Data Migration Specialist. Responsibilities include working with the project’s Business Analysts and the Vendor to identify the field level data mapping, migrating the data from SQL Server and other data sources and converting 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 OpportunityAdministrative Office of the Courts Data Migration Specialist(Senior System Support Analyst)Courts of Limited Jurisdiction – Case Management System Project (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 DETAILSJob #: 2025-004Status: Project – Limited-Duration, Full-Time*Location: Olympia, WashingtonSalary: Range 72: $91,068 - $119,496 per year (DOQ). Opens: Thursday, January 23, 2025Closes: Wednesday, February 5, 2025. AOC reserves the right to close the recruitment at any time. *Duration: This is a CLJ-CMS project position that has secured funding through June 30, 2025. It is anticipated that continued funding will be approved 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 one (1) day per week working onsite at AOC facilities.
EXAMPLE OF DUTIES
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.
SUPPLEMENTAL INFORMATION
The workweek may fluctuate depending on workload or agency needs.Overnight travel may be required based on business needs.This position is not covered under the overtime provisions of the Fair Labor Standards Act (FLSA) depending upon salary level. 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-4143, or fax (360) 586-4409, or via email to Recruitment@courts.wa.gov. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and complete the required employment eligibility verification form upon hire. SPECIAL NOTE: Before 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.
Salary : $91,068 - $119,496
