Data Analyst, Revenue Assurance

In this role, you will be responsible for analyzing revenue streams and ensuring reconciliation of invoices for a portfolio of clients. Utilizing strong SQL and analytical skills, you will work closely with internal and potentially external partners to proactively identify and resolve issues that may lead to payment performance issues including billing discrepancies, missing credits, and misapplied payments. You will also ensure invoice accuracy by reviewing and confirming that billing data conforms to specifications prescribed by the contract or established business rules.

To be successful, you must be an efficient self-starter with excellent organization skills, have attention to detail, be a critical thinker and results focused, with an ability to operate effectively in a fast paced, ever-changing environment.

Your day-to-day responsibilities include but are not limited to:

• Create SQL tables from flat files and write clean, organized, and efficient queries for large datasets. Interpret our clients’ data and communicate across different departments such as IT, Client Operations, Account Management, Accounting & Business Intelligence
• Reconcile and validate assigned portfolio of accounts to ensure timely and accurate billing and accounting
• Monitor revenues, transactions, and summary level information along the life cycle of the data flow to minimize any leakages/discrepancies in a proactive manner
• Liaison with other internal partners and escalate disputes as needed to drive resolution
• Monitor account aging and discrepancy resolutions
• Utilize analysis tools to provide reporting
• Gather and interpret metric data, identifying and communicating gaps, trends, and areas of opportunity to individuals and management
• Reconcile and validate postings and activities performed in production
• Serve as a SME and lead point of contact for internal partners regarding their respective revenue streams
• Operate to maximize cash flow and minimize debt by improving and optimizing processes to drive operational excellence
• Create and maintain process documentation
• Other Duties/Projects as assigned by business management as needed

If you are who we are looking for, you will have the following education, skills and/or experience.

• BS/BA in Business, Accounting, Computer Science, or related field
• 2+ years of work experience in similar analytics roles, preferably with telecommunications, fintech or insurance company experience
• Advanced computer skills (MS Office, Access, Excel)
• Exceptional SQL proficiency
• Proficient with database design and data analysis
• Excellent verbal and written communication skills including the ability to flex communication style and to communicate effectively at all organizational levels
• Ability to build lasting and effective working relationships with both internal and external partners
• Strong organizational and time management skills to effectively balance multiple priorities and meet deadlines

Preferred:

• 2+ years of work experience in accounts receivable
• Advanced analytical skills to include trending
• Experience working directly with global multi-site company
• Experience with Great Plains, NetSuite or similar ERP system, and data warehouse environments