Senior Operations & Finance Analyst (Google Sheets & Xero)

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Full Time

SALARY

40,000 PHP

HOURS PER WEEK

40

DATE UPDATED

Apr 10, 2026

JOB OVERVIEW

Location: Remote – Philippines
Employment Type: Full-time
Reporting to: Operations / Finance Leadership
Type of Employment: Assume full time, BUT we will consider flexibility if the role can be covered in 20-30 hrs per week.

About WCJ:

We are a growing, operations-led service business based in London UK. We have a core office team of 8, including 2 valuable members in the Philippines. As part of our growth strategy this year, we are building better data accuracy, and focusing on key metrics. We've always had stronger financial controls, but would like to support the person covering our financial controller role.

Our core values are non-negotiable:

Trust & Respect – for our people, our clients, and our environment

Low Hassle – simple, efficient solutions over complexity

Ownership – we take responsibility and follow issues through

Problem Solving – we solve problems and own both success and failure

Kindness – results matter, but people matter too

We are building long-term systems and a long-term team.

Role Overview

This is a critical analytical and control role responsible for the daily integrity of our operational and financial data. You will ensure that three core systems are fully reconciled on a daily basis:

Daily Operations Reporting

Job Management System

Xero Accounting Software

You will own the master operational spreadsheet, ensure all inputs and outputs are correct, and provide accurate, timely metrics to senior management. This role requires strong analytical thinking, excellent spreadsheet engineering skills, and confidence working with accounting data.

Key Responsibilities

Own daily reconciliation between operational reports, job system data, and Xero

Design, maintain, and optimise advanced Google Sheets (array formulas, QUERY, nested logic, error handling, dashboards)

Ensure revenue, costs, invoices, and operational volumes align across all systems

Identify discrepancies, investigate root causes, and resolve or escalate appropriately

Support accounts receivable and credit control, including invoice tracking and exception reporting

Assist with Xero reconciliations and data integrity checks

Produce daily, weekly, and monthly management metrics and performance reports

Improve data workflows, controls, and reporting processes over time

Act as a trusted data and reporting partner to operations and finance leadership

Technical Requirements

Essential:

Advanced Google Sheets expertise, including complex formulas, data validation, reconciliation logic, and structured reporting

Proven experience using Xero accounting software in a professional environment

Strong understanding of operational finance, reconciliations, and revenue tracking

High attention to detail with the ability to work accurately at speed

Experience reconciling data across multiple systems

Strong written English and clear documentation skills

Highly Desirable:

Experience building dashboards or KPI reporting for management

Background in finance operations, business analysis, or accounting support

Experience with job management or service-based businesses

Process improvement mindset with automation experience (where appropriate)

What Success Looks Like:

Daily reports are accurate, reconciled, and trusted by management

Discrepancies are identified early and resolved quickly

The master spreadsheet is clean, structured, and scalable

Leadership has clear visibility of performance through reliable metrics

Systems and processes improve continuously as the business grows

What We Offer:

Fully remote, long-term role

High level of ownership and autonomy

A values-driven business that balances performance with kindness

Opportunity to grow into a senior operations, finance, or systems role over time

Stability, trust, and clear expectations

How to Apply:

Please apply via OnlineJobs.ph and include:

A summary of your experience with Google Sheets and Xero

Examples of complex reconciliation or reporting work you’ve owned

Any experience improving or automating reporting processes

We’re looking for someone who takes pride in accuracy, ownership, and building systems that scale. Whilst we currently expect this role to be full time, we would consider some flexibility / part time (but we do need consistent hours and more than 20 hrs per week ideally)

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin
  BENCHMARKS  
Loading Time: Base Classes  0.0007
Controller Execution Time ( Jobseekers / Job )  0.0143
Total Execution Time  0.0156
  GET DATA  
No GET data exists
  MEMORY USAGE  
1,514,328 bytes
  POST DATA  
No POST data exists
  URI STRING  
