Senior Data Engineering Consultant

Octave provides mission-critical software that empowers organizations to make informed decisions across every stage of the asset lifecycle. They are seeking a highly skilled Data Conversion Specialist with expertise primarily in SQL Server to design, develop, and execute data conversion processes from legacy systems into their OnCall Records system.

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 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
• 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
• 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
• Plan and execute test runs prior to production migration
• Coordinate with internal teams and customers to ensure smooth cutover and minimal disruption
• Document conversion processes, scripts, and validation results for future reference

Requirements:

• 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
• Experience with SSIS or other ETL tools
• Knowledge with Azure, Sales Force, and Microsoft Teams
• Background in records management or Public Safety Experience