Revenue Analyst – Farebox Reconciliation

The Revenue Analyst - Farebox Reconciliation will reconcile differences between said-to-contain amounts for total funds removed from MBTA Fareboxes versus actual total amounts verified/counted by the MBTA vendor. The role includes researching and documenting all reported daily variances. This process requires collaboration with the MBTA Cash Reconciliation Specialist, MBTA cash collection vendor(s), MBTA Farebox Maintenance, MBTA garage and carhouse forepersons, MBTA AFC Systems, and other areas/departments as needed.

This role provides assistance with the tracking and daily reporting associated with vendor cash collection services provided for fare vending machine (FVM) devices.

• Collect and maintain history of MBTA Vault Agent Logs.
• Collect and maintain history of mobile vault drop sheets from MBTA cash collection vendor.
• Collect and maintain history tickets/receipts from MBTA cash collection vendor.
• Compare said-to-contain against counted cash and coin, ticket sum against Daily Vault Agent Log, Mobile Vault Drop Sheets, Mobile Vault Audit Reports, and Cashbox History Report to ensure accuracy of what is listed in the AFC system as having been removed from the bus/trolley was vaulted and recorded.
• Analyze all discrepancies in the data and reports utilizing all tools necessary to determine the events and/or past histories in the reporting that led to discrepancy.
• Escalate unknown differences and discrepancies as needed.
• Assist with updating daily system-wide reporting for purposes of scheduling and monitoring of FVM cash collection activity.
• Assist with review of daily cash settlement reports reconciling accuracy of daily cash deposit.
• Assist with auditing of Vendor monthly billing ensuring accurate billing for services provided.
• Assist with management of MBTA test fund pool used for completing FVM cash test transactions.
• Record and document all findings accordingly.
• Perform all other duties and projects that may be assigned.

Additional responsibilities may include focus on one or more departments or locations. See applicable addendum for department or location specific functions.

• No direct reports.

• A Bachelor’s Degree from an accredited institution in Finance, Business, Public Administration, Economics, or related field.
• Two (2) years of experience in financial and/or program analysis, including analyzing discrepancies in data and reports using Microsoft Excel and/or a database application, and preparing concise variance narratives that document root cause.
• The ability to effectively use Microsoft Word, Excel and Database applications.
• Ability to effectively communicate with customers, employees, vendors, contractors and state and federal agencies.
• Excellent customer service, conflict resolution, negotiation, communication, speaking and writing skills.
• Ability to work effectively with a diverse workforce.
• Ability to provide internal and external customers with a courteous and professional experience.
• Respond to each inquiry, whether from a customer, vendor or co-worker in a courteous and professional manner.

• A High School Diploma or GED with an additional seven (7) years of directly related experience substitutes for the bachelor’s degree requirement.
• An Associate Degree from an accredited institution an additional three (3) years of directly related experience substitutes for the bachelor’s degree requirement.
• A Master’s Degree in a related subject substitute for two (2) years of general experience.
• A nationally recognized certification, or statewide/professional certification in a related field substitutes for one year of experience.

• Professional experience with cash reconciliation.
• Experience reviewing vendor invoices and monthly billing, including comparing billed services to contract terms and supporting audit adjustments.