jobseekers/job/Senior-Operations-Finance-Analyst-Google-Sheets-Xero-1559332
  CLASS/METHOD  
jobseekers/job
  DATABASE:  onlinejobs (Jobseekers:$db)   QUERIES: 13 (0.0093 seconds)  (Hide)
0.0003   SELECT *
                                
FROM exrates
                                WHERE rate_name 
'USD-PHP' 
0.0004   SELECT *
FROM `employer_jobs`
WHERE `job_id` = 1559332
 LIMIT 1 
0.0012   SELECT *
FROM `employers`
WHERE `employer_id` = 614084
 LIMIT 1 
0.0008   SELECT COUNT(*) AS `numrows`
FROM `t_thread` `t`
LEFT JOIN `t_thread_misc` `miscON `t`.`id` = `misc`.`thread_id`
WHERE `t`.`job_id` = 1559332
AND `misc`.`idIS NULL 
0.0005   SELECT e.business_namee.logoe.websitee.rebill_datee.date_added member_datehitsDATEDIFF('2026-04-15',ej.date_added) duration_daysDATEDIFF('2026-04-15',e.rebill_date) duration_rebillej.*, e.deactivate FROM employers eemployer_jobs ej WHERE e.employer_id ej.employer_id AND
                                   ((
e.user_level >= '500' AND ej.date_added <= e.rebill_date)
                                   OR 
e.employer_id '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-04-15',ej.date_added) <= 14 ))
                                   AND 
e.deactivate != AND ej.deleted AND job_id '1559332' 
0.0007   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1559332 
0.0008   UPDATE employer_jobs SET hit_counts '***Jan-20-2026=82***Jan-21-2026=42***Jan-22-2026=27***Jan-23-2026=31***Jan-24-2026=12***Jan-25-2026=13***Jan-26-2026=15***Jan-27-2026=8***Jan-28-2026=7***Jan-29-2026=3***Jan-30-2026=5***Jan-31-2026=2***Feb-01-2026=6***Feb-02-2026=4***Feb-03-2026=3***Feb-04-2026=5***Feb-05-2026=2***Feb-06-2026=1***Feb-07-2026=2***Feb-08-2026=1***Feb-09-2026=2***Feb-11-2026=2***Feb-13-2026=1***Feb-15-2026=5***Feb-17-2026=3***Feb-18-2026=1***Feb-21-2026=1***Feb-22-2026=4***Feb-23-2026=2***Feb-24-2026=3***Feb-26-2026=3***Feb-28-2026=2***Mar-02-2026=1***Mar-04-2026=2***Mar-05-2026=2***Mar-10-2026=1***Mar-12-2026=3***Mar-13-2026=2***Mar-15-2026=1***Mar-17-2026=2***Mar-19-2026=1***Mar-22-2026=2***Mar-24-2026=2***Mar-25-2026=1***Mar-26-2026=2***Mar-27-2026=1***Apr-02-2026=1***Apr-05-2026=2***Apr-06-2026=1***Apr-08-2026=4***Apr-09-2026=4***Apr-10-2026=297***Apr-11-2026=50***Apr-15-2026=2' WHERE job_id'1559332'  
0.0007   UPDATE employer_jobs SET monthly_hits '***Jan-2026=247***Feb-2026=53***Mar-2026=23***Apr-2026=361' WHERE job_id'1559332'  
0.0012   SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id '' AND job_id '1559332' AND status LIKE 'sent%' ORDER BY id DESC  
0.0003   SELECT *
FROM `employer_jobs_skills` `ejs`
LEFT JOIN `skills_categories` `scON `ejs`.`skill_id` = `sc`.`id`
WHERE `job_id` = 1559332 
0.0020   SELECT COUNT(*) AS `numrows`
FROM `employer_jobs`
WHERE `employer_id` = '614084'
AND `date_added` >= '2022-06-08' 
0.0003   select from teasers 
0.0002   SELECT FROM skill_categories WHERE skill_cat_id='' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)