Business Intelligence Analyst
Core
Senior Analyst owning end-to-end reconciliation and financial reporting for post-transaction systems, ensuring funds are in the right place at the right time for a global payments ecosystem.
Role type
Senior IC Business Intelligence Analyst (Reconciliation & Reporting)
Builds
Automated SQL-based reporting, match logic, break dashboards, exception queues, settlement summaries, and standardized journals.
Domain
Payments & Financial Services (Settlement, Reconciliation, Regulatory Reporting)
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Expert SQL, Accounting principles (double-entry), Data pipeline design, Stakeholder management, Process automation, Advanced Excel, Root cause analysis
Preferred skills
Card-network reconciliation (Visa/Mastercard), Funds-transfer rails (ACH/SWIFT), Python scripting, Cloud data warehouses (Snowflake/BigQuery), BI platforms (Looker/Tableau), Audit/SOX experience
Technologies
SQL, Python, Excel, Snowflake, BigQuery, Looker, Tableau, Visa/Mastercard portals
Responsibilities
Independently own reconciliation workstreams for card networks and banking partners; Design and deploy automated SQL reporting and exception handling; Translate business/regulatory needs into concrete metrics and controls; Partner with data engineering to build and maintain data pipelines; Lead month-end close support and audit documentation; Mentor junior analysts and drive process improvements.
Seniority
Senior, hands-on IC with mentorship responsibilities