Data Migration Specialist

Summary

Join Rev.io as a Data Migration Specialist and migrate client data from legacy systems to the Rev.io system. You will design, code, and maintain migration projects, solve problems related to legacy systems, and ensure accurate billing and superior customer management. This role requires strong customer-facing skills, teamwork, and problem-solving abilities. You will work with client teams and provide hands-on assistance with billing issues. The position involves creating and testing custom SQL queries and stored procedures, managing complex call records, and validating results. You will also assist clients with data migration standards and best practices.

Requirements

• A Bachelor’s degree in Computer Science, Business, or Information Technology recommended
• Knowledge and working experience of SQL Server and DTS packages are essential
• Familiarity with CDR formats (e.g. BAF, EMI), types and jurisdictions
• Familiarity with telecom tax engines and data feeds (e.g. SureTax, Avalara)
• Experience of analysis of data structures and development of tools to parse and restructure data
• Client-facing skills together with the ability to work independently in the field interpreting specific requirements
• In-depth understanding of SQL queries, statements, and stored procedures
• Experience of problem solving, database installation and management procedures in development and production environments
• Knowledge of ODBC/ADO and accessing remote systems using various methods
• Management of database systems

Responsibilities

• Work with client teams of Billing and Mediation Specialists, and Database Administrators responsible for all clients billing and rating operations
• Migration of legacy data to specified SQL Server database structure
• Configure database and DBMS parameters
• Monitor successful completion of all scheduled jobs for implementation; troubleshooting any job failures and DBMS issues
• Communicate and update on task due dates, requirement needs and overall project status to the Implementation Team and Vice President of Operations
• Provide hands-on assistance in research and resolution of client billing issues and inquiries
• Create, modify and test custom SQL queries and stored procedures to provide maximum visibility into billing details and accuracy and customer billing formats to large wholesale and enterprise customers
• Manage complex call records mediation and rating engine to ensure all usage elements are properly applied to customer accounts
• Validate results by testing Rev.io instance for each implementation, including standard and custom fields
• Dual bill run testing and rating to ensure the customer is billing correctly out of Rev.io
• Analyzing rating, MRCs, NRCs for accurate billing between a customers legacy system and Rev.io
• Assist clients with guidance on data migration standards and best practices for utilizing Rev.io functionality
• Foster ideas on how to improve client relationships and operational efficiencies
• Develop a foundation and the recommendation to steam line and define the data migration process by product type and monthly recurring revenue

Preferred Qualifications

T-SQL experience and programming in SQL Server, SQL scripting and SQL database design. Experience of applying data modeling tools would be an advantage

Benefits

• Excellent medical, dental and vision coverage, with plan options and rates comparable to larger companies
• Generous HSA employer contribution
• 401k with generous company match and immediate vesting
• Unlimited PTO
• Paid Parental Leave
• Company paid for life and disability insurance
• Monthly tech reimbursement
• Monthly fitness reimbursement
• Education and development stipend
• Time off to volunteer at the organization of your choice, as well as company-level volunteer opportunities
• Clear and documented career path for your position
• True open-door policy with opportunities to give feedback to leadership on a continual basis through 1:1 sessions multiple times per year