Talent.com
Data Engineer – RMS Data Migration
Data Engineer – RMS Data MigrationINFT Solutions Inc • Montpelier, Virginia, USA
Data Engineer – RMS Data Migration

Data Engineer – RMS Data Migration

INFT Solutions Inc • Montpelier, Virginia, USA
[job_card.variable_days_ago]
[job_preview.job_type]
  • [job_card.full_time]
[job_card.job_description]

Job Title-Data Engineer - RMS Data Migration

Location- Montpelier Vermont

Job Description

The Data Engineer will be responsible for analyzing reverse-engineering mapping extracting transforming and preparing legacy RMS data for ingestion into the new system. The legacy data resides primarily in MySQL replicated to Microsoft SQL Server and lacks complete documentation including a formal data dictionary and schema definitions.

Key Responsibilities

  • Analyze legacy MySQL and MSSQL databases to identify tables columns keys relationships constraints and implicit business rules
  • Reverse-engineer and reconstruct a comprehensive data dictionary
  • Identify data quality issues and recommend remediation strategies
  • Develop detailed data-mapping documentation between legacy RMS data and the new RMS schema
  • Design and implement SQL-based extraction and transformation logic
  • Write optimized repeatable and deterministic SQL queries for large datasets
  • Create staging tables views and intermediate transformation layers as required
  • Apply normalization deduplication value standardization and data-quality checks
  • Support iterative test migrations and final data loads in coordination with the RMS vendor
  • Document all SQL scripts transformation logic assumptions and dependencies
  • Provide knowledge transfer and walkthroughs to State personnel
  • Participate in technical discussions with State IT teams and subject-matter experts

