Business Intelligence Analyst

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

📋 Description

• Take initiative in prioritizing, designing, developing, and implementing reconciliation and reporting solutions, which encompass matching logic, break dashboards, exception queues, settlement summaries, and standardized journals.

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

• Manage discrepancies from identification through root cause analysis, corrective actions, and enhancements in control measures.

• Establish and implement reconciliation and reporting metrics, such as match rates, break aging, time-to-resolution, funding compliance, and reporting service level agreements (SLAs).

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

• Create, develop, and document automated reporting solutions using SQL.

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

• Identify control weaknesses, revenue losses, manual processes, and data quality issues; lead initiatives for automation and process enhancements.

• Work in partnership with Engineering, Product, Accounting, Treasury, Tax, and Compliance teams.

• Direct month-end close support, reconciliation reporting, standardized summaries, and documentation that meets audit requirements.

• Define business specifications and testing plans; validate system modifications and address bugs.

• Assist in onboarding and mentoring analysts, review code, and advocate for reconciliation and reporting best practices.

• Employ an AI-first approach to enhance analytical tasks and promote responsible use of AI technologies.

⛳️ Requirements

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

• Proficiency in SQL at an expert level.

• Experience in independently managing reconciliation, settlement, or financial reporting workflows from start to finish.

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

• Proven 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.

• Exceptional communication skills and adeptness in managing relationships with senior stakeholders.

• Demonstrated history of implementing process improvements and automation.

• Preferred qualifications: experience in card network reconciliation and settlement, funds-transfer processes and systems, Python or similar scripting languages, cloud data warehouses, BI platforms, interchange and fee/cost reconciliation, tax or regulatory reporting, audits, internal controls, SOX-related processes, and mentoring junior analysts.

🏝️ Benefits

• Opportunity to work remotely.

• Comprehensive medical insurance.

• Flexible time-off policy.

• Retirement savings plans available.

• Modern family planning options.

• Reasonable accommodations for applicants with disabilities.

• An inclusive interview experience.