About The Role: We are looking for a Data Engineer to join our team in Atlanta, GA. The purpose of a
Data Engineer 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