Required Qualifications

  • Strong expertise in advanced SQL (complex joins subqueries transformations)
  • Hands-on experience with MySQL and Microsoft SQL Server
  • Proven ability to reverse-engineer undocumented or poorly documented schemas
  • Solid understanding of data modeling normalization and ETL methodologies
  • Experience preparing structured data for ingestion into third-party or COTS systems
  • Strong analytical documentation and communication skills
  • Ability to work independently with minimal supervision

    • Preferred Qualifications

  • Experience with public safety RMS case management systems or similar regulatory platforms
  • Experience handling BLOBs PDFs and unstructured data during ETL processes
  • Prior public-sector or government project experience

    • Key Skills

    Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala

    Employment Type : Full Time

    Experience : years

    Vacancy : 1

    [job_alerts.create_a_job]

    Data Engineer RMS Data Migration • Montpelier, Virginia, USA

    [internal_linking.similar_jobs]
    Center of Excellence Analyst

    Center of Excellence Analyst

    Luck Stone • Manakin Sabot, VA, United States
    [job_card.full_time]
    Job : Statistical & Geospatial Analysis.Apply statistical methods (regression, forecasting, hypothesis testing, clustering) to analyze business and operational data. Conduct geospatial analyses using...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Senior Transportation Engineer P.E. – Roadway / Traffic

    Senior Transportation Engineer P.E. – Roadway / Traffic

    Trilon Group • Glen Allen, Virginia, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Are you a civil engineering professional with a passion for traffic operations and multimodal design? Rinker Design Associates (RDA) is seeking a. Senior Transportation Engineer.Join our team and sh...[show_more]
    [last_updated.last_updated_30]
    Travel MRI Technologist

    Travel MRI Technologist

    Medical Solutions Allied • North Chesterfield, VA, US
    [job_card.full_time]
    Medical Solutions Allied is seeking a travel MRI Technologist for a travel job in North Chesterfield, Virginia.Job Description & Requirements. We’re seeking talented healthcare professiona...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel MRI Technologist

    Travel MRI Technologist

    Triage Staffing • North Chesterfield, VA, US
    [job_card.full_time]
    Triage Staffing is seeking a travel MRI Technologist for a travel job in North Chesterfield, Virginia.Job Description & Requirements. Travel Radiology : MRI Tech North Chesterfield, VA.Location : &...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Medical Sales Account Executive

    Medical Sales Account Executive

    Rotech Healthcare Inc. • North Chesterfield, VA, United States
    [job_card.full_time]
    Join a Leader in Home Healthcare.As a national leader in ventilators, oxygen therapy, sleep apnea treatment, wound care, diabetic solutions, and other home medical equipment, we empower patients to...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Sr. Manager, Data Science - Logistics Modeling

    Sr. Manager, Data Science - Logistics Modeling

    CarMax • Henrico, VA, United States
    [job_card.full_time]
    Corp Office West Crk - 12800 Tuckahoe Creek Parkway, Richmond, Virginia, 23238.CarMax, the way your career should be!.The primary responsibility of the Logistics Modeling team is to intelligently a...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    WMS Solutions Engineer | Demos & Client Advocacy

    WMS Solutions Engineer | Demos & Client Advocacy

    Alta Equipment Company • Midlothian, VA, US
    [job_card.full_time]
    A leading equipment dealer in Virginia is seeking an experienced Business Analyst to join the PickPro WMS product development team. The role involves supporting sales through product demos, document...[show_more]
    [last_updated.last_updated_variable_hours] • [promoted] • [new]
    Principal Power Systems Sales Engineer

    Principal Power Systems Sales Engineer

    Simple Thread • Glen Allen, VA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Job Description Simple Thread is at the intersection of software engineering and energy innovation, dedicated to developing cutting-edge solutions that streamline workflows and enhance processes wi...[show_more]
    [last_updated.last_updated_variable_days]
    Program Quality, Data, and Operational Analyst

    Program Quality, Data, and Operational Analyst

    Virginia Birth Injury Fund • North Chesterfield, VA, US
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Position Overview The Program Data, Quality & Operational Excellence Analyst plays a critical role in strengthening the Virginia Birth-Related Neurological Injury Compensat...[show_more]
    [last_updated.last_updated_variable_days]
    Travel MRI Technologist

    Travel MRI Technologist

    GHR Healthcare - PH Division • North Chesterfield, VA, US
    [job_card.full_time]
    GHR Healthcare - PH Division is seeking a travel MRI Technologist for a travel job in North Chesterfield, Virginia.Job Description & Requirements. Planet Healthcare Job ID #74508578.Pay package ...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Travel MRI Technologist

    Travel MRI Technologist

    AHS Staffing • Bon Air, VA, US
    [job_card.full_time]
    AHS Staffing is seeking a travel MRI Technologist for a travel job in Bon Air, Virginia.Job Description & Requirements.Pay package is based on 12 hour shifts and 36 hours per week (subject to c...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Business Systems Analyst I (Hybrid)

    Business Systems Analyst I (Hybrid)

    Atlantic Union Bank • Glen Allen, Virginia, United States
    [job_card.full_time]
    The Business System Analyst will serve as the primary systems manager for a designated set of platforms.This individual will be responsible for handling needs assessments and cost / benefit analysis ...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Field Engineer

    Field Engineer

    Allan Myers • Glen Allen, VA, United States
    [job_card.full_time]
    This full-time entry level engineering position supports a crew(s), project or plant team(s) in the planning, scheduling, execution, and controlling of site and heavy civil construction projects.Ha...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    D365 CRM Business Analyst HYBRID, MUST BE LOCAL OR WILLING TO RELOCATE

    D365 CRM Business Analyst HYBRID, MUST BE LOCAL OR WILLING TO RELOCATE

    AMF Bakery • Glen Allen, VA, US
    [job_card.full_time]
    The position is part of the global AMF IT Application team, reporting to the Director of IT Applications of AMF, an operating company within the Markel Food Group. The D365 CRM Business Analyst is r...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Data Warehouse Arch 2

    Data Warehouse Arch 2

    Sunrise Systems • Chesterfield, Virginia, United States
    [job_card.full_time]
    [filters_job_card.quick_apply]
    Job Title : Data Warehouse Arch 2.Duration : 06 months of contract.Local Richmond, VA candidates required for onsite work. Only submit candidates able to interview onsite.Candidate will be required to...[show_more]
    [last_updated.last_updated_30]
    Travel MRI Technologist

    Travel MRI Technologist

    Host Healthcare • North Chesterfield, VA, US
    [job_card.full_time]
    Host Healthcare is seeking a travel MRI Technologist for a travel job in North Chesterfield, Virginia.Job Description & Requirements. Pay package is based on 12 hour shifts and 36 hours per week...[show_more]
    [last_updated.last_updated_30] • [promoted]
    Global Operations Analytics Engineer

    Global Operations Analytics Engineer

    META • Henrico, VA, United States
    [job_card.full_time]
    Meta is seeking a Global Operations Analytics Engineer to join our Data Center Site Operations team.Our data centers are the foundation upon which our rapidly scaling infrastructure efficiently ope...[show_more]
    [last_updated.last_updated_variable_days] • [promoted]
    Business Analyst (PPBA-L3) NGA - Washington

    Business Analyst (PPBA-L3) NGA - Washington

    Masego • Ladysmith, VA, US
    [job_card.full_time]
    Masego is an award-winning small business that specializes in GEOINT services.As a Service-Disabled Veteran-Owned Small Business (SDVOSB), we recognize and award your hard work.We are looking for a...[show_more]
    [last_updated.last_updated_30] • [promoted]