Senior Data Migration Specialist

Administrative Office of the Courts•Olympia, WA

1d•Hybrid

About The Position

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.

Requirements

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.
Proficiency 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, Python, HTML, C#, ArcGIS, and/or other IT-related languages or applications
T-SQL
SQL Server
Data Conversion
Data Cleansing methodologies
Ability 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.
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.

Nice To Haves

Experience with Git source control and CI/CD technologies is strongly preferred.
Experience with Extract, Transform, and Load (ETL) processes and tools is highly desirable.
Experience creating meaningful executive-level reports and data dashboard solutions using tools like SQL Server Reporting Services (SSRS), Power BI, or similar business intelligence platforms.

Responsibilities

Works 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 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.
Creates and implements automated validation routines to ensure that data quality, integrity, and completeness are maintained; provide reports as requested.
Participates 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.
Reviews and evaluates work products for accuracy and applicability.
Performs duties as required.