More jobs:
Data Engineer
Job in
Waterbury, Washington County, Vermont, 05676, USA
Listed on 2026-01-17
Listing for:
TriOptus
Seasonal/Temporary
position Listed on 2026-01-17
Job specializations:
-
IT/Tech
Database Administrator, Data Engineer
Job Description & How to Apply Below
Data Engineer – RMS Data Migration (Public Safety)
Location: Remote (U.S. Only)
Engagement Type: Contract
Start: ASAP
About the RoleOur 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.
- 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
- 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
- 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
- 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
Seniority Level: Mid-Senior level
Employment Type: Contract
Job Function: Information Technology
Industries: Government Administration
#J-18808-LjbffrTo View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(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).
(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).
Search for further Jobs Here:
×