Data Conversion Specialist

Octave Intelligence plc; United States; On-site; USD 70,000 - 90,000; Full time

Job summary

Octave Intelligence plc is seeking a Data Conversion Specialist to work remotely from the United States. You will design, develop, and execute data conversion processes primarily using SQL Server to migrate legacy data into Octave's OnCall Records system.

You will analyze legacy data structures, create detailed mapping documentation, write and tune T-SQL scripts for ETL, and perform thorough data validation.

Qualifications

• Experience with SQL Server, including T-SQL scripting and performance tuning.
• Strong understanding of data conversion, migration, and ETL processes.
• Familiarity with Records Management systems and their data structures.
• Excellent customer communication skills and ability to manage expectations.
• Strong documentation skills for mapping and process workflows.

Responsibilities

• Analyze legacy system data structures and create detailed mapping documentation for data conversion.
• Write and optimize SQL Server scripts for data extraction, transformation, and loading (ETL), while conducting testing and troubleshooting.
• Perform data validation to ensure accuracy and completeness, while effectively communicating with customers regarding progress and expectations.

Skills

SQL Server

T-SQL

ETL

Data migration

Data validation

Documentation

Customer communication

Job description

Seeking a skilled Data Conversion Specialist to work remotely, who will design, develop, and execute data conversion processes primarily using SQL Server, ensuring accurate migration from legacy systems to Octave's OnCall Records system.

Key responsibilities

• Analyze legacy system data structures and create detailed mapping documentation for data conversion
• Write and optimize SQL Server scripts for data extraction, transformation, and loading (ETL), while conducting testing and troubleshooting
• Perform data validation to ensure accuracy and completeness, while effectively communicating with customers regarding progress and expectations

Required qualifications

• Proven experience with SQL Server, including T‑SQL scripting and performance tuning
• Strong understanding of data conversion, migration, and ETL processes
• Familiarity with Records Management systems and their data structures
• Excellent customer communication skills and ability to manage expectations
• Strong documentation skills for mapping and process workflows