Job Description

About Shore360:

Shore360 is a 100% Australian-owned BP firm based in the Philippines, providing customized staffing and administrative support for international companies, handling recruitment, HR, IT, and office facilities so clients can focus on core business, offering transparent pricing, dedicated teams, and flexible setups.

Role Purpose

To support, maintain, and improve the day-to-day operation of data pipelines, reporting systems, integrations, and operational reporting infrastructure across Cin7 ERP, Shopify, marketplace platforms, 3PL systems, and reporting environments including Google BigQuery and Looker.

This role is responsible for ensuring reporting continuity, operational data accuracy, automation reliability, and integration stability while supporting business continuity across operational systems and reporting processes.

Key Objectives

· Ensure daily data pipelines and reporting run reliably

· Maintain accuracy of operational and commercial data

· Support automation and script execution

· Monitor and assist in resolving integration issues

· Improve documentation and business continuity

· Support continuity of business-critical reporting and operational processes

· Proactively identify reporting or integration issues before they impact operations

Systems Environment

· Cin7 ERP

· Google BigQuery

· Looker

· Shopify

· Marketplace integrations

· Elastic Suite B2B

· 3PL integrations

· Google Workspace

Core Responsibilities

1. Data Pipeline Monitoring & Maintenance

· Monitor scheduled data pipelines (API pulls, data loads, transformations)

· Extract and load data into Google BigQuery from Cin7 and connected platforms via APIs

· Maintain and monitor data within Google BigQuery

· Run SQL queries for validation, reconciliation, and troubleshooting

· Monitor scheduled jobs, API syncs, and reporting refreshes daily

· Perform proactive checks to ensure business-critical reporting remains operational

· Identify, troubleshoot, and escalate pipeline failures with clear documentation of findings

2. Reporting & Dashboard Support

· Maintain and update dashboards in Looker (or similar BI tools)

· Create and maintain Looker dashboards and reporting datasets using BigQuery data

· Support development and maintenance of operational dashboards based on business requirements

· Validate dashboard data against source systems

· Support structured operational and management reporting outputs

3. Automation & Script Execution

· Run and maintain scripts for order processing, data syncing, and reporting

· Automate recurring report generation and customer report distribution

· Monitor script performance and resolve operational issues

· Support improvements to automation and reporting processes

4. Marketplace & Systems Integration Support

· Support integrations between Cin7, Shopify, marketplace platforms, 3PL systems, and B2B platforms

· Monitor marketplace and external platform data feeds

· Assist in identifying root causes of integration and data sync issues

· Support maintenance and troubleshooting of marketplace integrations

5. Data Quality & Reconciliation

· Perform reconciliation across Cin7, Shopify, 3PL, marketplace, and reporting systems

· Identify discrepancies and escalate issues

· Support warehouse stock reconciliation with Cin7

· Ensure high levels of data accuracy across inventory, shipment, and operational reporting

6. Operational Reporting & Data Support

· Prepare recurring inventory and shipment reports

· Maintain operational trackers (inventory, inbound shipments, stock availability)

· Prepare weekly KPI packs for operations and management

· Support data preparation for planning and financial analysis

· Assist with data cleansing and product data preparation

7. Documentation & Process Improvement

· Create and maintain SOPs for recurring tasks

· Document data flows, APIs, scripts, reporting logic, and recovery procedures

· Support knowledge transfer and standardisation

· Ensure recurring operational tasks can be executed using documented processes

· Support continuity planning for reporting and operational systems

Required Skills & Experience

· 3–6 years experience in data operations, reporting, systems support, or business intelligence environments

· Strong SQL skills for querying, validation, reconciliation, and troubleshooting

· Experience with Google BigQuery or similar cloud data warehouse

· Experience working with APIs and data integrations

· Experience with dashboard tools such as Looker, Power BI, or Tableau

· Strong Excel / Google Sheets skills

· Ability to troubleshoot data inconsistencies and integration failures across multiple systems

· Strong written communication and issue escalation skills

· Ability to work independently in a remote environment

· Strong attention to detail and operational mindset

Nice to Have

· Python or scripting experience

· ERP experience (Cin7 preferred)

· E-commerce or marketplace platform experience

· Experience with automated reporting workflows

· Experience working within retail, distribution, or supply chain environments

Working Expectations

· Must be available for overlap with NZ business hours

· Comfortable working in a fast-paced operational environment

· Ability to manage recurring operational tasks consistently and accurately

· Able to work independently while proactively communicating issues and risks

Success in This Role Looks Like

· Reporting pipelines run reliably with minimal downtime

· Operational dashboards are accurate and trusted by the business

· Marketplace and API integrations remain stable and well monitored

· Inventory and shipment reports are delivered on time

· Data discrepancies are identified quickly and resolved efficiently

· Documentation is maintained and operational processes are repeatable

· Business-critical reporting continues reliably during staff absences or transitions

· Customer-facing reporting is automated and delivered accurately

ShoreXtra Perks

• Day 1 HMO Coverage
• Fixed Weekends Off – Enjoy a guaranteed work-life balance with Saturdays and Sundays off
• Join our Social Passion Clubs to connect with like-minded peers and bring your whole self to work every day
• 15 paid annual leave credits
• Referral Incentives – Get rewarded for bringing top talent to the team via our referral program.
• Statutory Benefits: Maternity, Paternity, and Solo Parent Leaves, Magna Carta for Women, OT, and Premium Pays

Work Schedule and Setup:

• Remote
• Dayshift, Monday - Friday 6:00 am - 3:00 pm
• Full time