2 Trioptus Desktop Support Jobs Hiring Near You

Data Engineer

TriOptus  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 & 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

#DataEngineer #DataMigration #SQLDeveloper #ETL #MySQL #MSSQL #PublicSafetyIT #RMS

#GovernmentTech #RemoteJobs #DataEngineering