Data Analyst

Ascendo Resources • Full-time • Southlake, TX, US • 1w ago

Revenue Analyst – SQL & Invoice Reconciliation

In this role, you will be responsible for analyzing revenue streams, ensuring accurate invoice reconciliation, and supporting financial integrity across a portfolio of clients. Leveraging advanced SQL and analytical skills, you’ll collaborate with internal teams—and occasionally external partners—to proactively resolve issues impacting billing, payments, and revenue performance.

You’ll play a key role in identifying billing discrepancies, tracking missing credits, validating data, and ensuring invoice accuracy against contractual and business rule specifications.

Key Responsibilities:

Build SQL tables from flat files and write clean, efficient queries to analyze large datasets.
Reconcile and validate invoices and account activity across your assigned client portfolio.
Monitor transactions, revenues, and data flows to proactively identify discrepancies or leakages.
Collaborate with IT, Client Operations, Accounting, Account Management, and BI teams.
Escalate and resolve billing or payment disputes with relevant stakeholders.
Track and manage account aging, discrepancy resolutions, and reconciliation status.
Provide insights through data analysis, reporting, and trend monitoring.
Serve as the subject matter expert (SME) and primary contact for assigned revenue streams.
Continuously improve processes to maximize cash flow and reduce outstanding debt.
Maintain accurate process documentation and support ad hoc projects as needed.

Qualifications:

Required:

Bachelor’s degree in Business, Accounting, Computer Science, or a related field.
2+ years of relevant experience in revenue analytics, billing, or financial reconciliation.
Strong SQL skills with experience analyzing complex datasets.
Proficient in Microsoft Office (Excel, Access, PowerPoint).
Excellent communication skills—able to tailor messaging to various stakeholders.
Strong attention to detail, time management, and organizational abilities.
Proven ability to operate in a fast-paced, dynamic environment.

Ascendo is a certified minority owned staffing firm, and we welcome and celebrate diversity. Ascendo is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, parental status, military service or any other characteristic protected by federal, state or local law.