Data Conversion Specialist

Octave; Madison (AL); On-site; USD 85,000 - 125,000; Full time

Job summary

Octave is seeking a Data Conversion Specialist to design, develop, and execute data conversion from legacy systems into Octave’s OnCall Records system. Primary focus on SQL Server, ETL, and data integrity across migration lifecycles.

The role requires collaboration with analysts and product teams, script development, testing, and rigorous validation. Remote-friendly, based in the United States with a Madison, AL orientation.

Qualifications

• Proven experience with SQL Server (T-SQL scripting, stored procedures, performance tuning)
• Strong understanding of data conversion, migration, and ETL processes
• Familiarity with Records Management systems and related data structures
• Excellent customer communication skills and ability to manage expectations
• Strong documentation skills for mapping and process workflows
• Ability to analyze complex datasets and ensure data integrity

Responsibilities

• Analyze legacy system data structures and map them to target system schemas.
• Create and maintain detailed mapping documentation for all conversion processes.
• Collaborate with business analysts and product teams to ensure accurate data transformation.
• Write, optimize, and maintain SQL Server scripts for ETL (extract, transform, load).
• Develop automated processes to streamline data migration and reduce manual intervention.
• Perform rigorous data validation to confirm accuracy and completeness of converted data.
• Communicate with customers and stakeholders to clarify requirements and timelines.

Skills

SQL Server

T-SQL scripting

ETL processes

Data validation

Data mapping

Documentation

Communication

Tools

SSIS

Azure

Salesforce

Microsoft Teams

Job description

Responsibilities

Octave is seeking a highly skilled Data Conversion Specialist with expertise primarily in SQL Server to join our team. This role is responsible for designing, developing, and executing data conversion processes to migrate information from legacy Records Management systems into our Octave’s OnCall Records system. The ideal candidate will have strong SQL scripting skills, understanding of various formats and platforms, excellent communication abilities, and experience validating data integrity throughout the conversion lifecycle.

Key Responsibilities

Data Analysis & Mapping

• Analyze legacy system data structures and map them to target system schemas.
• Create and maintain detailed mapping documentation for all conversion processes.
• Collaborate with business analysts and product teams to ensure accurate data transformation.

Script Development & Testing

• Write, optimize, and maintain SQL Server scripts for data extraction, transformation, and loading (ETL).
• Experience with cross-platform data manipulation/migration (i.e. XML-> MSSQL, Oracle->MSSQL, etc.).
• Develop automated processes to streamline data migration and reduce manual intervention.
• Conduct test runs of conversion scripts, troubleshoot issues, and refine processes for accuracy and efficiency.

Data Validation & Quality Assurance

• Perform rigorous data validation to confirm accuracy and completeness of converted data.
• Identify and resolve discrepancies between source and target systems.
• Document testing results and maintain audit trails for compliance.

Customer Communication & Expectation Management

• Communicate effectively with customers and stakeholders to clarify requirements and timelines.
• Provide regular updates on conversion progress and manage expectations regarding deliverables.
• Address customer inquiries and concerns promptly and professionally.

Education / Qualifications

Required Qualifications

• Proven experience with SQL Server (T-SQL scripting, stored procedures, performance tuning).
• Strong understanding of data conversion, migration, and ETL processes.
• Familiarity with Records Management systems and related data structures.
• Excellent customer communication skills and ability to manage expectations.
• Strong documentation skills for mapping and process workflows.
• Ability to analyze complex datasets and ensure data integrity.

Preferred Qualifications

• Experience with SSIS or other ETL tools.
• Knowledge with Azure, Sales Force, and Microsoft Teams.
• Background in records management or Public Safety Experience.

About Octave

Octave provides mission-critical software that empowers organizations to make informed decisions across every stage of the asset lifecycle - Design, Build, Operate and Protect - where performance, safety, and reliability are non-negotiable and failure is not an option.

Turning complex operational data into actionable intelligence, Octave connects expertise, real-world conditions and enterprise-scale insight to improve performance, resilience and incident response where it matters most.

Octave has more than 7,000 employees in 45 countries. Learn more at octave.com and follow us on LinkedIn.

Why work for Octave?

All in. Always forward. That's the way we do things around here. We put trust in our people because we believe it's the best way to unleash potential, bring ideas to life, and keep moving ahead. And it's why we're committed to creating an environment that's truly supportive, providing you with the resources you need to support your ambitions, no matter who you are or where you are in the world.

Everyone is welcome

At Octave, we believe that diverse and inclusive teams are critical to the success of our people and our business. Here, everyone is welcome. As an inclusive workplace, we don't discriminate. In fact, we embrace differences and are fully committed to creating equal opportunities, an inclusive environment, and fairness for all.

Respect is the cornerstone of how we operate, so speak up and be yourself. You're valued here.

Job Location (Short)

Madison, Alabama-USA

Workplace Type

Remote

Req Id

2948