Business Intelligence Analyst

Block

. Independently prioritize, design, develop, and deploy reconciliation and reporting solutions, including matching logic, break dashboards, exception queues, settlement summaries, and standardized journals .

Posted 11/4/2026full-timeRemote • California • United StatesMid-LevelSenior💰 $108,200 - $202,800 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in reconciliation, settlement, and financial reporting, with a strong focus on SQL-based reporting and process automation. Proven ability to manage discrepancies, define metrics, and collaborate with cross-functional teams to enhance operational efficiency.

Highest-signal resume keywords

Expert-Level SQLReconciliation Tooling ExperienceAdvanced Excel ProficiencyProcess Improvement Track RecordStakeholder Relationship Management

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ReconciliationSettlementFinancial ReportingData Pipeline DevelopmentAccounting PrinciplesDouble-Entry ConceptsAutomationData Quality ManagementBreak DashboardsException Queues

Soft Skills

Excellent Communication SkillsMentoringCollaboration

Tools & Technologies

Banking PortalsCloud Data WarehousesBI PlatformsPythonSQL

Industry Keywords

Payment OperationsFunds-Transfer ProcessesTax ReportingRegulatory ReportingSOX-Adjacent Processes

Tech Stack

Tools & technologies

CloudPythonRuby on RailsSQL

About the role

Key responsibilities & impact

Independently prioritize, design, develop, and deploy reconciliation and reporting solutions, including matching logic, break dashboards, exception queues, settlement summaries, and standardized journals
Own daily, weekly, and monthly reconciliations across card networks, banking partners, processors, and internal transaction and ledger data
Manage discrepancies from detection through root cause, corrective action, and control improvement
Define and roll out reconciliation and reporting metrics, including match rates, break aging, time-to-resolution, funding compliance, and reporting SLAs
Serve as subject matter expert on settlement, funding, and money-movement flows
Design, develop, and document automated SQL-based reporting
Partner with data engineering to build, validate, troubleshoot, and maintain datasets and pipelines
Identify control gaps, revenue leakage, manual toil, and data-quality issues; drive automation and process improvements
Collaborate with Engineering, Product, Accounting, Treasury, Tax, and Compliance stakeholders
Lead month-end close support, reconciliation reporting, standardized summaries, and audit-ready documentation
Define business requirements and test plans; validate system changes and resolve bugs
Help onboard and mentor analysts, review code, and promote reconciliation and reporting best practices
Apply an AI-first mindset to improve analytical work and guide responsible AI use

Requirements

What you’ll need

5+ years of related 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 work experience
Expert-level SQL
Experience independently owning reconciliation, settlement, or financial reporting workstreams end to end
Strong knowledge of accounting principles, double-entry concepts, and money movement
Experience designing, building, validating, and maintaining data pipelines
Advanced Excel proficiency, including complex formulas and pivot tables
Experience with reconciliation tooling and banking portals
Excellent communication skills and senior stakeholder relationship management
Track record of process improvements and automation
Preferred: experience with card-network reconciliation and settlement, funds-transfer processes and rails, Python or similar scripting, cloud data warehouses, BI platforms, interchange and fee/cost reconciliation, tax or regulatory reporting, audits, internal controls, SOX-adjacent processes, and mentoring junior analysts

Benefits

Comp & perks

Remote work
Medical insurance
Flexible time off
Retirement savings plans
Modern family planning
Reasonable accommodations for disabled applicants
Inclusive interview experience