Likewize is searching for a Data Analyst (Revenue) to join our team at our global Headquarters in Southlake, TX. In this role, you will be responsible for analyzing assigned portfolio of clients and revenue streams and ensuring reconciliation of systems. 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 renewing and confirming that billing data conforms to specifications prescribed by the contract or established business rules.
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 intentional or unintentional 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.
Document all interactions with internal and external customers for historical reference and potential dispute resolution
With management, interpret agreements for key business terms to validate billing or payment history and identify adjustments.
Serve as a SME and lead point of contact for internal partners regarding their respective revenue streams
Be a team player and cross-train as back-up for others in AR and Device Protection teams.
Support Device Protection initiatives and projects.
Drive process improvements.
Operating 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.
3+ years of work experience in similar analytics roles or specific telecommunications, fintech or insurance company experience.
Advanced computer skills (MS Office, Access, Excel)
Exceptional SQL proficiency
Proficient with database design and data analysis
Experience with Great Plains or similar ERP system, and data warehouse environments
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; effectively balance multiple priorities and meet deadlines.
2+ years of work experience in accounts receivable.
Advanced analytical skills – trending.
Experience working directly with global multi-site company