Data Analyst - Financial Reconciliation & SQL

About the role

This is a hands-on data analytics role centred on writing SQL to extract, transform and reconcile large volumes of financial and operational data. The successful candidate spends much of their time writing SQL and building data-driven solutions rather than preparing manual reports or coordinating data requests.

Key responsibilities

• Write and maintain complex SQL queries in BigQuery and PostgreSQL to extract, transform, reconcile and analyse financial and operational data.
• Build SQL-based checks to reconcile bank statements, payment processors and internal systems, and investigate discrepancies by tracing transactions across tables and systems.
• Work with Finance to turn accounting and reporting requirements into SQL logic, and perform controlled database corrections following validation and approval procedures.
• Build data quality checks and reconciliation controls in SQL, and develop dashboards and recurring reports in Metabase or similar BI tools.
• Support automation of reporting with scalable SQL datasets, scheduled queries and automated validation checks.
• Collaborate with Technology and Product teams to validate system outputs and test changes, and document SQL logic, reconciliation rules and accounting mappings.

Required profile

• Bachelor's degree in Data Science, Computer Science, Finance or a related field.
• 2-4 years of hands-on experience in data analytics, SQL-based analysis, financial data, fintech, payments or a related analytical role.
• Experience transforming raw transactional data into structured datasets for financial reporting, accounting, reconciliation or analytics.

Required skills

• Advanced SQL, including CTEs, joins, subqueries, window functions, aggregations, CASE statements, date/time functions and UNIONs.
• Strong hands-on experience with Google BigQuery and PostgreSQL.
• Experience with BI/reporting tools such as Metabase, Power BI or Tableau.
• Familiarity with ETL concepts and tools such as AWS Glue is a plus.