TriOptus

TriOptus

30 jobs near Columbus, OH

Data Engineer SOW RFP VT

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 ...

Lead Dotnet Developer TriOptus Santa Clara County, California, United States (Remote) Sr. Lead .NET ... Design, develop, and test system integrations and data exchange interfaces * Lead integration ...

DataOps Engineer Job Type: Contract Duration: 12-15 months (with potential for extension) Work ... Develop and maintain data quality rules, validation frameworks, and monitoring processes

DevOps Engineer Terraform Expert

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 ...

Lead .NET Developer

Saint Paul, MN · On-site

$59.75 - $78.25/hr

Ensure compliance with security, data privacy, and accessibility standards * Contribute to ... Fifteen (15) years of total software development experience * Five (5) years' experience in ...

Network Security Engineer

Annapolis, MD · On-site

$103K - $141K/yr

Perform engineering, installation, configuration, and troubleshooting of data and security networks. * Provide assessment, design, and implementation of secure networking environments. * Develop ...

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 ...

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 ...

Medical Assistant - Remote

Manhattan, NY · On-site

$19.50 - $25/hr

... computer software navigation; data entry and data cleansing A fundamental knowledge of Google Docs, Sheets, Slides or similar A demonstrated ability to work effectively as a member of an ...

Track action items and update G2N software with approved changes to assumptions and data. * Monitor business performance and provide early warning indicators to enable proactive resource ...

next page

Showing results 1-20

Data Engineer SOW RFP VT

Trioptus

Waterbury, VT • On-site

$114K - $137K/yr

Contractor

Re-posted 17 days ago


Job description

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