Business Intelligence Analyst

This is a fully remote position, open to applicants in Canada.

📋 Description

• Become a member of the Recon and Reporting team, which is in charge of post-transaction reconciliation and reporting systems.

• Take the initiative to prioritize, design, develop, and implement reconciliation and reporting solutions independently.

• Oversee daily, weekly, and monthly reconciliations involving card networks, banking partners, processors, and internal transaction and ledger data.

• Handle discrepancies from their detection through to root cause analysis, corrective actions, and enhancements in control.

• Establish and implement metrics for reconciliation and reporting.

• Act as a subject matter expert regarding settlement, funding, and money movement processes.

• Create, develop, and document automated reporting based on SQL.

• Collaborate with data engineering to construct, validate, troubleshoot, and maintain datasets and pipelines.

• Detect control gaps, revenue leaks, manual inefficiencies, and data quality concerns; advocate for automation and process enhancements.

• Work together with stakeholders from Engineering, Product, Accounting, Treasury, Tax, and Compliance.

• Lead support for month-end close and prepare audit-ready documentation.

• Specify requirements and testing plans for system modifications; validate processes and address bugs.

• Mentor and onboard analysts, review code, and encourage best practices.

• Utilize an AI-first approach in analytical tasks and promote responsible AI usage.

⛳️ Requirements

• A minimum of 5 years of relevant experience in reconciliation, settlement, payment operations, accounting, or finance analytics with a Bachelor's degree; or 3 years with a Master's degree; or equivalent professional experience.

• Proficient in SQL at an expert level.

• Proven experience in independently managing reconciliation, settlement, or financial reporting workstreams from start to finish.

• Strong understanding of accounting principles, double-entry accounting, and money movement.

• Experience in designing, building, validating, and maintaining data pipelines.

• Advanced skills in Excel, including complex formulas and pivot tables.

• Familiarity with reconciliation tools and banking portals.

• Excellent communication abilities and experience managing relationships with senior stakeholders.

• Demonstrated history of process enhancements and automation initiatives.

• Preferred qualifications include experience with card-network reconciliation and settlement; familiarity with ACH, wire, SWIFT, RTP/FedNow, and the payments ecosystem; knowledge of Python or similar scripting languages; experience with cloud data warehouses; BI platforms; interchange and fee/cost reconciliation; audit, internal controls, or SOX-related processes; and mentoring junior analysts.

🏝️ Benefits

• Remote work opportunities.

• Medical insurance coverage.

• Flexible time off policies.

• Retirement savings plans available.

• Modern family planning options.