We are seeking a detail-oriented and highly analytical Accounts Payable Data Analyst with strong Excel expertise to join our Finance team in the telecommunications industry. This role is responsible for analyzing financial data, developing advanced Excel models, and supporting key business decisions through data-driven insights. The ideal candidate will have a good understanding of financial analysis and extensive experience using Excel tools such as pivot tables, VLOOKUP, macros, and comparison utilities.
The AP Data Analyst will:
- Analyze and approve vendor/carrier invoice data for payment and pinpoint overbillings or under billings by applying general audit principles such as pattern recognition, data filtering, and cross-referencing multiple data sources.
- Maintain the expense allocation schedule for vendor/carrier expenses including advanced Excel models using pivot tables, VLOOKUP/XLOOKUP, Power Query, and comparison tools.
- Generate Purchase Orders and modifications thereto for vendors/carriers.
- Analyze vendor/carrier contracts, applicable tariffs, and Interconnection Agreements and research other sources of data.
- Analyze telecom-specific metrics such as service costs, usage trends, and customer profitability.
- Support month-end and year-end close activities with accurate data validation and reporting.
- Serve as the primary point of contact regarding vendor/carrier billings and track vendor/carrier overbillings to resolution.
- Work closely with internal project management teams to assist in reconciliation of issues with the vendors/carriers.
- Assist with special projects as delegated by the leadership team.
Requirements
- 3+ years of experience in financial analysis or data analytics, preferably in the telecom industry.
- Detail-oriented with strong organizational and time management skills
- Advanced proficiency in Microsoft Excel, including pivot tables, VLOOKUP/XLOOKUP, macros, Power Query, and VBA.
- Experience with Microsoft Outlook & Word.
- Strong analytical, problem-solving, and data interpretation skills.
- Ability to work independently and as part of a team.
- Strong analytical and problem-solving skills.
- Excellent communication and interpersonal skills.
- Bachelor’s degree in finance, Accounting, Economics, Statistics, Data Analytics, or related field.
- Must be able to pass a background check.
PREFERRED QUALIFICATIONS:
- Experience in telecommunications, managed services, or network infrastructure industries.
- Knowledge of BI tools such as Power BI or Tableau.
- Familiarity with Access, SQL or other data querying languages.
- Experience automating finance reports and processes.
Benefits
- Health Care Plan (Medical, Dental & Vision)
- 401(k) savings plan
- Life Insurance (Basic, Voluntary & AD&D)
- Paid Time Off
- Public Holidays
- Family Leave (Maternity, Paternity)
- Short Term & Long Term Disability
- Work From Home
AOC Connect is a leading Federal IT integrator specializing in advanced fiber network solutions for government agencies. As a prime contractor on the GSA EIS contract, AOC Connect is committed to providing reliable and innovative connectivity solutions. Join our team to contribute to impactful projects that shape critical communications infrastructure.