Loyalty Program Financial Analyst

The Loyalty Program Financial Analyst ensures the financial integrity of the Company’s loyalty travel programs by reconciling high-volume transaction data, validating redemption activity, and tracking supplier commissions from purchase through settlement. This role analyzes large data sets across multiple systems—including travel platforms, financial systems, and payment processors—to confirm accuracy between points redemptions, cash value, supplier payments, and client billing. Through detailed reconciliation, reporting, and financial analysis, the analyst identifies discrepancies, resolves data issues, and delivers insights that support operational accuracy, program performance, and financial accountability across the loyalty ecosystem.

• Perform daily, weekly, and monthly reconciliation of high-volume transaction data across multiple systems including BI tools, General Ledger, travel booking platforms, payment processing systems, and banking records.
• Investigate and resolve reconciliation discrepancies in a timely and accurate manner to ensure financial integrity of loyalty program transactions.
• Validate the financial accuracy of travel redemptions, ensuring points usage aligns with cash values, supplier payments, and client settlement.
• Identify potential fraud indicators or irregular transaction activity and serve as a point of contact for investigation and resolution.
• Track and reconcile supplier commissions including amounts due, received, and reported.

• Generate regular reconciliation reports highlighting status, discrepancies, trends, and financial performance.
• Produce ad-hoc reporting and financial analysis to support Finance, Travel Operations, and leadership teams.
• Develop dashboards and reporting tools to track loyalty program KPIs, redemption trends, member engagement, and financial outcomes.
• Deliver quantitative analysis on commission activity and transaction trends across channels, products, and fulfillment patterns.

• Monitor data accuracy across systems and proactively identify inconsistencies within financial, booking, and reporting platforms.
• Partner with the Data Analytics team and other internal stakeholders to investigate and resolve system or data discrepancies.
• Pull and analyze source system reports to identify root causes of reconciliation issues.

• Develop deep expertise in travel transaction data, loyalty program mechanics, supplier commission structures, and operational workflows.
• Translate reconciliation findings into meaningful insights that support operational improvements and financial accuracy.
• Deliver reconciliation insights using available tools to present clear, actionable information for internal stakeholders.

• Maintain accurate documentation for reconciliation activities including transaction records, receipts, payments, and commission tracking.
• Support compliance reporting requirements, including ad-hoc analytics related to Canadian TICO reporting.
• Ensure reconciliation processes align with internal financial controls and audit readiness standards.
• Additional duties as assigned.

• Advanced proficiency in Excel and Power BI, with the ability to work confidently with large and complex data sets.
• Strong data analysis and financial modeling skills, including the ability to interpret large volumes of transactional data and identify meaningful patterns or discrepancies.
• Solid understanding of financial reconciliation processes, including payments, receipts, and transaction validation.
• Ability to translate complex data into clear business insights and actionable recommendations.
• Knowledge of loyalty program structures, particularly within the travel or rewards ecosystem, is preferred.
• Strong business acumen, with the ability to connect analytical findings to operational and financial impact.
• Excellent communication and presentation skills, with the ability to explain financial insights clearly to cross‑functional partners.
• Highl…