What are the responsibilities and job description for the Data Engineer position at TriOptus?
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