Data Analyst

Brickstech; Karachi Division; On-site; PKR 600,000 - 1,200,000; Full time

Job summary

Brickstech in Lahore, Pakistan, is seeking a financial data reconciliation specialist to own end-to-end reconciliation of cash inflows and outflows across bank statements and internal systems.

You will perform daily and monthly reconciliations, investigate discrepancies, maintain schedules, and develop automated checks to improve accuracy and reporting; collaborate with Finance, Operations and Technology teams to drive data quality and controls.

Qualifications

• Bachelor's degree in data/finance or related field with 2–4 years in data analysis or reconciliation.
• Experience with financial data reconciliation and banking/payment data.
• Strong analytical skills and attention to detail.
• Experience with SQL and reporting/visualization tools.

Responsibilities

• Own end-to-end reconciliation of customer inflows and outflows, including transaction-level matching.
• Perform daily/monthly reconciliations; investigate unmatched or incorrect transactions.
• Maintain reconciliation schedules and exception reports with timely clearance.
• Make controlled database-level corrections with documentation of changes.
• Monitor data consistency across systems and identify root causes of issues.
• Prepare operational and financial reports, dashboards, and ad-hoc analyses.
• Use SQL and data analysis to identify trends and quantify issues.
• Support Tech in debugging data/system issues and coordinate testing.
• Develop recurring reports and automated checks to improve accuracy.
• Document reconciliations and data changes for audit trails.

Skills

SQL

BigQuery

PostgreSQL

Data analysis

Financial reconciliation

Google Sheets

Apps Script

ETL tools

Attention to detail

Education

Bachelor's degree in Data, Finance, Accounting, Economics, Statistics or related field

Tools

Metabase

Power BI

Tableau

AWS Glue

Job description

Get featured above free applicants, with a note recruiters actually read.

Job Description

Lahore

On-site

Full-time

3–5 Years

• Own the end-to-end reconciliation of customer inflows and outflows, including transaction-level matching between bank statements, payment processors, internal systems and database records.
  
• Perform daily/monthly reconciliations, investigate unmatched, duplicated, missing or incorrectly recorded transactions, and coordinate with Finance, Operations and Technology teams to resolve discrepancies.
  
• Maintain reconciliation schedules and exception reports, ensuring outstanding items are properly tracked, investigated and cleared within agreed timelines.
  
• Perform controlled database-level corrections and updates where required to ensure transaction records accurately reflect underlying bank/payment transactions, with appropriate validation and documentation of all changes.
  
• Monitor data consistency and integrity across systems and identify the root causes of discrepancies, with a focus on resolving underlying system or process issues rather than relying on recurring manual adjustments.
  
• Handle cross-functional data requests and prepare operational and financial reports, dashboards and ad-hoc analysis for Finance, Operations, Product and Management.
  
• Use SQL and data analysis to identify trends, anomalies, data quality issues and operational inefficiencies, and translate findings into actionable recommendations.
  
• Support the Technology team in debugging data and system issues by providing business context, validating system outputs and coordinating testing of system fixes and enhancements.
  
• Develop and maintain recurring reports, dashboards and automated checks, with a focus on improving the accuracy, timeliness and scalability of financial and operational reporting.
  
• Identify opportunities to automate reconciliation and reporting processes, reduce manual intervention and strengthen controls around financial data.
  
• Work closely with Finance, Operations, Product and Technology teams to improve data flows, reporting processes and financial controls, and track recurring issues through to resolution.
  
• Maintain appropriate documentation for reconciliations, database adjustments, data issues and process changes to ensure a clear audit trail and continuity of processes.
  

Required Skills

• Strong SQL skills, with hands-on experience querying BigQuery and PostgreSQL.
  
• Practical experience with financial reconciliation, transaction-level data and banking/payment data.
  
• Understanding of database structures and experience performing controlled data corrections or updates.
  
• Experience with reporting/visualization tools; Metabase preferred, with Power BI or Tableau also acceptable.
  
• Strong Google Sheets skills; Apps Script experience for automation is preferred.
  
• Familiarity with AWS Glue or similar ETL/data pipeline tools.
  
• Strong analytical and problem-solving skills with exceptional attention to detail.
  
• Ability to investigate discrepancies and perform root-cause analysis independently.
  
• Strong cross-functional communication skills and ability to work effectively with Finance, Operations and Technology teams.
  
• Python fundamentals are a plus.
  

Qualifications

Bachelor's degree in Data, Finance, Accounting, Economics, Statistics or a related field, with 2–4 years of experience in data analysis, financial reporting, reconciliation, fintech operations or a related analytical role. Experience working with financial transaction data, banking/payment systems or financial reconciliations is strongly preferred.