Automation & Data Analytics Architect (Remote)

Hyre; Oregon; Híbrido; USD 90.000 - 130.000; Tempo integral

Benefícios oferecidos por esta vaga

Work with international clients

Paid time off

Hyre Academy access

Resumo da vaga

Hyre is seeking an Automation & Data Analytics Specialist (Moving & Storage) for remote work in the U.S. The role focuses on automating scorecards, dashboards, and payroll data across multiple departments for a moving and storage company.

You will build scalable BI solutions, automate data pipelines, and enforce data quality with SOPs. Excellent Google Sheets/Apps Script skills and experience with cross-system data reconciliation are required.

Qualificações

• 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.
• Strong data and spreadsheet skills, including experience with dashboards like Google Canvas. Must be able to provide samples of scorecards, dashboards, or trackers you have built.
• 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

Responsabilidades

• 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, evaluating transitions from spreadsheet-based models to dedicated BI platforms or custom web reporting applications
• 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
• 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
• 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
• 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
• Maintain SOPs and setup instructions for every scorecard and workflow you own
• Handle ad-hoc data pulls and analysis requests from the client's leadership
• Submit daily EOD and weekly EOW reports
• Contractor Perks: Work with international clients while maintaining independent contractor status, etc.

Conhecimentos

Google Sheets

Google Apps Script

Scorecards

Payroll data

Data reconciliation

Written English

Home office setup

Data analytics

Dashboarding

Looker Studio

Ferramentas

SmartMoving

RingCentral

Qube Sheets

Asana

Motive

Samsara

Google Canvas

Looker Studio

Descrição da vaga

Hyre is seeking an Automation & Data Analytics Specialist (Moving & Storage) for remote work in the U.S. The role focuses on automating scorecards, dashboards, and payroll data across multiple departments for a moving and storage company.

You will build scalable BI solutions, automate data pipelines, and enforce data quality with SOPs. Excellent Google Sheets/Apps Script skills and experience with cross-system data reconciliation are required.