Data Engineer RMS Data Migration

Dataman

USA is looking for a Data Engineer – RMS Data Migration for our direct client based in VT. This is a great opportunity for someone who is a quick learner with excellent people skills.

Job Title:

Data Engineer – RMS Data Migration

Location:

Montpelier, VT

Duration: 12 months

• Analyze and reverse-engineer undocumented MySQL and MSSQL database schemas.
• Perform data discovery, profiling, and validation across legacy RMS tables.
• Design and document logical and physical data models for migration purposes.
• Develop optimized, repeatable, and deterministic SQL queries to extract and transform large datasets.
• Prepare structured data for ingestion into the new RMS in compliance with vendor-specific formats and validation rules.
• Design and execute ETL processes to support full and incremental data migrations.
• Process and migrate binary large objects (BLOBs), including PDFs and other unstructured data.
• Support iterative test migrations and adjust SQL scripts, mappings, and transformation logic based on findings.
• Identify data quality issues and recommend remediation strategies.
• Collaborate with Agency IT staff, RMS vendor teams, and subject matter experts during technical discussions.
• Produce clear, complete technical documentation suitable for long-term Agency maintenance.
• Provide knowledge transfer to Agency personnel, including walkthroughs of queries, mappings, and ETL logic.
• Communicate progress, risks, and timelines effectively with minimal supervision.

• Advanced SQL, including complex SELECT statements, joins, subqueries, and transformation logic.
• Strong experience with MySQL and Microsoft SQL Server, including database architecture and schema discovery.
• Solid understanding of data modeling, normalization, and relational database design.
• Proven ability to reverse-engineer undocumented or poorly documented schemas.
• Hands-on experience with ETL methodologies and preparing data for third-party system ingestion.
• Experience processing and migrating BLOBs, PDFs, and unstructured data.
• Strong analytical, problem-solving, and technical documentation skills.
• Ability to interpret incomplete, ambiguous, or legacy data structures.

• Experience working with public safety RMS, case management systems, or similarly complex relational data environments.
• Prior experience supporting data migrations for government or public-sector agencies.
• Familiarity with RMS vendor ingestion frameworks and validation processes.