Data Migration Specialist
About Rev.io
Rev.io provides configurable software for billing, customer management, business management, payments, analytics, provisioning, and automation to service providers in telecommunications, Wireless & IoT, managed IT services, A/V, security integration, and other related industries. Our modern, cloud-based software delivers the industry’s most complete quote-to-cash experience, enabling our clients to grow their revenue efficiently.
Rev.io is an Atlanta-based company with employees based in more than 20 states. We have more than 21 years’ in business serving our clients. While we are very experienced in what we do, we are still growing rapidly and we are looking for exceptional people who are excited to join us on a career-defining journey.
In all of our daily work, each of us are guided by our mission, vision and “ACT TOP” values.
Our Mission: To help clients grow revenue efficiently.
Our Vision: To be the best billing & back-office software company in the world by providing innovative solutions and extraordinary service to our clients and end users.
Our ACT TOP Values:
- Achieving Extraordinary Results: Doing more than expected and pursuing a higher standard of work without compromising your job responsibilities.
- Caring For Employees, Clients and Community: Demonstrating empathy and concern by helping those who are most in need.
- Take Responsibility and Act Like An Owner: Being accountable and doing the right thing even when no one is watching.
- Transparent Leadership: Communicating openly, regardless of title or situation
- Opportunity To Make a Positive Difference: Recognizing situations and taking action to produce a better outcome.
- Passion For Innovation: Enthusiastically finding new solutions to improve efficiency.
In a recent national survey, 97% of our employees agreed that Rev.io is a Great Place to Work compared to 57% agreement at comparable US-based companies, Rev.io stands out as a place where team, values and culture combine to create an amazing work environment!
About The Role:
We are looking for a Data Migration Specialist to join our team in Atlanta, GA. The purpose of a Data Migration Specialist is to migrate and curate a client's data from their legacy system into the Rev.io system in a structured, scalable manner that provides our clients with accurate billing and superior customer management capabilities This is a dynamic role with a responsibility for the detailed design, coding and maintenance of migration projects to move data from a variety of legacy systems. Problem solving will be a big part of the role, as legacy systems need to be deciphered, documented and methods of accessing them designed. The role requires you to be a self-driven, highly motivated individual with strong customer facing, teamwork, and support skills. This is an IT Billing Operations role supporting client data migrations and billing analytics.
Job Objectives and 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.
Skills Needed:
- 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.
- T-SQL experience and programming in SQL Server, SQL scripting and SQL database design. Experience of applying data modeling tools would be an advantage.
- Management of database systems.
Benefits and Perks:
- 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
At Rev.io no employee or applicant will be treated less favorably on the grounds of their sex, marital status, race, color, nationality or ethnic or national origin, disability, gender, sexual orientation, gender identity, age, pregnancy or maternity, marital or civil partner status, or religion or belief. By clicking submit below, you consent to allow Rev.io to store and process the personal information submitted above.