Automation And Data Analytics Specialist Moving And Storage

Hyre; Quezon City; Remote; PHP 4,459,000 - 7,006,000; Full time

Benefits offered by this job

Remote work

Job summary

Hyre is hiring an Automation & Data Analytics Specialist for a U.S. moving and storage client. The role focuses on automating driver scorecards, building department dashboards, and standardizing reporting with SOPs for daily execution.

You will implement, refine, and scale dashboards, automate payroll-related data, and ensure data quality across multiple systems. Strong Google Sheets and Apps Script skills are essential, along with English communication.

Qualifications

• 5+ years in data analytics, reporting, or operations automation in moving/logistics.
• Expert Google Sheets: QUERY, ARRAYFORMULA, IMPORTRANGE, pivots, validation.
• Advanced Google Apps Script for automated tabs and triggers.
• Experience building weighted scorecards, dashboards, or trackers.
• Payroll/incentive data prep and reconciliation experience.
• Data reconciliation across CRM, telephony, telematics, and PM tools.
• Strong written English and concise reporting.
• Reliable home office with high-speed internet.

Responsibilities

• Automate recurring tasks: pay period setup, multi-system pulls, incentive calc, daily feeds.
• Build live executive dashboards enabling self-serve reporting.
• Document SOPs, include validation checks and manual fallbacks.
• Support fleet data in Samsara and Motive; maintain preventive maintenance data.
• Design scalable department scorecards and phase out spreadsheets.
• Prepare payroll-ready incentive totals and reconcile against wage data.
• Maintain data quality checks and flag gaps with owners named.
• Deliver daily EOD/EOW reports and run weekly reviews.

Skills

Google Sheets

Google Apps Script

Data analytics

Dashboard development

Payroll data handling

Data reconciliation

English writing

Home office setup

Tools

SmartMoving

Google Sheets

Looker Studio

Excel

RingCentral

Asana

Motive

Samsara

Qube Sheets

Job description

Job Description:

Automation & Data Analytics Specialist (Moving & Storage)

Full-time | Remote | Hiring through Hyre for a U.S. moving and storage company

About the Client

Our client is a multi-location moving and storage company with operations in Bakersfield, Phoenix, and Santa Rosa. They handle local and interstate moves and run on daily data: sales performance, driver incentives, customer quality, safety, and payroll.

About the Role

The client relies on advanced data analytics and reporting systems to drive operational performance across all departments. You will implement and refine their existing Driver Scorecard dashboard, then build similar dashboards for every department, automating them for daily execution with clear SOPs for ongoing management.

Design scalable department scorecards, eventually phasing out spreadsheets in favor of a dedicated reporting platform. This role also prepares the incentive and bonus data that feeds payroll, so accuracy is non-negotiable.

What Youll Do

Automation and Process Improvement

• 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

Build Department Scorecard Systems

• Design and implement scalable department scorecard systems, evaluating transitions from spreadsheet-based models to dedicated BI platforms or custom web reporting applications as business needs expand. Structure each workbook with raw source tabs, a master consolidated tab, an editable incentive and weights matrix, calculation tabs, an executive summary dashboard, and printable individual scorecards

• Combine weighted performance pillars (for example revenue, attendance, customer satisfaction, claims, safety, and conduct) into one overall score and standing such as Exemplary, Standard, Coaching, or Disciplinary Review

• Write and maintain Google Apps Script that refreshes outputs, runs scheduled and on-edit triggers, and keeps calculation logic protected

• Document every metric in a calculation index and column map so each formula is traceable and auditable

• Build data quality checks that flag unmatched IDs, name mismatches, duplicates, and missing inputs before any score is used

Daily Scorecard Management and Report Delivery

• Automate data syncs from previous-day data every morning for all three locations

• Import and map data from SmartMoving, RingCentral, Qube Sheets, Asana, Motive, attendance records, Google Reviews, internal crew ratings, and damage claims into the correct source tabs

• Keep employee profiles and IDs consistent across every source, and add new hires to every scorecard

• Resolve data quality flags daily and document zero-activity exceptions with evidence

• Submit each report to the appropriate manager on schedule: department scorecards, Driver Incentive Reports, QC reports, and the Interstate Booking Load Board

• Flag data gaps and blockers early, with the owner named

Payroll and Incentive Programs

• Verify qualifying jobs and apply driver credits in the scorecards and SmartMoving

• Calculate tenure-based bonuses and proposed payouts from wages, tenure, and overall scores

• Prepare payroll-ready incentive and bonus totals each pay period and submit them to the payroll manager for approval before cutoff

• Reconcile incentive figures against job records and wage data before payout, and correct any errors

• Update incentive matrix settings each evaluation period, including weights, targets, rating bands, penalties, and thresholds, in line with company policy

Quality Control and Review Checks

• Audit previous-day jobs in SmartMoving and send customer QC emails

• Consolidate missing estimate information and post the QC report in Asana

• Complete weekly review checks across all locations, assign driver credits, and post the report

• Track damage claims, incidents, and Motive safety scores for each driver

Documentation and Communication

• Maintain SOPs and setup instructions for every scorecard and workflow you own

• Handle ad-hoc data pulls and analysis requests from the clients leadership

• Submit daily EOD and weekly EOW reports

What You Bring

Must Have

• 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

Nice to Have

• SmartMoving or another moving-industry CRM

• RingCentral, Qube Sheets, Asana, Motive, or Samsara

• Zapier, Make, APIs, and webhooks

• Dashboard building in Looker Studio or similar

• AI tools for data summaries, report drafts, or workflow automation

• SOP writing

Tools Youll Use

SmartMoving, Google Sheets, Google Apps Script, Excel, Looker Studio, Gmail, RingCentral, Asana, Motive, Samsara, Qube Sheets, Google Docs

Schedule and Work Setup

• Full-time, remote, 40 hours per week, Monday to Friday, during U.S. business hours

• Previous-day reports due at the start of each business day

• Monday and Friday check-ins with the client (15 to 30 minutes)

• Overtime only with prior approval