Data Engineer SOW RFP VT
Waterbury, Washington County, Vermont, 05676, USA
Listed on 2026-01-12
-
IT/Tech
Data Engineer, Data Analyst -
Engineering
Data Engineer
Data Engineer
Tri Optus Waterbury, Vermont, United States (Remote)
Data Engineer RMS Data Migration (Public Safety)
Location:
Remote (U.S. Only)
Engagement Type:
Contract
Start: ASAP
Duration:
Short term project
About the Role
Our client is upgrading its Records Management System (RMS). We're seeking an experienced Data Engineer to play a critical role in analyzing, cleansing, mapping, and transforming legacy RMS data for migration into a new platform.
This role involves working with under documented legacy MySQL/MSSQL databases, reverse engineering schemas, and supporting secure, accurate data ingestion into a third party RMS solution.
Key Responsibilities
Analyze legacy MySQL and Microsoft SQL Server databases to identify tables, relationships, keys, and business logic
Reverse engineer undocumented schemas and reconstruct detailed data dictionaries
Design and document data mappings between legacy RMS and new RMS schema
Develop optimized, repeatable SQL queries for data extraction and transformation
Prepare structured and unstructured data (including PDFs and BLOBs) for ingestion
Support iterative test migrations and final production cutover
Create complete technical documentation and provide knowledge transfer to agency staff
Collaborate with State IT teams, RMS vendors, and subject matter experts
Required Skills and Experience
Strong experience as a Data Engineer or similar role
Advanced SQL development (complex queries, joins, transformations)
Hands on experience with MySQL and Microsoft SQL Server
Proven expertise in data modeling, normalization, and schema discovery
Experience with ETL processes and data transformation for third party systems
Ability to interpret and work with incomplete or ambiguous legacy data
Strong analytical, communication, and documentation skills
Preferred Qualifications
Experience with public safety, RMS, case management, or justice systems
Experience processing unstructured data (BLOBs, PDFs, attachments)
Prior work on government or statewide IT modernization projects
Work Details
100% Remote (must be located within the United States)
Access to systems via State provided virtual desktop
Work performed during State business hours (7:45 AM 4:30 PM ET)
Background check required
#Data Engineer #Data Migration #SQL Developer #ETL #MySQL #MSSQL #Public
Safety
IT #RMS
#Government Tech #Remote Jobs #Data Engineering
(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).