DatamanUSA 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 Details:
Job Title: Data Engineer - RMS Data Migration
Location: Montpelier, VT
Duration: 12 months
Job Description:
*) 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.
Required Technical Expertise:
*) 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.
Preferred Qualifications:
*) 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.
Never miss an opportunity! Create an alert based on the job you applied for.
