Waterbury, VT · On-site
$114K - $137K/yr
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 ...
Quick apply
Waterbury, VT · On-site
$114K - $137K/yr
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 ...
Santa Clara, CA · On-site
Lead Dotnet Developer TriOptus Santa Clara County, California, United States (Remote) Sr. Lead .NET ... Software AG API Gateway (4+ years) Business & Functional Skills * Strong experience working with ...
Quick apply
Santa Clara, CA · On-site
Lead Dotnet Developer TriOptus Santa Clara County, California, United States (Remote) Sr. Lead .NET ... Software AG API Gateway (4+ years) Business & Functional Skills * Strong experience working with ...
Software Developer (.NET MVC / C#) Location: St. Paul, MN (Hybrid - Onsite Mon/Tue/Thu) Job Type: Full-Time Contract Duration: March 16, 2026 - August 31, 2027 Interview Mode: Microsoft Teams About ...
Quick apply
Software Developer (.NET MVC / C#) Location: St. Paul, MN (Hybrid - Onsite Mon/Tue/Thu) Job Type: Full-Time Contract Duration: March 16, 2026 - August 31, 2027 Interview Mode: Microsoft Teams About ...
Power Platform Software Architect & Power Platform Software Developer Project Duration: April 2026 - August 2027 (with extension options) Work Type: Remote/Hybrid - St. Paul, MN Interview Format:
Quick apply
Power Platform Software Architect & Power Platform Software Developer Project Duration: April 2026 - August 2027 (with extension options) Work Type: Remote/Hybrid - St. Paul, MN Interview Format:
Des Moines, IA · On-site
$51.50 - $70.50/hr
Collaborate closely with software engineers to optimize application performance and reliability in AWS environments. * Security & Compliance: Implement and enforce security best practices and ...
Quick apply
Des Moines, IA · On-site
$51.50 - $70.50/hr
Collaborate closely with software engineers to optimize application performance and reliability in AWS environments. * Security & Compliance: Implement and enforce security best practices and ...
Saint Paul, MN · On-site
$59.75 - $78.25/hr
Fifteen (15) years of total software development experience * Five (5) years' experience in ... Net Engineer role designing and developing using Microsoft technologies and mentoring junior ...
Quick apply
Saint Paul, MN · On-site
$59.75 - $78.25/hr
Fifteen (15) years of total software development experience * Five (5) years' experience in ... Net Engineer role designing and developing using Microsoft technologies and mentoring junior ...
This role will work closely with business stakeholders, developers, and product owners to ensure ... Experience with test automation tools (e.g., Testim or similar) * QA, Software Testing, or ...
Quick apply
This role will work closely with business stakeholders, developers, and product owners to ensure ... Experience with test automation tools (e.g., Testim or similar) * QA, Software Testing, or ...
Saint Paul, MN · On-site
Work closely with program managers, developers, business analysts, and multi-vendor stakeholders. Q ... Minimum Qualifications * 10+ years of QA or software testing experience. * 5+ years leading QA ...
Quick apply
Saint Paul, MN · On-site
Work closely with program managers, developers, business analysts, and multi-vendor stakeholders. Q ... Minimum Qualifications * 10+ years of QA or software testing experience. * 5+ years leading QA ...
$114K - $137K/yr
Contractor
Re-posted 17 days ago
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
Sourced by ZipRecruiter
It services
51 - 200 Employees
Clarksburg, MD, US
2019