Business Intelligence Analyst
San Francisco, CA$108.2k - $202.8kfull-timePosted 3w ago
About the role
Senior Analyst role within the Recon and Reporting team responsible for reconciliation, settlement, and financial reporting for post-transaction systems across card networks, banking partners, processors, and internal ledgers. Focus on end-to-end ownership of reconciliation and automated SQL-based reporting, with collaboration across Engineering, Product, Accounting, Treasury, Tax, and Compliance to ensure accurate funds movement and regulatory reporting.
Responsibilities
- Independently prioritize, design, develop, and deploy end-to-end reconciliation and reporting solutions: matching logic, break dashboards, exception queues, settlement summaries, and standardized journals that feed downstream accounting, audit, and regulatory processes.
- Own time-sensitive daily, weekly, and monthly reconciliations across card networks, banking partners, processors, and internal transaction and ledger data, including full ownership of discrepancy management from detection through root cause, corrective action, and control improvement.
- Translate ambiguous business, finance, and regulatory needs into concrete measurement systems: define and roll out key metrics for the reconciliation and reporting domain (match rates, break aging, time-to-resolution, funding compliance, reporting SLAs) and ensure stakeholders interpret them in the correct context.
- Serve as the subject matter expert on settlement, funding, and money-movement flows; field questions on transaction lifecycles, data models, and the reconciliation tech stack from stakeholders and leadership.
- Own the design, development, and documentation of automated SQL-based reporting using best practices, navigating new and unfamiliar datasets to answer complex questions about the flow of funds.
- Work independently or partner with data engineering to design, build, validate, troubleshoot, and maintain the datasets and pipelines that power reconciliation and reporting, making sound trade-offs between accuracy, implementation effort, and complexity.
- Proactively identify control gaps, revenue leakage, manual toil, and upstream data-quality issues; drive automation and process improvements that fix them, and monitor daily settlement and banking activity for irregularities.
- Own relationships with technical and non-technical stakeholders across Engineering, Product, Accounting, Treasury, Tax, and Compliance; directly influence the priorities, decisions, and roadmap of the team and its partners.
- Lead month-end close support for the domain: reconciliation reporting, standardized summaries, and audit-ready documentation, including supporting internal and external audits.
- Define business requirements and test plans for system changes, validate new processes and reconciliation capabilities before deployment, and partner with Engineering and Data teams to resolve bugs and ship enhancements.
- Help onboard and mentor other analysts, including reviewing code and evangelizing reconciliation and reporting best practices.
- Apply an AI-first mindset to improve the speed, quality, and insight of analytical work, and guide responsible AI use on the team.
Qualifications
- 5+ years of related experience in reconciliation, settlement, payment operations, accounting, or finance analytics with a Bachelor's degree (Finance, Accounting, Economics, a quantitative field, or similar); or 3+ years with a Master's degree; or equivalent work experience.
- Expert-level SQL, including owning the design, development, and documentation of automated SQL-based reporting, and the ability to navigate new datasets and answer complex questions independently.
- Demonstrated experience independently owning reconciliation, settlement, or financial reporting workstreams end to end, including defining metrics and driving them to adoption.
- Strong knowledge of accounting principles, double-entry concepts, and the mechanics of money movement, with the judgment to question the correctness and completeness of financial data.
- Experience partnering with data engineering (or working independently) to design, build, validate, and maintain data pipelines, with the ability to make sound technical trade-offs.
- Advanced Excel proficiency (complex formulas, pivot tables) and experience with reconciliation tooling and banking portals.
- Excellent communication skills: able to own senior stakeholder relationships, present findings and recommendations, and drive clear next steps in areas without clear ownership.
- Track record of proactively identifying and delivering process improvements and automation in a deadline-driven, high-accuracy environment.
Skills
Required:SQLData warehousing and pipelinesAccounting principles
Benefits
- Remote work
- medical insurance
- flexible time off
- retirement savings plans
- modern family planning
Last updated Sep 30, 2026. Interested? Apply on the company site.
About Block
Block builds technology to increase access to the global economy.
Made up of Square, Cash App, Afterpay, TIDAL, Bitkey, and Proto, Block, Inc. builds technology to increase access to the global economy.
technologyfinancial servicesdigital paymentsmusic streaming
More open roles at Block
- Implementation Specialist - Bilingual (Spanish) PST Timezone4d agoBay Area, CA · 20333 S&M - Sales - GSO
- SMB Account Executive4d agoMelbourne · 20209 S&M - Sales - Square Inside
- Mid-Market Account Excutive4d agoHybrid (Sydney) · 20213 S&M - Sales - Square Outside
- Territory Account Executive, Philadelphia, PA4d agoHybrid (Philadelphia, PA) · 20249 S&M - Sales - Square Field Sales
- Sales Enablement Program Manager4d agoToronto, ON · 20408 S&M - Sales - Square RevOps & Enablement