Remote Data Automation & Analytics Lead

HyreUp; Quezon City; Remote; PHP 2,297,000 - 4,595,000; Full time

Job summary

HyreUp is recruiting an Automation & Data Analytics Specialist for a U.S. moving and storage client. The role is fully remote, with responsibility for designing and automating department scorecards, dashboards, and payroll-related data feeds across multiple systems.

You will develop scalable BI platforms, replace spreadsheets, and ensure accuracy in incentive and bonus calculations, with daily data feeds and SOPs for ongoing management. Excellent Google Sheets and scripting skills are essential.

Qualifications

• 5+ years in data analytics, reporting, or operations automation (moving, logistics, or field services preferred).
• Expert-level Google Sheets: QUERY, ARRAYFORMULA, IMPORTRANGE, pivot tables, conditional formatting, and data validation.
• Advanced Google Apps Script, including custom menus, triggers, and scripts that rebuild output tabs.
• Experience building weighted scorecards, incentive models, or performance dashboards.
• Samples of scorecards, dashboards, or trackers you have built (you will be asked to share them).
• Experience preparing or validating payroll, commission, or incentive data.
• Experience reconciling data across a CRM, phone system, telematics, and project management tool.
• Strong written English and clear, concise reporting.
• Reliable high-speed internet and a dedicated home office.

Responsibilities

• Automate recurring manual work: pay period setup, multi-system data pulls, incentive calculations, and previous-day job feeds.
• Build live executive dashboards so managers can self-serve instead of waiting on reports.
• Include validation checks, a documented SOP, and a manual fallback with every automation.
• Support fleet data in Samsara and Motive, including preventive maintenance schedules, as needed.
• Design and implement scalable department scorecard systems with master tabs, weights, and executive dashboards.
• Write and maintain Google Apps Script that refreshes outputs and runs triggers; keep calculation logic protected.
• Document every metric in a calculation index and column map for traceability and auditing.
• Build data quality checks that flag mismatches, duplicates, or missing inputs before use.
• Automate data syncs from previous-day data for all locations; map data from various sources into correct tabs.
• Submit reports to managers on schedule and resolve data gaps with named owners.

Skills

Data analytics

Reporting

Google Sheets

Google Apps Script

Scorecards/dashboards

Payroll/incentive data

Data reconciliation across systems

Clear written English

Tools

Looker Studio

Samsara

Motive

Asana

RingCentral

Qube Sheets

Zapier

Job description

HyreUp is recruiting an Automation & Data Analytics Specialist for a U.S. moving and storage client. The role is fully remote, with responsibility for designing and automating department scorecards, dashboards, and payroll-related data feeds across multiple systems.

You will develop scalable BI platforms, replace spreadsheets, and ensure accuracy in incentive and bonus calculations, with daily data feeds and SOPs for ongoing management. Excellent Google Sheets and scripting skills are essential.