ARC Reconciliation Analyst | Reporting & Analytics

AccessFares; Dallas (TX); On-site; USD 60,000 - 90,000; Full time

Job summary

AccessFares in Dallas seeks an ARC Specialist to ensure completeness and integrity of ARC IAR data and related reporting. You will reconcile airline ticketing and financial transactions, validate reporting accuracy, investigate discrepancies, and support weekly reporting and settlement while collaborating with Operations, Finance, IT, and Data Analytics.

The role emphasizes internal controls, ARC compliance, documentation, and continual process improvement, including automation opportunities.

Qualifications

• 2–5 years of experience in airline reporting, reconciliation, accounting operations, or financial analysis.
• Experience with ARC Interactive Agent Reporting (IAR) preferred.
• Experience reconciling airline ticket sales, refunds, exchanges, voids, ADMs/ACMs, and settlements preferred.
• Experience in the travel or airline industry is highly preferred.

Responsibilities

• Perform daily, weekly, and monthly reconciliations of ARC IAR transactions.
• Reconcile airline ticket sales and related ARC-reportable transactions against internal systems.
• Investigate discrepancies between reservation systems, accounting records, and ARC reporting.
• Validate transaction accuracy prior to weekly ARC reporting and settlement.
• Monitor exception reports and resolve variances within SLAs.
• Maintain documentation supporting reconciliation activities and issue resolution.
• Review ARC reporting and dashboards for accuracy and data integrity.
• Conduct periodic audits to ensure alignment with source records.
• Identify anomalies, trends, and potential control issues.
• Support testing and implementation of reporting or system enhancements.
• Recommend automation and process improvements to increase accuracy and efficiency.

Skills

Analytical thinking

Attention to detail

Financial reconciliation

Root cause analysis

Organizational skills

Written and verbal communication

Cross-functional collaboration

Time management

Tools

Pivot Tables

XLOOKUP/VLOOKUP

Power BI/Tableau

Excel data validation

ARC IAR knowledge

GDS systems (Sabre/Amadeus/Travelport)

Job description

AccessFares in Dallas seeks an ARC Specialist to ensure completeness and integrity of ARC IAR data and related reporting. You will reconcile airline ticketing and financial transactions, validate reporting accuracy, investigate discrepancies, and support weekly reporting and settlement while collaborating with Operations, Finance, IT, and Data Analytics.

The role emphasizes internal controls, ARC compliance, documentation, and continual process improvement, including automation opportunities.